Missing tab reference in formula

[Thomas Kuriakose]

Respected Sirs,

We have 5 tabs of data and a summary tab.

The summary tab is a summation of the values from tab 1,2,3,4.

The user missed out to add the 5th tab cell reference in the summation.

What is the fastest or shortcut way to add the 5th tab cell reference in the summary tab.

Kindly find attached the sample file.

Thank you very much,

with regards,
thomas

 

[vletm]

Thomas Kuriakose
1) add manually that 5th tab to every 'white' cell
2) modify 1..5 tabs layout as someone would easier to copy formulas
(maybe there are good reason for empty columns 'D,E,F' and 'H,I')
3) modify 1..5 tabs layouts as it would be useful to get sum sheet with many variations.

 

[Thomas Kuriakose]

Respected Sir,

Thank you very much for your support.

This is the sample data. The tabs 1...5 have other data between columns D,E,F and H,I in original file.

Sir, is there a way to find and replace with the missing cell reference.

Thank you very much once again,

with regards,
thomas

 

[vletm]

find & replace: as written in 1) ( every 'white' cells )

 

[NARAYANK991]

Hi ,

See the attached file.

Narayan

 

[Thomas Kuriakose]

Respected Sir,

Thank you so much for this solution provided.

Much appreciated.

Sir, just to share i used Ctrl+Tilde keys to display all the formulas in the cells and then manually added the 5th tab references which was cumbersome.

But your solution is magical. Thank you very much for this insight.

with regards,
thomas