I just asked a similar question but I think I can simplify my question.
I have two sheets, Sheet 1 and Sheet 2. Both have two columns in column A on both sheets is a date. I want to copy the data in column B on sheet 1 and paste it in column B in sheet 2 if it matches the date from Sheet 1. I am new to Macros and would love some advice on this. Thanks!
Hi RedMug,
You can do this without the need f a macro, ie assuming the data starts at row 2, put this formula into cell B2 of Sheet2...
=IFERROR(VLOOKUP(A2,Sheet1!A:B,2,FALSE),"")
...and copy down as far as required.
HTH
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
Thank you very much for the response Trebor76,
I had to change the A2 to A:A to get the formula to run correctly. But that did the trick and the formula works. However I have hit a snag with it. Sheet 1 gets its data from a web source so it is deleted and pulled again from the webpage daily. (this just allows for todays data to be uploaded to the existing running list)
My problem is the formula you gave me breaks when the data is deleted. I the error below happens. Any suggestions?
=IFERROR(VLOOKUP(A:A,'Sheet1'!#REF!,2,FALSE),"")
I got around the REF# error by Copying Sheet1 after the data pull and Pasting by Values onto a third sheet then running the formula off of the third sheet.
That surprises me as you can't pass an entire column as the value argument for a VLOOKUP functionI had to change the A2 to A:A to get the formula to run correctly.
Remove the IFERROR function and see what what happens.
Robert
It's ok the A:A works just fine for the formula.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks