Hello,
First post, so be gentle
The workbook consists of two different types of worksheets:
1.) We'll call this one the "Summary" worksheet (in which there will only ever be one of)
2.) We'll call this one the "Center" worksheet (in which there could be 1 to many)
In row 1 (and descending) will list all open "accounts" in a company (several hundred)...then using a suppress zero macro to limit which accounts have values when I run my program I should have my basic "Summary" worksheet complete.
I believe I can create the macro to suppress zero's using a record macro, but the problem is if I have to repeat this set for every "Center" worksheet? Or is there a method for copying and pasting the VBA code from worksheet to worksheet?
/ Secondly, I will be using a program called "F9" to run these files overnight and I can have the program space out when each individual file is run, but when it gets to a workbook that has 100 "center" tabs I have a sneaky feeling it will time out.....so when the macro runs to suppress zeros it there a way to lag it? Some sort of time delay to say, "If there are three worksheets, "A" "B" "C" have macro run "A" wait 5 min and then run "B" wait 5 min and then run "C"?
Thank you for your help
First post, so be gentle
The workbook consists of two different types of worksheets:
1.) We'll call this one the "Summary" worksheet (in which there will only ever be one of)
2.) We'll call this one the "Center" worksheet (in which there could be 1 to many)
In row 1 (and descending) will list all open "accounts" in a company (several hundred)...then using a suppress zero macro to limit which accounts have values when I run my program I should have my basic "Summary" worksheet complete.
I believe I can create the macro to suppress zero's using a record macro, but the problem is if I have to repeat this set for every "Center" worksheet? Or is there a method for copying and pasting the VBA code from worksheet to worksheet?
/ Secondly, I will be using a program called "F9" to run these files overnight and I can have the program space out when each individual file is run, but when it gets to a workbook that has 100 "center" tabs I have a sneaky feeling it will time out.....so when the macro runs to suppress zeros it there a way to lag it? Some sort of time delay to say, "If there are three worksheets, "A" "B" "C" have macro run "A" wait 5 min and then run "B" wait 5 min and then run "C"?
Thank you for your help