I have a spreadsheet that our salesmen fill in
Sheet 1 From A1 through to K1, this sheet is used to record stock taken.
What I would like is on sheet2 to keep a record for each transaction from sheet 1
This would be in cells A1 – K1, and would list down in the next available row for each new transaction
Not sure is a formula would do this or thru VBA
EG;
Sheet 1
A1= Blue, B1 = KF3PB1, C1 = 04/12/2020, D1 = Ken, E1 = Courier, etc
Then Sheet 2
A1= Sheet 1 A1, B1= Sheet 1 B1, C1 = Sheet 1 C1 etc
Then if sheet 1 is used again then the next available row (A2 – K2) would be filled, leaving the info in Row A
Your help or suggestions would be much appreciated
Sheet 1 From A1 through to K1, this sheet is used to record stock taken.
What I would like is on sheet2 to keep a record for each transaction from sheet 1
This would be in cells A1 – K1, and would list down in the next available row for each new transaction
Not sure is a formula would do this or thru VBA
EG;
Sheet 1
A1= Blue, B1 = KF3PB1, C1 = 04/12/2020, D1 = Ken, E1 = Courier, etc
Then Sheet 2
A1= Sheet 1 A1, B1= Sheet 1 B1, C1 = Sheet 1 C1 etc
Then if sheet 1 is used again then the next available row (A2 – K2) would be filled, leaving the info in Row A
Your help or suggestions would be much appreciated