Excel File Creation Project - Must know excel commands!

An example excel file is included.

1) remove all commas, semicolons, colons via search and replace

2) create a table where I enter in the date (1-1-2013) and the next excel column will adjust according the date input. *There are only 8 cells. So little work.

EXAMPLE - Column A would be (1-1-2013) and naturally Column B would be (1-3-2013) then Column C would be (1-6-2013), etc.

So I enter in ONE DATE and all go according to the first date entered.

3) Those columns that are created after the date is entered fill the cell completely RED

This needs to be able to be applied to ANY excel files with the click of a button. There will be 100's of excel files I am doing this with. This is not for just ONE EXCEL FILE but having the ability to do it over and over again. (If I can copy and paste the code into the excel file...OK) I just need to be able to apply this in mass fairly quickly.

Kemahiran: Pemasukan Data, Pemprosesan Data, Excel, Microsoft, Word

Lihat lagi: project work example, table creation, Excel file, excel 2013, excel copy data excel file, data table excel, excel file columns, excel fill, creation excel, excel column copy, excel data creation, project 2013, project commands, copy data excel file, must click, excel button, replace file file, file processing project, creation data entry work, project work file excel, excel column column, excel column data column, creation paste, can creation project, create excel table

Tentang Majikan:
( 6 ulasan ) Tampa, United States

ID Projek: #4115124

Dianugerahkan kepada:


Hi.. Expert excel database developer here. Assure you accurate database according to your requirements. Have a look at PM. Regards

$30 USD dalam sehari
(19 Ulasan)

6 pekerja bebas membida secara purata $30 untuk pekerjaan ini


Sir, I can do the project. Refer PMB. Looking for further discussions in this matter. with thanks and regards

$30 USD dalam sehari
(59 Ulasan)

I will do a good job

$30 USD dalam 2 hari
(3 Ulasan)

I am a new freelancer who has an extensive history in Excel as well as just recently completed a credited Excel course

$30 USD dalam 5 hari
(0 Ulasan)

Dear Hiring Manager, Today I have found this job post in freelancer, and I'm very interested in your job post involving these skills. I have good experience in data entry, web research, Google documents and MS Office. Lagi

$30 USD dalam 2 hari
(0 Ulasan)

hi i would like to do your job very [url removed, login to view] me all documents i will do very well. thank you Avanth

$30 USD dalam 5 hari
(0 Ulasan)

**********Please check the sample macro attached. Thanks*********

$30 USD dalam sehari
(0 Ulasan)

Mr, I am interested in this project. I am a computer programming teacher, experienced in reports and graphics for long amount of data, using macros within Excel. I can deliver the project fast and complete. Regar Lagi

$30 USD dalam 3 hari
(0 Ulasan)