Excel vba - Loop an existing macro to copy data into a single shet

$10-30 AUD

Opravljeno

Objavljeno

pred približno 4 leti

$10-30 AUD

Plačilo ob dostavi

I am unable to find an example on google of what i want to do to the attached macro. I want to:- 1. Open a data workbook 2. Within the workbook merge the sheets 3. Copy the data into a master sheet 4. Close the data workbook 5. Open the next data sheet (there are 50 data sheets) 6. Copy the data into the master sheet 7. The final product will be the master workbook with 10,000 rows in a single sheet containing all of the data The final product will be a master sheet containing all of the data from 25 seperate data sheets. The sheet attached contains the macro i have setup. I want a loop added to this macro so that 50 data sheets are opended. I have attached 3 data sheets for reference. I want my existing macro updated to loop, so i assume its a 15 minute job for someone who knows vba in excel. Please read the existing macro in the .xlsm instead of asking 1000 questions.

Excel

Visual Basic

Data Processing

Visual Basic for Apps

Excel Macros

ID projekta: 23986711

Več o projektu

9 ponudb

Projekt na daljavo

Aktivno pred 4 leti

Želite zaslužiti?

E-naslov

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir

Prejmite plačilo za svoje delo

Povzetek predloga

Registracija in oddajanje ponudb sta brezplačna

Dodeljeno:

@sivashamdz

I understand But i could not find the attached master workbook. Kindly upload. Lets discuss. Thanks, Siva.

$30 AUD v 1 dnevu

5,0

(4 ocen)

2,6

9 freelancerjev je oddalo ponudbo s povprečno vrednostjo $45 AUD za to delo

@ssuet123

Hey there, Hope you are doing fine. I have been doing work in Microsoft scripting, VBA, formulas, graphs and dashboard creation using pivots, for the past 5 years. I have read all your requirements and can do this job perfectly for you if you share more details about it. Let's talk and discuss the projects for which you want me to work. Waiting for your response.

$30 AUD v 1 dnevu

5,0

(15 ocen)

6,3

@citijayamala

1. I am an expert in Excel,VBA, Excel formulas, and all excel functions, macros, lookup, pivot tables and charts. I read your project description and I am sure that I can handle your project. 2. Have done many projects in Excel, created many dashboards, and Business intelligence tool for forex markets. Experienced MBA Finance as well. 3. Your project will be delivered on time with high standard 4. Assistance will be provided with number of clarifications until client satisfaction

$200 AUD v 3 dneh

4,8

(71 ocen)

5,7

@superseoservice

Dear Hiring Manager, After carefully reading the requirements of the project, I believe that my strong experience and dedication make me a suitable match for this. I have completed some similar projects in the past with 100% satisfaction and result. I am really excited to apply for this project and very hopeful to get a chance to work with you! Thank you.

$30 AUD v 1 dnevu