P
Pablo
Dear reader,
I have a bit of a problem copying from one worksheet to another. I need to
copy some dates from worksheet B to worksheet A. Currently these worksheets
are set up this way
WORKSHEET A -
A B
1 Part Date
2 xy 3/24/08 Formula used: =(worksheetb!B5)
3 yz (I would like a formula that will skip four rows and copy cell
B9
WORKSHEET B (contains the data I need to copy)
A B
1 Part Date
2
3 (Cells A2:A5 are merged)
4
5 xy 3/24/08
6
7 (Cells A6:A9 are merged)
8
9 yz 3/25/09
Please help!
I have a bit of a problem copying from one worksheet to another. I need to
copy some dates from worksheet B to worksheet A. Currently these worksheets
are set up this way
WORKSHEET A -
A B
1 Part Date
2 xy 3/24/08 Formula used: =(worksheetb!B5)
3 yz (I would like a formula that will skip four rows and copy cell
B9
WORKSHEET B (contains the data I need to copy)
A B
1 Part Date
2
3 (Cells A2:A5 are merged)
4
5 xy 3/24/08
6
7 (Cells A6:A9 are merged)
8
9 yz 3/25/09
Please help!