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)

Resource: VBA copy/paste code example:
https://msdn.microsoft.com/en-us/library/cc793964(v=office.12).aspx

IMPORTANT:
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:
( 34 arvostelua ) Chermside, Australia

Projektin tunnus: #8647486

18 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

zExcel

A proposal has not yet been provided

$60 AUD 1 päivässä
(252 arvostelua)
7.6
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ä
(56 arvostelua)
7.1
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ä
(125 arvostelua)
6.5
zebracaro

I can do it for you quickly and exactly

$50 AUD 1 päivässä
(90 arvostelua)
6.3
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ä
(72 arvostelua)
5.8
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ä
(32 arvostelua)
5.2
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ä
(19 arvostelua)
4.9
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ä
(64 arvostelua)
5.2
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ä
(46 arvostelua)
4.7
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
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
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)
1.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
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
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
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
matthewsharp123

This is a simple version of my day job. I work with Excel and VBA on a daily basis Please let me know if you want me to do this for you. Regards, Matt

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