Hi Guys,
Im having an issue with a vlookup cell ref (J3) in workbook1 sheet1 to lookup a date in workbook2 sheet1 (range b5:e2000), then to copy and paste the 3 corresponding columns on the right from workbook2 sheet1 to workbook1 sheet1 C7.
Any ideas?
Thanks Ash
Last edited by ashleye; 01-04-2011 at 10:22 AM.
Hello ashleye,
Welcome to the Forum!
Can you post your workbook? It would also help to know if you want a non VBA solution.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi Leith,
Thanks for the response, my workbook1 is 40Mb and workbook2 is 24Mb so I dont wish to post the items as they contain sensitive information. I need to repeat the VBA code that is produced 18 times to get what I need out of this function. A non VBA solution, a more manual approach is what im trying to get away from.
Hello ashleye,
You should post what code you do have.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks