G
Guest
I need to copy a large line containing many formulas and replicate it to as
many as 1,000 additional rows. My problem is I know that the $ is used to
keep consistency in the cells (which I need) but I am looking to increment
the referencing sheets. For example: =+'DM-001'!$B$29 is my formula. The
'DM-001' is my worksheet name and I need to increment to 'DM-002' and so on
while maintaining the B29 cell. That part I've figured out. But when I copy
the rows I'd like worsheets to increment automatically--without my having to
manually enter them within every cell. I have about 20 columns on each row
to copy. Thank you.
many as 1,000 additional rows. My problem is I know that the $ is used to
keep consistency in the cells (which I need) but I am looking to increment
the referencing sheets. For example: =+'DM-001'!$B$29 is my formula. The
'DM-001' is my worksheet name and I need to increment to 'DM-002' and so on
while maintaining the B29 cell. That part I've figured out. But when I copy
the rows I'd like worsheets to increment automatically--without my having to
manually enter them within every cell. I have about 20 columns on each row
to copy. Thank you.