Hello Excel Forum,
I am looking for some assitance & guidance with the spreadsheet I am working on. I've attached a dummy file to help further explain things (saved in zip format).
TAB1 contains all data that will be entered manually. Once a specific cell (Data6) is entered, I would like the entire row with corresponding data to transfer to the TAB2 sheet. The next row shifts up & remains until the last variable is entered. The tricky part is that each value entered in TAB1 will be in a specific column/spot in the TAB2 worksheet.
I hope that this makes sense as it is difficult to explain in words, it can best be referenced in the attached file. Any help or advise is greatly appreciated.
Thanks
-JR
Bookmarks