Hello,
Thanks ahead of time for any help offered. I will try my best to explain what I am trying to do. I have a workbook, it has several sheets. The first sheet has customer info. The remaining sheets provided reports and lists based on that data.
I am trying to copy my formula that is pulling data from the customer info sheet to another sheet. Becuase of the way I have formatted my data I cannot create a database list, so I have been using formulas similar to this;
=IF('Sheet1'!D47=0, "N/A",'Sheet1'!D47)
With this code entered in cell A1 of sheet 2 I get either N/A if there is no data in cell D47 on sheet1 or I get whatever data is in cell D47 on sheet1...
What I would like to do is copy this formula down the next remaining cells. A1:A100. BUT, I need the cell reference to change automatically by 33 cells, for instance;
=IF('Sheet1'!D47=0, "N/A",'Sheet1'!D47)
=IF('Sheet1'!D80=0, "N/A",'Sheet1'!D80)
=IF('Sheet1'!D113=0, "N/A",'Sheet1'!D113)
So far I have been doing this by hand and with a calculator. If someone is willing to help with this I would really appreciate it! If someone would like to help but needs to see the workbook I will be happy to email it but cannot share it here in public. Thanks!