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:
The whole xls (xlsx) file look like this:
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.
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:
Décerné à :
11 freelance ont fait une offre moyenne de 30 $ pour ce travail
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....