In Progress

Excel sheet application

I need to automate an application that I always spent time in formatting, copying and pasting the data from several files to excel sheet (with several tabs).

The existing stages are as follows:

1. I have 17 files that come as unknown format that can be open as text or excel file.

2. I open them with text file and rename them with Branch name they refer to.

3. Then re-open them with excel sheet and format them and sort them and exclude few dates from them.

4. Then copy every individual sheet to a ready template with formulas in a way that every sheet is pasted in its own tab (17 tabs everyone had the name of the Branch) and to another tab (called Total Debtors) that include all the data from the 17 tabs.

5. The rest of tabs have already existing formulas that will take the information from Total Debtors tab and use them as tables.

What I need is:

Automate the steps from 1 to 4

Skills: Data Entry, Data Processing, Excel, SQL

See more: excel to application, excel 16, application template excel, excel sheet application, time sheet, sort excel, sheet, pasting information, format excel, EXCEL SHEET , excel sheet an, Excel Formulas, Excel Formatting, excel automate, copy excel, excel sheet formatting, excel can open file, excel copy data excel file, Excel Time sheet, open application, excel copy format file, rest application, file name excel, excel data tables, excel copy sheet format

About the Employer:
( 20 reviews ) Glasgow, United Kingdom

Project ID: #1116673

Awarded to:

PG89

Hi, Check PMB

$30 USD in 0 days
(2 Reviews)
1.6

20 freelancers are bidding on average $55 for this job

srinichal

I can deliver the app asap

$30 USD in 3 days
(14 Reviews)
4.8
mantripti

Hi, I have a team support of a Mechanical Engineer, M Tech & MBA, Cost Management Accountant. I also have a team support of number of professionals, including IT engineers, Computer professionals. We also have a manpow More

$30 USD in 2 days
(23 Reviews)
4.2
vgrichards

Very Good at Excel 2003-2010 and Excel VBA Macros. Please allow me to do it. Will ensure everything is as per your requirement.

$30 USD in 1 day
(17 Reviews)
3.5
Ratsclip

Let me help! Please see my PM

$30 USD in 2 days
(2 Reviews)
3.0
Baxter2008

Hello Mullionel I am an expert Excel VBA scripter, and have completed numerous VBA projects on different freelancer sites. My proposal is to create an Excel 2010 solution for you that will (1) import text files More

$30 USD in 3 days
(11 Reviews)
2.9
sathish2connect

Hi, I can do this. Ready to start now.

$30 USD in 2 days
(7 Reviews)
2.5
kanadyanako

For your consideration.

$30 USD in 0 days
(2 Reviews)
2.1
vnb400

kindly refer PMB, Thanks

$30 USD in 2 days
(2 Reviews)
1.6
krazykat1980

I actually have a program written that with a little editing will change your files into csv format and all you'd have to do is import them into the excel page that you want them on and I could have it to you in less t More

$50 USD in 1 day
(1 Review)
1.0
proflato

can we get started... am ever ready..

$30 USD in 2 days
(0 Reviews)
0.0
AdityaOnus

Hi, I am not able to get a clear picture of the requirement, what i want to know is how consistent are the input files and the basis on which some dates are being excluded. If possible please revert back with a sampl More

$200 USD in 10 days
(0 Reviews)
0.0
boffins

My bid is provisional. Please see PM for details.

$200 USD in 10 days
(0 Reviews)
0.0
rmjudkins

For the past decade my focus has been spreadsheet development within Excel utilizing VBA programming. Please refer to PM.

$100 USD in 2 days
(0 Reviews)
0.0
ravindernirban

we are mastermind in our work

$30 USD in 1 day
(0 Reviews)
0.0
ranjeetbtp25

hello sir, I am ready doing your work.

$30 USD in 1 day
(1 Review)
0.0
shbappy

I am interested to do this job. Please give me details.

$33 USD in 3 days
(0 Reviews)
0.0
amluu

Greeting! Ready to start

$50 USD in 2 days
(0 Reviews)
0.0
vmaresearch

check pm please. Thanks

$75 USD in 3 days
(0 Reviews)
0.0
ptseeker

hi, i am ready.

$30 USD in 1 day
(0 Reviews)
0.0