Copy Data from Form to Running Master - ignoring formulas and/or references

[paula.mccall]

Hello,

I have an "order form" that has several drop down lists references and a few vlookup or index/match formulas.

I would like to be able to fill in the form, click a macro button, and have that data go to a master file - ignoring formulas and/or references.

Then, clear the form (already have macro to clear), refill with new information, which will then add to the master file, beginning at the next available row.

All of the headers will match, but they are not all aligned.

For Example: The first thing that needs to go to the master is the customer name (header - cell b4), customer name from drop down list reference (cell D4).
I would need the customer name from D4 (order form tab) to go to the first available row/cell, under the header customer name (cell B4 of the Master tab)
The second thing would be cell C6 (order form tab) to cell C5 (Master tab)..........


I appreciate your help, time and knowledge!

Kindest Regards,

Paula

[nigelog]

This will start you off

Please Login or Register  to view this content.

will the entries be transferred 'en bloc" or singularly, and if 'en bloc' will each entry require the header details next to each line in master sheet

[paula.mccall]

Hello nigelog,

I'm not exactly sure what you mean by 'en block' or singularly, but if I understand it correctly, it would be singularly - each line that is created in the form, would need to create a new line in the master form. when the form is cleared and new data is selected - that data would need to be added to the master sheet starting at the next available row.

For Example: currently, there is data in the master form, which should populate from the order form. i need to clear the order form and add new data (a new order). I need that new data to populate in the master, beginning in cell B7 (following the same pattern as the previous entry data).

I really appreciate your help and time with this.

Kind Regards,
Paula

[paula.mccall]

Hello again,

The more I was able to think about it, the more I felt I needed to clarify what I was asking for (especially with the singularly or en blok question).

I would need for the D4,C6,C8,C10,C12 (from the order form tab) to repeat to to the Master tab, based on how many entries were provided in the form.

I have attached a better (more complete) example. I appreciate any help provided.

Kindest Regards,
Paula