Macro to add a row if cell has a value and copy certain cell

August 24, 2017 at 23:23:22
Specs: Windows 10
Hi all,
I maintain master data sheet with the following data.

	A	B	C	D	E	F	G	H	I	J	K
1				First Invoice				Second Invoice			
2	Partner	Client	Role	Invoice Date	Amount	Receipt date	Amount	Invoice Date	Amount	Receipt date	Amount
3	A	1	Hr	1-Jan-17	27500	8-Jan-17	27500	Jan-17	27500	Feb-17	27500
4	B	2	Fin	17-Mar-17	8100	8-May-17	8100				0
5	C	3	Mtg	11-May-17	27500	21-Jun-17	27500	Aug-17	27500		0
6	D	4	SCM	25-Apr-17	17666	16-May-17	17666	May-17	17666	Jun-17	17666

I also have columns for the third and fourth invoice in the same pattern but for the sake of simplicity I have not copied them.

I need a macro that, in first step, adds a row if Column D "Invoice Date" has a value and then copies Column A,B,C & the column it is checking for value, in this case its "D".

In the second step I want the Macro to check Column J "Invoice Date" and follow the same procedure

I want the macro to follow the same procedure for all occupied rows and paste the data in a seperate sheet.

Thanks in advance !

message edited by user119


See More: Macro to add a row if cell has a value and copy certain cell

Reply ↓  Report •
Related Solutions


Ask Question