I have joined a new firm where I need to create a new excel sheet from an existing workbook, where I need to collect some specific meter readings from no: of readings, Well that was easy since I only need to click the cell “equals to the source cell”.
But the problem is that I cannot copy this formula create the same kind of sheet in next months the same report. when I tried to copy the cells from the previous workbook it creates the same reading of that month.
Here I need your help, I want to create a sheet-like C3=A3 for multiple workbooks. so that when I copy that sheet to any workbook it automatically collect similar data on that workbook.
Awaiting your reply
By: Faiz Ma