Paste data from one WB to other template WB when column headings are different with VBA

[knowlseeker96]

Experts.

Attached two WB's. one - Data sheet. Other - Template!

I want to shift all the infomation to be transferred from data sheet to the template.


challenge is the column headings are different. Ex: "Name of employee" heading in data sheet will be like "Emp name" - like this.

Months differ - 30/31 days, based on that - it should get work. Data can go upto 6k-10k rows or less than that.


There are few more templates, where same kind of shifts of data to be done as this is a month on month process that i am doing for 2 years plus. so there will be a data sheet and the templates may differ . So, i request someone to help by using command buttons with macros and linking columns between sheets as there are 10+ templates for one data sheet, so that, it will be useful.

After once transferred the data, conversion of PDF and printing automation from a folder macro is needed as there are 10 templates at a time.

Attached the WB and data for my request. your help is requested and highly appreciated.

Thank you.

 

[vletm]

knowlseeker96
Why shift?
If there are 'one column difference' between those files. (after AP)
Why not use 'data'?
... modify 'headers&footers as .xls-file and so ..
Use eg filter to show needed month...
and printout as PDF
What are other nine 'templates'?

 

[knowlseeker96]

Vletm,

Thank you for the quick reply. i mentioned shifts in the sense as transfer of data from one place to another. i should have mentioned as 'transfer'. sorry for that.

The data file will have all the information that each template should have. The issue is the names of column headings will be different. I couldn't understand 4th-6th lines of how to do that.

I will upload all the remaining templates by tomorrow and the raw data which needs to be transfer to this templates as well as the resulting output file for all templates.

Thank you

 

[vletm]

Why 'transfer' if one time save as PDF?
If Your data is as Your sample, there were one difference ...
'no matter of headers', if order is same!
... otherwise, only You'll know which match with others.
? modify 'headers&footers .. ?
... all matters of real data and those 'templates'
= if possible to 'move' template headers to data and
after that 'do needed' then no need to 'transfer' data to template.

 

[knowlseeker96]

Thank you for the reply.

i just want to share an example with constraints of my requirement.

Example, there are 20+ templates. Based on state For branch "A", i need only 7 templates to get generated . For branch "B" - i need 8 templates to get generated.

each branch will share the pay data that has columns of data of their emps monthly once. we need to copy the data of each paysheet in the respected columns of each templates.

There will be column A with heading name as "Serial no." in data sheet with data of 2000 rows. In template there will be column B which has heading as "Sl.No." Macro needed to map these columns so that automatically,data should get copied.

"Filter wise sheet" needed for branch wise so that we can map for each branch, which templates are mandatory. so final "generate templates/registers" will generate all registers at once after pushing the data from data sheet to individual templates.

Challenges are:

Order of the headings in the data file could not be modified as it is in practice for more than 2+ years at more than 150+ different branches. same paysheet data commonly.

Templates order won't change and can't be modified as it is the tax forms of government which need to be submitted.

Therefore, we don't have an option of modifying header's and footers in both the files. i will share the real time sample files tomorrow .

Thank you.

 

[knowlseeker96]

i will share the actual data and real templates by tomorrow.

 

[vletm]

Sample data ... not actual data!
Actual data has many times information, which not belong to everybody!