mechengineer
New Member
- Joined
- Aug 11, 2014
- Messages
- 14
I have a front page worksheet called "LIVE REPORT" that should always show the number in my DailyElect worksheet that is column H row 34 (H34 is also a formula that looks like this =G34*$H$2 but I have to delete a row and add a row daily and when I delete the rows it changes it from what was row 34 to know row 33, I used the Indirect function but it keeps giving me a REF error. Please help
This is the formula as of right now =DailyElect!H34 and I tried =INDIRECT(DailyElect!H34) but it keeps giving me #REF!
This is the formula as of right now =DailyElect!H34 and I tried =INDIRECT(DailyElect!H34) but it keeps giving me #REF!