This Macro is supposed to get certain totals for me from diffrent pages. Instead of selecting an entire row I want to select specific cells, so when it finds the word total on the sheet, whose location can change often it will return the value two cells away. How can I change this code below ?
Please Login or Register to view this content.
Last edited by itsnick; 10-29-2009 at 09:08 AM.
Try this:
This finds the word TOTAL and copied the cell two columns to the right to the other sheet.Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
This works thank you JBeaucaire.
I have one more question before I mark this solved. If I wanted to copy two or three cells instead of one. What changes would have to be made ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks