Hello.
Is there a way to automatically add a new row (to create a duplicate of the first tab using = data from first row) after every existing row containing v_look_up data from second tab of same worksheet?
For example
1 A (data being pulled from second tab within sme worksheet)
2 D (data being pulled from second tab within sme worksheet)
3 G (data being pulled from second tab within sme worksheet)
Turning into
1 A (data being pulled from second tab within sme worksheet)
(empty row)
2 D (data being pulled from second tab within sme worksheet)
(empty row)
3 G (data being pulled from second tab within sme worksheet)
I need to keep the V_look_up in first row so I can not copy and paste special for when I update the spreadsheet in the second tab I would like for the first tab to update as well. Make sense?
Thank you in advance.
Bookmarks