abdulhafeez
New Member
Dear all,
Good day!
I want to copy and paste data automatically, using INDEX and ROW functions. Source sheet contains data of purchase orders and destination sheet is mix of Purchase and Sale orders.
SOURCE SHEET
A B
1
P.Order #
Date
2
P1
3
P1
4
P2
5
P3
DESTINATION SHEET
A B C
1
Order type
Date
Amount
2
P1
3
P1
4
P2
5
S1
6
S2
7
P3
Using Formula "INDEX([Source sheet,P.Order #],ROW(A2)-ROW($A$1)", Values from source sheet are copied in destination sheet. When I write S1 and S2 manually in Row 5 and 6 of destination sheet, Contents of Row 5 of source sheet "P3" is not copied. I want to skip the copying in manually written cells (S1 and S2) and copy P3 in Row A7.
What will be the formula for it?
Good day!
I want to copy and paste data automatically, using INDEX and ROW functions. Source sheet contains data of purchase orders and destination sheet is mix of Purchase and Sale orders.
SOURCE SHEET
A B
1
P.Order #
Date
2
P1
3
P1
4
P2
5
P3
DESTINATION SHEET
A B C
1
Order type
Date
Amount
2
P1
3
P1
4
P2
5
S1
6
S2
7
P3
Using Formula "INDEX([Source sheet,P.Order #],ROW(A2)-ROW($A$1)", Values from source sheet are copied in destination sheet. When I write S1 and S2 manually in Row 5 and 6 of destination sheet, Contents of Row 5 of source sheet "P3" is not copied. I want to skip the copying in manually written cells (S1 and S2) and copy P3 in Row A7.
What will be the formula for it?