How to Copy a sum of a column from different Excel sheets to a single master excel sheet?

S

Sriram

Hi,
Need help to write a macros. There is a master excel sheet(Master.xls) which
has 3 columns date wise from 1st to 31st. For each day, there is another
Excel sheet(Say daily.xls). The expectation is to write a macros which if
run, will fetch the sum of a particular column from daily.xls and copy it to
the cell in the master.xls on that particular date. This should happen for
all the daily.xls sheet. Please adivce how this can be done. Any help is
highly appreciated.

Thanks

url:http://www.ureader.com/gp/1037-1.aspx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy range from multiple files in multiple folders to single sheet in master WB 10
Excel template that is able to collect data from other excel sheetsbased on different criterias 0
Copy some of selected columns to master sheet 3
Want code to copy to ABOVE row 22 column A on sheet 1 10
Code to copy column in sheet 1 to column in sheet 2 based on matched criteria 0
Creating several smaller worksheets from a 'master sheet' 2
Macro to Consolidate Data from Various Excel Files 1
Create Sheets from a Range and Copy Data on copy Data on newlycreated Sheets with the Sheet Names 2

Top