HELP needed! Form creation with help of Macro

Hi All (Genius)

I would be greatly thankful if anyone can help me to create form (example attached in file) for payment order with the help of macros or anyother useful method. The data is in input tab in file with 3diff currencies and on the basis of this I need three different form, input data highlighted in green. Also this data is variable on the basis of input tab rest of data is fixed in form (attached as example 3 required tabs PO USD, PO SEK & PO EUR)


requirement is to create same kind of form in 3 separate file or sheets (1st three tabs purchase order) from the variable data (highlighted green) from input tab, Po form layout example is *P Order - EUR*

Please let me know if you have question regarding my request, data is just a example.

Thanks in advance for help & support

Best Regards
Cameron

I do not understand the requirement. You seem to have solved the issue yourself.

Hi dflak,

thanks for reply, basically first two tab of file require a file created by macro or any other query, at the moment I left those as layout example and inputting a data manually!

requirement is to create same kind of form (purchase order) from the variable data (highlighted green) from input tab

I'm sorry, I am still not getting it.

Are you saying that you get the first two sheets as data from a query or that they are generated by an existing macro or do you want that to be the result?

Where does the data on the input sheet come from? Do you enter this data in manually? Do you want to generate three Orders of the format like the first three sheets? If so then you have already solved the problem.

Will the format of the PO's ever change or are the cells always exactly in the same locations?