Actually, I am working on an another project and I am stuck at copying the formula, may be you can help me with that.
I have a total of 13 sheets ...12 of them renamed to Jan, Feb, Mar, Apr...upto Dec,
Sheet13 renamed to Accounts.
In each sheet Jan to Dec ...on daily basis data is entered. Everything is fine. In the
Account sheet data is taken from each sheet (Jan to Dec)...
for example (in Account sheet)
=IF(Jan!$A1="","",(Jan!$A$2))
=IF(Jan!$A3="","",(Jan!$A$4))
=IF(Jan!$A5="","",(Jan!$A$6))
Its easy to copy paste the formula for all 31 days in Jan, but when it comes
to Feb, how do I copy paste the formula? for example
=IF(Feb!$A1="","",(Feb!$A$2))
=IF(Feb!$A1="","",(Feb!$A$2))
=IF(Feb!$A3="","",(Feb!$A$4))
rename Jan to Feb, then Jan to Mar, Jan to Apr...and so on...
Please help.
Thanks.
|