Käynnissä

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

Notes:

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)

Taidot: Excel, Visual Basic for Apps

Näytä lisää: xls header, xls excel expert, urgent vba excel expert, ask expert excel vba, paste special excel vba, paste destination excel vba, paste options excel vba, paste protected excel vba, paste values excel vba

About the Employer:
( 31 reviews ) Chermside, Australia

Projektin tunnus: #8647486

Myönnetty käyttäjälle:

bossumd

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)
2.4

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

zExcel

A proposal has not yet been provided

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

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)
6.0
paris2785

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)
5.4
fabest

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)
5.4
kevivu

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)
5.0
diegogarcia0531

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)
4.9
zebracaro

I can do it for you quickly and exactly

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

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)
4.0
surekash7096

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)
4.0
vsprybhanu

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)
3.8
stanleyw12

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)
0.0
cristianfirmino

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)
0.0
MLM4E

- 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)
0.0
geoa7med

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)
0.0
tassadduqeali

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)
0.0
chriscalma

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)
0.0
DanielShiel

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)
0.0
khanbilal72

A proposal has not yet been provided

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

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)
0.0
aleopoldino

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)
0.0