Hy All,
I would like to ask your support in the following topic.
I have a new frequent task, where I receive a big mass of data in an excel sheet, where the column names where given by me. Lets assume that the data is correct in the cells. Originally, the company has a data sheet to collect these data part/part, but now the quantity of the data is too big. The problem, is that I only can upload the data into the management system, from the old template, using some other programs.
Would it be possible, to create a macro that is doing the following steps:
1., create a copy of the empty template for each line=part
2., copy the data from the "mass data" file, into the newly created files (cells can be mapped, as the template is always the same, and also the mass data files collumn names are the same)
Sadly, I'm not really an expert of macros yet, and I'm afraid that until I learn it, my fingers will be already worn until my shoulder by copying data by hand :D
Thanks in advance for your support,
Lőrinc
I would like to ask your support in the following topic.
I have a new frequent task, where I receive a big mass of data in an excel sheet, where the column names where given by me. Lets assume that the data is correct in the cells. Originally, the company has a data sheet to collect these data part/part, but now the quantity of the data is too big. The problem, is that I only can upload the data into the management system, from the old template, using some other programs.
Would it be possible, to create a macro that is doing the following steps:
1., create a copy of the empty template for each line=part
2., copy the data from the "mass data" file, into the newly created files (cells can be mapped, as the template is always the same, and also the mass data files collumn names are the same)
Sadly, I'm not really an expert of macros yet, and I'm afraid that until I learn it, my fingers will be already worn until my shoulder by copying data by hand :D
Thanks in advance for your support,
Lőrinc