Hi,
Thanks completebhejafry! However, this formula returns (#value). The return value from sheet 2 is text, does this affect how the formula should work?
-Injinia
Hi,
I have two sheets. Column A on both sheets has around 10000 numbers that are randomly input. Sheet 2 has data in columns B:G. I would like to match the numbers in sheet 1 and 2 and have the data B:G copied on sheet 1 if the number in column A matches in sheet 2.
-Injinia
Hi,
I am a novice when it comes to VBA, but I will try my best to explain. On the sheet accuracy, I have data which I want to be able to copy and paste on Sheet 1, every time i run the macro. The data on Sheet "accuracy is always in the same cells. I would like that the macro copies this data...
I would like help to write a macro that copys data and pastes it on a new sheet always on the next empty row. I have this but it keeps on giving me an error @ " Set emptyCells = Range("A:A").SpecialCells(xlCellTypeBlanks)"
Sheets("accuracy").Select
Range("B23:L29").Select
Selection.Copy...