Hello first up many thanks for taking the time to look at my problem! The problem essentially invloves offsetins some data and replacing one of the values based on indexing a name in a one list, and locating it in the next :S Very hard to explain! Please see example much clearer!
Many thanks
Alan
Last edited by ad9051; 06-15-2011 at 01:36 PM.
Something like this:
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!)
Thats brilliant, i can edit it to make it work for my working example! What changes do i need to make to make reference a sheet in a different workbook?
Your reputation has allredy been ammended by the way!
Many thanks
Alan
That opens a whole other can of worms.Originally Posted by ad9051
1) Which of the two sheets referenced in the existing macro is in this "other workbook"?
2) What's the full path and name to this other workbook?
3) Should the macro check to see if the other workbook is even open?
4) If not open, it would need to open it, yes?
5) When the macro is done, it needs to close the other workbook if it was closed originally, yes?
This simple question adds a magnitude issues. Defensive coding....
Thank you verymuch for your reply, i understand this does add some complexity to the problem.
My answeres are the following:-
1) The "Master Sheet" sheet is the one what will need to be opened
2)3) Yes, if already open continuePlease Login or Register to view this content.
4) Yes, if its not open it will need to open
5) It will need to close every time its finished regardless of its previous state.
Many thanks
Alan
Give this a whirl, i assumes this macro has been inserted into the workbook containing the Data Input sheet:
Please Login or Register to view this content.
Brilliant! It seems to be quite a laggy/slow macro, but it does the job! Marked as solved thankyou very very much!
All the best Alan
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks