Fast Reformat of an Excel File (Macro or other)

I have a need for someone to create a basic file process that takes an excel file, adds two worksheets and re-formats the data. The process will involve;

a) Opening the file.

b) Entering a date into a field.

c) Pushing a button that creates two extra worksheets sheets

d) The first extra worksheet will have the data formatted so that two fields are concatenated into a new column. A new column will also need to be added with a unique id for each record.

e) The second sheet will need to include the records form the first sheet with the new unique ID. It will also need to have some additional columns added with some default data in these two columns. Some of the data will also need to be transposed and duplicated. This second sheet is more involved than the first sheet.

f) Once the file has been completed it will need to have a new file name and date.

A sample file can be supplied of the fields when required.

Skills: Excel, Visual Basic, Data Processing, Data Entry, Microsoft

See more: macro convert dat file excel file, solidworks macro excel file, macro copy paste excel file, excel macro for formatting data, excel macros, best excel format for large data, excel file format, excel macros examples, how to create a macro in excel 2016, how to use macros in excel, macros in excel for beginners, excel 2003 macro appent text file, excel file macro asp excelapplication, copy data paste anther excel file macro, macro copying conten excel file, macro copy excel file, export text file excel directory macro, macro import multiple text files excel file automatically, macro post data excel file, excel file macro

About the Employer:
( 0 reviews ) Melbourne, Australia

Project ID: #25638591

Awarded to:


Dear client, I have sound knowledge in Excel and I have previously carried out a number of projects in excel using macros and formulas. I ensure you will be happy after hiring me. Kindly contact me. Roy

$100 AUD in 1 day
(413 Reviews)

16 freelancers are bidding on average $96 for this job


Hello, I can help you with Reformat of an Excel File I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like More

$180 AUD in 3 days
(383 Reviews)

I can write macro for these tasks. Malik

$250 AUD in 1 day
(94 Reviews)

Hi, As I understand you need a macro to be created which can follow the steps highlighted by you. It would help to discuss on the file layout and the fields required. I am well versed with writing macros in Excel, Wo More

$50 AUD in 4 days
(116 Reviews)

NOTE : I HAVE EXPERTISE IN EXCEL MACRO AND VBA. I CAN DELIVER THIS IN QUICK TIME. With respect to this project I would like to present myself as a candidate for your consideration. I have more than 12 years of IT expe More

$120 AUD in 3 days
(50 Reviews)

Hi. I am ready to write your project. I have written many automation Excel VBA macros. Will complete within 1 day

$60 AUD in 1 day
(40 Reviews)

Hi, Good Day! I can help you building Automated tool using excel and vba macro. Please message me to discuss more about the project and I can also send you some of my works to help you decide on hiring me. I am a Proj More

$50 AUD in 2 days
(44 Reviews)

GOT your requirement of basic vba functionality. Yes i need sample data. please upload. WHen it should be delivered. Shall we chat for more Ram.

$50 AUD in 1 day
(10 Reviews)

Hi there, As a highly interested in your job posting, I'm really Data Entry specialist. I hastened to submit the enclosed resume. As a dedicated professional with solid experience in accurate and timely data entry, I a More

$110 AUD in 7 days
(0 Reviews)

I’m good in typing, I’m sure, I’m the right candidate to do this job. I will complete the job within the period given.

$30 AUD in 5 days
(0 Reviews)

Hello I have an expertise in excel as well as coding in macros and VBA. I have read your project details and I believe I can do the work. I hope you can consider me for your project. I can also work closely with you s More

$30 AUD in 1 day
(0 Reviews)

Dear Sir I am interested to perform your job. As I am a researcher, I have 5 years experience to deal with data in excel. I also have expertise to process and analyse data in R as I worked in a Glasgow University based More

$35 AUD in 1 day
(0 Reviews)
$156 AUD in 3 days
(0 Reviews)

I’m a creative, reliable and detailed DATA ENTRY who can work independently without too much detailed instructions. My professional and reliable attitude has earn me a lot of successful long term relationships with man More

$140 AUD in 7 days
(0 Reviews)

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. I am a serious bidder here and I have already worked on a similar project before and can deliver as u have mentioned "I can do th More

$140 AUD in 7 days
(0 Reviews)

Dear sir, At first take my sincere respect.I have gone through your project [login to view URL] that i am able to understand that i have the enough skills to do the [login to view URL] is some information about why i am best c More

$30 AUD in 1 day
(0 Reviews)