I need simple program. I have excel file (template). one row with few columns with vars like %MAKE% %MODEL%, ect. I have another excel with data. One fist row is var name.
from file "template" and file "data" create file "output" with every new row is summary from "template" and "data".
Lets say to create one row in output file. I copy row from "template" and change at least 8 pieces of data that I take from "data". Than again copy row from "template" (there is only one row in "template" file) and paste in second row in "output" with data from second row in "data" file. cycle..
I want to make this program more universal. Define what have to be found in data and put in output file. today I have data with cars, tomorrow with books.. name of columns in data file can be different. today i use %model% as variable, tomorrow i want put %author%.
9 freelancers are bidding on average $96 for this job
HI, I have a ready made program that does similar things with CSV/TXT. I m willing to tweak it to give u the same GUI that u r looking for. Regards Hussien Sharaf
Dear friend, can you send me the XLS files? So I can make an output excel giving you what you need. There is no program software needed, Excel can manage that himself.