Merge Excel data to separate Excel forms

[Rominam]

Hi there Excel-people
For part of my job I have to take data from one Excel list and make it in to separate Excelforms.
It takes up so much time, which I don't have.
So I was thinking... Is there a way to merge the Exceldatafile in to separate Excelforms? (We use the later as a sort of 'back-up' for tracking received payments)

Thank you so much
Love
Rominam

 

[offthelip]

It is very possible that this could be automated, but you need to give us a lot more detail, e.g. what is in the excel list, how many columns and what they are, and then you need to tell what the criteria is for splitting the list into separate individual lists, and then you need to tell where you want the data to end up.

 

[Rominam]

It is very possible that this could be automated, but you need to give us a lot more detail, e.g. what is in the excel list, how many columns and what they are, and then you need to tell what the criteria is for splitting the list into separate individual lists, and then you need to tell where you want the data to end up.

Hi,
Thank you so much!
Well in the data-list we put every decision made per year.
So we have these headers (fine, stadium-ban, name, date of birth, number of file, date of the decision and the date when ban will be effective) (sorry my English is not super )
In the Form it would be the same data but in stead of per colon it is per line, if that makes sense?
I made an example sheet an print-screen but can't seem to add this.

 

[Rominam]

It is very possible that this could be automated, but you need to give us a lot more detail, e.g. what is in the excel list, how many columns and what they are, and then you need to tell what the criteria is for splitting the list into separate individual lists, and then you need to tell where you want the data to end up.

Hi Offthelip,

Is the info I gave enough or do you need more?