F
Fan924
Excel 97 macro. I need to read cells on a worksheet and use that as an
address to paste data to. It sounds easy and probably is. But
everything I try is not working.
A B C
1 SheetNo RowNo ColumNo
2 sheet2 1134 3
3 sheet3 2278 3
4 sheet4 3389 3
on sheet1 read A2
read B2
read C2
It should copy cells A1100 of sheet2 and paste the date to sheet1
column 3
row 1134
copy cells A1100 of sheet3 and paste the date to sheet2
column 3
row 2278
etc.
I can copy cells, paste cells, change worksheets, and change
workbooks. Mostly thanks to help from these forums. I can't read three
cells and assign data to three variables (SheetNo, RowNo, ColumNo) and
make it work. Sigh.
address to paste data to. It sounds easy and probably is. But
everything I try is not working.
A B C
1 SheetNo RowNo ColumNo
2 sheet2 1134 3
3 sheet3 2278 3
4 sheet4 3389 3
on sheet1 read A2
read B2
read C2
It should copy cells A1100 of sheet2 and paste the date to sheet1
column 3
row 1134
copy cells A1100 of sheet3 and paste the date to sheet2
column 3
row 2278
etc.
I can copy cells, paste cells, change worksheets, and change
workbooks. Mostly thanks to help from these forums. I can't read three
cells and assign data to three variables (SheetNo, RowNo, ColumNo) and
make it work. Sigh.