Auto populate rows in Excel

June 13, 2012 at 12:43:01
Specs: Windows XP
I am using the forumla =IF(ISBLANK(Sheet1!A33),"",Sheet1!A33) to insert info from sheet 1 to sheet 2. The problem I'm having is if I delete a row on sheet 1, I get an error message of "#REF!" on the second sheet. How can I automatically 'delete' the same row on sheet 2 so I don't get the error message?

See More: Auto populate rows in Excel

June 13, 2012 at 19:08:12
Your subject line says "auto-populate rows" but your question relates to "automatically deleting rows".


If what you are trying to do is delete the same row on two sheets at the same time, then select both sheet tabs (Ctrl-Click the tabs) and then delete the row from any of the selected sheets.

Remember to select only one sheet before you do anything else or you'll do it to every sheet that is selected.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question