Create a macro that will continuously copy multiple sheets into one sheet

This project received 17 bids from talented freelancers with an average bid price of $103 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$30 - $250 USD
Total Bids
Project Description

I have an excel file with multiple (more than 20) spreadsheets, each spreadsheet contains some data. I need to create a macro that will copy three columns that are located at different locations from each spreadsheet and paste the data from the three columns into another summary spreadsheet.

The macro must be able to update the summary spreadsheet when I make changes in the multiple (more than 20) spreadsheets and also copy three columns when I add a new sheet.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online