|
The quick and dirty way I can think of answering question 1 does involve a small amount of VBA knowledge, but not a lot. Depending on how large each sheet is, it could take some tedious initial setup.
But the basic steps are:
1) start recording a macro
2) copy a sheet to a new sheet
3) manually change everything you want to change
4) stop recording the macro
5) (this is the tricky part, and I'd need to do some learning myself to get it right) edit the macro.
5a) You should see that it's saying to copy specifically whichever sheet you recorded the macro from. Change it to whatever the syntax is that means "current sheet'.
5b) you'll see a line for each edit you made explicitly setting the cell to whatever you set it to. Change that to a formula that increments it from the same cell on the current sheet.
If you've got a mind to go that route, I can help you get steps 5a and 5b right later this evening.
__________________
'He who receives an idea from me, receives instruction himself without lessening mine; as he who lights his taper at mine, receives light without darkening me.'
-TJ
|