En cours

Data conversion

Source: XLS file with data on multiple sheets. Data needs to be organized so I could run Pivot table.

Source: XLS file with data on multiple sheets. Data needs to be organized so I could run Pivot table on final - organized file.

Source files can be in xls/xlsx:
1)
RK_ana_1-3_1.xls

or 2)
RK_ana_1-3_2.xls

The whole xls (xlsx) file look like this:
RK_ana_1-3.xlsx

In RK_ana_1-3_2.xls is demonstrated what needs to be done across whole xls/xlsx file. In additional file RK_Opomba.xls you can find coding for column G.

Any questions?

Some bidders have additional questions. I am making things clearer a little bit with result file.

VBA should do the following:
rearranging data from all sheets in the workbook into new sheet, ready to make PIVOT analysis

Pozicija (=position) - on each sheet leading number is written in cell "1. dobavitelj s ceno Zaš?iteno ime Proizvajalec" -> position number = 1, "2. dobavitelj s ceno Zaš?iteno ime Proizvajalec" -> position number = 2, etc.

Please remember there can be 2 different INPUT files:
1)
RK_ana_1-3_1.xls

or 2)
RK_ana_1-3_2.xls

Compétences : Excel, Visual Basic

Voir plus : pivot table excel, excel pivot table, xls visual basic, excel file conversion, excel data table, xls excel data, excel data conversion, xls data, data conversion table excel, excel conversion table, conversion table excel, macro vbscript import data multiple sheets excel, visual conversion, xls data conversion, excel table pivot, conversion visual, excel vba exporting data multiple sheets, excel data visual, conversion visual basic, excel grab data multiple sheets, change data connection pivot table, data xls, vbscript pivot table data source, table pivot, vbscript change pivot table data source

Concernant l'employeur :
( 0 commentaires ) Slovenia

N° du projet : #2373773

Décerné à :

FLtowhid

Please see my PM.

30 $ USD en 5 jours
(4 Commentaires)
3.8

11 freelance ont fait une offre moyenne de 30 $ pour ce travail

Innovative116

Hi. I am interested for the project. Please check private message for more details. Thank you

30 $ USD en 1 jour
(76 Commentaires)
6.8
Teloquence

Consider it done. Check your PM for my bid details

30 $ USD en 1 jour
(71 Commentaires)
5.5
Ciofi

I can do this for you.

30 $ USD en 0 jours
(13 Commentaires)
4.9
microk

Expert Here.. Please check PM..

30 $ USD en 3 jours
(20 Commentaires)
4.3
NSExpert

Hi My names Neha from The AeroDynamic Team based in New Jersey,UK. We are experts in high end Internet marketing, social media optimisation and SEO,Data entry, Web scrapping. we would be pleased to help. There are a Plus

30 $ USD en 7 jours
(8 Commentaires)
3.6
duchuyctlk

Hi, I have Office skills and I am interested in your project. Please consider my bid and you'll get good result.

30 $ USD en 1 jour
(5 Commentaires)
2.5
llanos330

I am the person for the job. i work diligent

30 $ USD en 1 jour
(0 Commentaires)
0.0
iwansun

I am ready for your project provide me more informations and you will see it done Have a nice day

30 $ USD en 1 jour
(0 Commentaires)
0.0
PerryJenkins

Hi, I'm interested in the job. I do this all day at my day job, as a replenishment analyst. I look forward to hearing back!

30 $ USD en 1 jour
(0 Commentaires)
0.0
dalwadipower

Hello ,Sir I have good knolaged of Ms Excel And Visual Basic TO Data conversion Any sheet to sheet and Ms Excel to Access Data Base Convert and any Other... Thanks....

30 $ USD en 1 jour
(0 Commentaires)
0.0