T
tralbert
Needling a little more help please. I have a workbook with 4 worksheets in it
that tracks data for 90 days. They are generally as follows:
Sheet 1-weekly
Sheet2-monthly
Sheet3-weekly complete
Sheet4-monthly complete
The data in columns A-F, K, P and U in Sheet1-weekly are currently linked to
columns A-F, L, R and W in Sheet2-monthly. Sheet1-weekly will always be
completed before I get all of the data for Sheet2-monthly so I will move the
completed rows in Sheet1-weekly to Sheet3-weekly complete. However when I do
this it screws up the link formulas I have created in Sheet2-monthly. The
formula I am currently using to link said items is:
=IF('Sheet1-weekly'!A5="","",'Sheet1-weekly'!A5)
Is there a way for me to incorporate where Sheet2-monthly will look at
either Sheet1-weekly or Sheet3-weekly complete to link the data? Could I nest
an OR statement in the argument of the IF statement and that get it to work?
Or am I just smoking a whole lot of crack?
Thanks for the advice!
that tracks data for 90 days. They are generally as follows:
Sheet 1-weekly
Sheet2-monthly
Sheet3-weekly complete
Sheet4-monthly complete
The data in columns A-F, K, P and U in Sheet1-weekly are currently linked to
columns A-F, L, R and W in Sheet2-monthly. Sheet1-weekly will always be
completed before I get all of the data for Sheet2-monthly so I will move the
completed rows in Sheet1-weekly to Sheet3-weekly complete. However when I do
this it screws up the link formulas I have created in Sheet2-monthly. The
formula I am currently using to link said items is:
=IF('Sheet1-weekly'!A5="","",'Sheet1-weekly'!A5)
Is there a way for me to incorporate where Sheet2-monthly will look at
either Sheet1-weekly or Sheet3-weekly complete to link the data? Could I nest
an OR statement in the argument of the IF statement and that get it to work?
Or am I just smoking a whole lot of crack?
Thanks for the advice!