rsrasc
10-26-2020, 10:34 AM
Hello all,
I have approximately 35 files that I need some help.
I’m attaching the following file named “450 FY 2021 Expenses-SSE-Budget”
On it, I have four (4) tabs:
They are:
FY 21-Budget-Expenses-Option2
7-5 Reforecast
7-5 Reforecast Sample---this is the tab showing the final result after copying the information.
Accounts
If you go to tab “FY 21-Budget-Expenses-Option2” and go to cell C14 you will see the following info:
56220 Credit Card Fees-All Others
If you look at cell C20 you will see the same value: 56220 Credit Card Fees-All Others
With a macro, I would like to copy all the information within this account and other accounts:
“56220 Credit Card Fees-All Others”
The specific information in this case is between cell C15 and C19
In any case, if there is no information between these two cells (C15 and C19), then the macro should exclude or skips the blank items)
Therefore, if there is information in any cell in Column C depending on this value mentioned above, it should copy the entire row to the “7-5 Reforecast” tab, where the description should go to cell B125 and down, and the amounts from cells H thru S in the tab “FY 21-Budget-Expenses-Option2” should be copy to Column C thru Column N in tab “7-5 Reforecast”.
To finalize, it will a nice addition if I can run the macro for different accounts at the same time.
For example,
56220 Credit Card Fees-All Others
56500 Bank Service Charges
57700 Office & Computer Supplies
59990 Other
If possible, if the account number could also be copy with the macro to Column A in the tab “7-5 Reforecast”, that will be perfect.
As always, thank you for your support.
rsrasc
I have approximately 35 files that I need some help.
I’m attaching the following file named “450 FY 2021 Expenses-SSE-Budget”
On it, I have four (4) tabs:
They are:
FY 21-Budget-Expenses-Option2
7-5 Reforecast
7-5 Reforecast Sample---this is the tab showing the final result after copying the information.
Accounts
If you go to tab “FY 21-Budget-Expenses-Option2” and go to cell C14 you will see the following info:
56220 Credit Card Fees-All Others
If you look at cell C20 you will see the same value: 56220 Credit Card Fees-All Others
With a macro, I would like to copy all the information within this account and other accounts:
“56220 Credit Card Fees-All Others”
The specific information in this case is between cell C15 and C19
In any case, if there is no information between these two cells (C15 and C19), then the macro should exclude or skips the blank items)
Therefore, if there is information in any cell in Column C depending on this value mentioned above, it should copy the entire row to the “7-5 Reforecast” tab, where the description should go to cell B125 and down, and the amounts from cells H thru S in the tab “FY 21-Budget-Expenses-Option2” should be copy to Column C thru Column N in tab “7-5 Reforecast”.
To finalize, it will a nice addition if I can run the macro for different accounts at the same time.
For example,
56220 Credit Card Fees-All Others
56500 Bank Service Charges
57700 Office & Computer Supplies
59990 Other
If possible, if the account number could also be copy with the macro to Column A in the tab “7-5 Reforecast”, that will be perfect.
As always, thank you for your support.
rsrasc