I have a workbook with a separate tab for each date a deposit is made. The following formula is used to pull info from "Daily Master.xmls":
='[APR 02, 2013.xlsm]Deposit Recon'!$E$6
I have about 50 formulas similar to this on every tab.
Is there a way to automatically change the formula on the successive tabs so that it will increment the formulas as follows
='[APR 03, 2013.xlsm]Deposit Recon'!$E$6
='[APR 04, 2013.xlsm]Deposit Recon'!$E$6
='[APR 05, 2013.xlsm]Deposit Recon'!$E$6
='[APR 06, 2013.xlsm]Deposit Recon'!$E$6 etc.
I would prefer to do this without VBA if anyone knows how to do that, but will use vba if it is the only option (for some reason VBA is frowned upon in this establishment and I will get my knucles rapped).Thanks for any insights you can provide.
='[APR 02, 2013.xlsm]Deposit Recon'!$E$6
I have about 50 formulas similar to this on every tab.
Is there a way to automatically change the formula on the successive tabs so that it will increment the formulas as follows
='[APR 03, 2013.xlsm]Deposit Recon'!$E$6
='[APR 04, 2013.xlsm]Deposit Recon'!$E$6
='[APR 05, 2013.xlsm]Deposit Recon'!$E$6
='[APR 06, 2013.xlsm]Deposit Recon'!$E$6 etc.
I would prefer to do this without VBA if anyone knows how to do that, but will use vba if it is the only option (for some reason VBA is frowned upon in this establishment and I will get my knucles rapped).Thanks for any insights you can provide.
Last edited: