Problems getting data from external workbook

Hi guys!

This is my first post here, so please be gentle!

right, time to get down and dirty with some code

Basically, im copying data from a separate workbook, and then trying to add "1" to the value...
Apparently this is easier said than done...!!! I have 2 pieces of code, which work when run on there own, i just need to run them together now. obviously copying the data first, then adding "1" the the data that ive just copied...

Please Login or Register  to view this content.

Please Login or Register  to view this content.

right thats the 2 pieces of code... work lovely on their own!
now there is a 3rd piece of code, saved as a macro, that the first piece of code refers to, in order to copy the data... if thats needed too, let me know...

but other than that, theres nothing else to it... now ive tried having them all in the same "sub" but doesnt work...

is there anyway i can combine these together? or too run one after the other... they run on startup of the workbook btw...

Hope that all makes sense...

look foward to some help from some awesome coders!

Adrian


------------------
SOLVED
------------------

Please Login or Register  to view this content.

Just incase anyone needs it...

Thank you for posting the solution. In future, it will be nice if you post the solution as a separate post, so we can clearly distinguish between the question and the answer.