Hi,
I the below code and it works perfectly for me and grabs the data I need. However I also need to pull another cell value out which is not in the current range.
how do I do this?
As always appreciate the help.
Please Login or Register to view this content.
You'll need to explain this fully.Originally Posted by tejboyd
_________________
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!)
Apologies...
For example the current range of data I grab from the files is E7:G8.
However I will also need to pull out a value from cell K8.
How do I add it to this section of codeHope this makes more sensePlease Login or Register to view this content.
And do what with it? Where exactly should it go in the paste in relation to where the original copied data is going?
The original data is pasted into cells C,D,E. I need the additional value from K8 to be pasted into F1.
This should then continue for every file that is opened using the macro.
This should work:
Please Login or Register to view this content.
Thanks so much. Worked perfectly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks