how to copy cell formulas of one workbook to same formulas of another workbook

Dear Sir/Madam


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

Leave a Reply

Your email address will not be published. Required fields are marked *