Käynnissä

Excel Macros to Create Multiple Spreadsheets

We'd like an excel macro that can be run with Excel 2003 or newer and will do the following:

The project should include all required source code, installation and usage instructions.

As a test, please include in your response the 6th file that would be generated given the input test file and assuming that the user had selected "All". We will delete bids without this sample output file as well as any bids that suggest that the provider did not read these notes carefully.

Assume the spreadsheet is currently open in Excel. The spreadsheet has a worksheet called “account_list”. A sample is attached. You can assume the account_list has 3 header lines, and is then sorted alphabetically by the value in Column A.

Provide a list of the unique values in Column A or “All”. Allow the user to select 1.

Skip the first 3 lines of the account_list worksheet.

For each grouping of rows with the selected value in Column A or for each value in Column A if “All” was selected, do the following:

Create a new spreadsheet with a single worksheet called “infrastructure”

Copy fields from the input worksheet to the output worksheet as described in the detailed instructions (attached).

Save the copy as an Excel 5.0 worksheet, with the name "<column A value>_infrastructure_<yyyy>-<mm>-<dd>.xls in the same directory as the original. <column A value> should have all spaces replaced with underscores. <yyyy> is the current 4 digit year. <mm> is the current 2 digit month. <dd> is the current 2 digit day.

For the same rows, create another new spreadsheet file with a single worksheet, called “property”

Copy fields from the input worksheet to the output worksheet as described in the detailed instructions (attached).

Save the copy as an Excel 5.0 worksheet, with the name "<column A value>_property_<yyyy>-<mm>-<dd>.xls in the same directory as the original. <column A value> should have all spaces replaced with underscores. <yyyy> is the current 4 digit year. <mm> is the current 2 digit month. <dd> is the current 2 digit day.

Taidot: Excel

Näytä lisää: macro create excel spreadsheets, create multiple macros excel, excel macros spreadsheet macro, macro create spreadsheet excel, xls header, we excel, property provider, create multiple spreadsheets macro, new excel, spreadsheets, skip , save excel, mm, macro excel, do excel, create spreadsheet, create instructions, create excel worksheet, copy excel, multiple excel, excel create input output, list sorted, excel digit, code create, usage spreadsheet

About the Employer:
( 4 reviews ) Boston, United States

Projektin tunnus: #417785

Myönnetty käyttäjälle:

pyazlm

You may check PMB.

30 $ USD 2 päivässä
(30 arvostelua)
4.4

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

svet63

VBA developer since 1997. Can do. Regards, Svet.

130 $ USD 4 päivässä
(50 arvostelua)
6.3
MAnkita

Hello,Please refer your [url removed, login to view] you.

200 $ USD 3 päivässä
(47 arvostelua)
5.7
rajtuhin1

Best Software engineer with best price. Lets discuss in pmb few details. Thanks and Regards : TUHIN

30 $ USD 1 päivässä
(3 arvostelua)
3.8
muhmuuh

Hello! Please check PM for details. Thanks

40 $ USD 1 päivässä
(8 arvostelua)
3.6
johnsinit

Dear Peregirne Energy Group! I am an experienced VB and VBA programmer and would be happy to work for you. Please, check PMB. Sincerely yours, John.

135 $ USD 3 päivässä
(11 arvostelua)
3.6
kamosion

Hello! I can start immediatelly.

130 $ USD 2 päivässä
(2 arvostelua)
2.7
KellogITSolution

Hello Please see your PMB for details. Thanks

30 $ USD 0 päivässä
(3 arvostelua)
2.6
Abikris

Hi, See PM for details. Kris

30 $ USD 1 päivässä
(5 arvostelua)
2.5
refractocd

This can certainly be done using Excel VBA. I am ready to start IMMEDIATELY. Please refer to PM.

50 $ USD 3 päivässä
(3 arvostelua)
2.5
julvic

Hi, please refer to pm. Regards

250 $ USD 5 päivässä
(4 arvostelua)
2.5
Velu2009

I am ready to do this project.I have excellent knowledge on Excel.

100 $ USD 3 päivässä
(0 arvostelua)
0.0
afsarhassan

Ready to work.

230 $ USD 5 päivässä
(0 arvostelua)
0.0
darthobra

I am a professional VBA (Excel, Access, Word) developer with many years of experience in the financial and tax industries. I have worked on and developed many applicaitons that perform the very functionality you have Lisää

125 $ USD 2 päivässä
(0 arvostelua)
0.0
investOmatics

I can write this macro for you. Please see private message board for the sample output file. Thanks for your consideration! -- Joe

175 $ USD 1 päivässä
(0 arvostelua)
0.0
dicadio

Please check your pmb, thanks

55 $ USD 1 päivässä
(0 arvostelua)
0.0
jbruce1982

I have been creating excel macros for about 5 years now for a major corporation. I have MANY examples that I can provide for you. Pick me if you want an honest person who strives to make sure you get exactly what you w Lisää

125 $ USD 2 päivässä
(0 arvostelua)
0.0
babushah007

Hi, Please refer PM

150 $ USD 1 päivässä
(0 arvostelua)
0.0
mackling

Please see PMB

135 $ USD 2 päivässä
(0 arvostelua)
0.0