Thread: macro to copy and paste

In source, file contains data of sales and purchase transactions which vary every month and cell location in other file where to paste the same fixed with reference of common codes.

Common codes are available in source file and paste location. Common codes/fields are company code, location code, transaction type code etc. in both the files. And source data is part number, part description and value of part.

Macro is not working properly when source data increased or decreased every month. I have tried combination of functions :[=@if(match code, vlookup, 0)], but not working.


Request is to write a macro which can copy data from source file and paste the same exactly against code in data receiving file. Presently the sufficient rows i.e. 100 rows are left after each code as space to paste data.


Help is requested from all users.

With warm regards to all excel users.

lets see the code, you have been trying...