LinkBack URL
About LinkBacks
Find explaination, its within the file
If someone can give me macro also
that changes formula to value , it will
be cool too since my boss does not
know to paste special correctly , he tends
to forget and it messes calculations
Find explaination, its within the file
If someone can give me macro also
that changes formula to value , it will
be cool too since my boss does not
know to paste special correctly , he tends
to forget and it messes calculations
Quite simple, you could learn this by recording a macro of how to do it, basically you are copying and pasting speacial values & formats to the new sheet.
You will need to put some logic on there for the blank column issue, thats will be an if statement, which you could do in a hidden column and copy that instead, so if(h1="",i1,h1)
Recording macros and inspecting the code is a great way to learn vba.
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
try below
Open Excel sheet
then press Alt+F11
This will open VBE, At the top click insert then click module
Copy paste below
Close VBE go to excel press Alt+F8 this will open macro dialogue box click copypaste and run
Please Login or Register to view this content.
Last edited by hemesh; 05-07-2014 at 07:38 AM.
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
Try this........
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Its giving me run time error 91 ?
Someone please , I want to surprise my boss this eve
Which code you are referring to?
Hurry sktneer yours works
Glad it helped.
If that takes care of your question, please mark your thread as solved.
Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum.
Oops ! Forgot to change. Check I have update the code
Sktneer I just received a chunky tip from my boss , he wants
it even closer
I will close the thread before I do so , say if this raw data is
on certain folder abc on drive c
He has his master file , he wants to pull the data from there
to go read this folder and paste there , the raw data files could
be more than one , is this possible sktneer
we shall try and fix the raw data with the same columns so
the macro reads the desired columns always
Here is part two of the situation , I will close the thread for sure
The boss opening his master file , the raw data that I attached
say is on drive c folder name abc , he than runs the macro on
his file to go get this data that folder , Ouch not sure why he
needs folder automation , his sorted out but his asking it the other
way round
sktneer i have marked thread solved , i have started
new thread part 2 , same technology but from folder fetching
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks