mplees
Active Member
- Joined
- Feb 6, 2006
- Messages
- 351
Hi,
Hope someone can help me out with this. In my workbook on sheet 1, I have a list of jobs & part numbers. On sheet 2 I have headings on alternate rows.
What I am trying to do is when I add data to sheet 1, I copy the inputted data & insert it into sheet 2. Difficult to explain, and I cannot post a sample sheet until I get home, but basically, the layout is:
Sheet 1
A B
1 574999
2 123456
3 456123
4 674556
5 654321
6 574998
7 650987
and so on. The first problem is that the number of items is variable - there could be 1 item or 30 items. The constant is that the job number is always in column A. On sheet 2 I have:
A B
1 =Sheet1!A1
2
3 = next job number on sheet 1
4
and so on. Does anyone have thoughts as to how this could be acomplished? The other important thing is that the formatting on sheet 2 needs to be retained when the rows are inserted.
Hope someone can help me out - all assistance gratefully received as always.
Regards,
Mark
Hope someone can help me out with this. In my workbook on sheet 1, I have a list of jobs & part numbers. On sheet 2 I have headings on alternate rows.
What I am trying to do is when I add data to sheet 1, I copy the inputted data & insert it into sheet 2. Difficult to explain, and I cannot post a sample sheet until I get home, but basically, the layout is:
Sheet 1
A B
1 574999
2 123456
3 456123
4 674556
5 654321
6 574998
7 650987
and so on. The first problem is that the number of items is variable - there could be 1 item or 30 items. The constant is that the job number is always in column A. On sheet 2 I have:
A B
1 =Sheet1!A1
2
3 = next job number on sheet 1
4
and so on. Does anyone have thoughts as to how this could be acomplished? The other important thing is that the formatting on sheet 2 needs to be retained when the rows are inserted.
Hope someone can help me out - all assistance gratefully received as always.
Regards,
Mark