Urgent: Excel VBA copy/paste multiple sheets into one

Need expert EXCEL VBA to let a user to provide the codes within the next 24 hours! (Be Quick!)

1) Open a Master excel file with macro/vba

2) Run the macro/vba which will ask user to select/open another excel file

3) Copy the contents of each sheet (only sheet name starting with "Sheet", e.g. Sheet1 to Sheet 3) . See [url removed, login to view] as an example

4) Paste the content in a single sheet on the Master file. See Master file as an example


5) Number of sheets to copy from can vary.

6) Number of columns in each group will be 7 but the number of groups in each sheet will vary

7) Number of rows in each sheet will vary

8) The value in cells "A1" and "A2", "B2" and "D2" need to be copied in each row for ALL column groups, along with the sheetname and file name. (see example in Master file)

9) The value above column header "c" should be copied in each row for the corresponding column group (see example in Master)

Resource: VBA copy/paste code example:

Freelancer who can demonstrate they have done similar work (or create the codes using the data files provided) will awarded the task (or paid directly)!

Taidot: Excel, Visual Basic for Apps

Näytä lisää: xls header, xls excel expert, urgent vba excel expert, excel 0 to expert, ask excel expert, ask an expert in excel vba, paste special excel vba, runtime error 1004 paste special excel vba, select column copy excel vba macro, paste destination excel vba, cut paste column excel vba, paste options excel vba, paste protected excel vba, copy excel vba web file, cut paste data excel vba, paste values excel vba

Tietoa työnantajasta:
( 31 arvostelua ) Chermside, Australia

Projektin tunnus: #8647486

Myönnetty käyttäjälle:


Hi! I'm Excel Guru, so can do your project fast. Just award me and you'll receive perfect Excel spreadsheet! +++ UPDATED +++ Of course, there will be the macro in result spreadsheet... +++ UPDATED +++ your macro is Lisää

20 $ AUD 0 päivässä
(10 arvostelua)

19 freelanceria on tarjonnut keskimäärin 33 $ tähän työhön


A proposal has not yet been provided

60 $ AUD 1 päivässä
(203 arvostelua)

Hello Sir, I can do it perfectly and I've lot of experience in this type jobs. waiting for your response to start. Regards, Maariyaa

50 $ AUD 1 päivässä
(119 arvostelua)

Hi there - My name is Paris. I've read your brief and can see that you'd like to have a macro-enabled Excel spreadsheet. I have 7 years’ experience designing and developing Excel spreadsheets. I would approach your pr Lisää

39 $ AUD 3 päivässä
(54 arvostelua)

Dear, we are Team of French + US. 11 years experience on Access/Excel/VBA automations. I checked your project description, and I confirm I can develop your program. I will focus on user friendly interface. As you c Lisää

69 $ AUD 3 päivässä
(16 arvostelua)

Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 40 projects, almost 35+ are complex VB/VBA projects, hence i can definitely deliv Lisää

44 $ AUD 1 päivässä
(34 arvostelua)

Hi, I can do the job, I am Excel VBA expert, I did many scripts in the past for different tasks Regards Diego

55 $ AUD 1 päivässä
(18 arvostelua)

I can do it for you quickly and exactly

50 $ AUD 1 päivässä
(40 arvostelua)

Hello, I am Shahed, the clients communication officer from BDtW. Thank you for explaining the requirements clearly. I believe we can do the job for you without much difficulties. Here is a little description of o Lisää

20 $ AUD 1 päivässä
(20 arvostelua)

I have the expertise in scripting in VBA and can deliver this script to copy/paste from multiple files in a couple of hours. Ready to start work now

25 $ AUD 1 päivässä
(18 arvostelua)

Hi, Experienced Excel VBA and VB.Net Programmer. Expertise in Exchange data between sheets, Critical Programming, Developing System for Management and Creating Reports. I've read and understood your project d Lisää

45 $ AUD 1 päivässä
(22 arvostelua)

If the rows and columns are all fixed, it can be done quickly, Do let me know what are the limitations and requirements and how soon you need this.

10 $ AUD 1 päivässä
(0 arvostelua)

Hi, I am very fast to develop VBA functions, I am sure that you will like it. I've done several projects similar to yours.

25 $ AUD 2 päivässä
(0 arvostelua)

- I'm a very advanced Excel user, works with famous data analysis tools like functions & pivot tables and also some other more powerful tools like array formulas & power pivot. - VBA developer with around 4 years expe Lisää

25 $ AUD 1 päivässä
(0 arvostelua)

sir i read you job very good and understand what you want to do in this excel file i have done like this copy past excel file in my job in with etisalat i wait to message me to ask you about somthings like (in thi Lisää

15 $ AUD 1 päivässä
(0 arvostelua)

i can work for you and i am expert in excel work. do hire me and give me a chance. i assure you that i will work good

25 $ AUD 3 päivässä
(0 arvostelua)

Senior IT professional with 17+ years of Excel and VBA. Send me the sheets and I'll have it back to you tomorrow. I've programmed some extremely complex VBA to automate the copying and pasting of cells from columns to Lisää

14 $ AUD 2 päivässä
(0 arvostelua)

Good Afternoon, based on your requirements this is quite a simple task that I can complete in a very short timeframe. However I do believe that you can make this more efficient. Your present description has some iss Lisää

20 $ AUD 1 päivässä
(0 arvostelua)

A proposal has not yet been provided

25 $ AUD 1 päivässä
(1 arvostelu)

This kind of work i have already done so it will be easy for me to complete the work within the given time

15 $ AUD 1 päivässä
(0 arvostelua)

Hi, I have 6+ years working with VBA and Excel and I can code your needs. I already did a project like this one at work, consolidating template worksheets of several areas to update a running project status. I'll Lisää

30 $ AUD 0 päivässä
(0 arvostelua)