to pull data from one sheet and paste specific on another.

I have a workbook that I can not upload but I am having trouble starting my code under the following pretenses. The data is pulled from the BPA (Sheet 2) tab and inserted into a patteren based on certian features into the BPA Data Loader sheet (Sheet 1)

Based on a duplicate supplier, site or buyer the header line can not be duplicated. If any of the three are diffrent we move to the next supplier. If all three are duplicate then the proper header cells are filled with the information. We then we move to the next row to enter the part number information moving to each row till the supplier, site or buyer changes again.

The output to the BPA Data Loader sheet (Sheet 1) should look like this:

tab HOERNER BOXES tab TUPELO101 tab tab Monogram Refrigeration LLC tab tab Rasche, Matthew Joseph tab tab tab \%O%
*SL(5) tab tab 7519 tab tab tab *SL(2) EACH tab 0.628 tab tab tab tab tab tab tab tab tab tab tab tab tab tab tab tab tab tab \Bl tab 8 \%O *DN
*SL(5) tab tab 75093 tab tab tab *SL(2) EACH tab 0.2466516 tab tab tab tab tab tab tab tab tab tab tab tab tab tab tab tab tab tab \Bl tab 8 \%O *DN
*SL(5) tab tab 175D5920P002 tab tab tab *SL(2) EACH tab 0.1681398 tab tab tab tab tab tab tab tab tab tab tab tab tab tab tab tab tab tab \Bl tab 8 \%O *DN
*SL(5) tab tab 203C2475P004 tab tab tab *SL(2) EACH tab 0.0364 tab tab tab tab tab tab tab tab tab tab tab tab tab tab tab tab tab tab \Bl tab 8 \%O *DN
*SL(5) tab tab 203C4510P001 tab tab tab *SL(2) EACH tab 0.0270145 tab tab tab tab tab tab tab tab tab tab tab tab tab tab tab tab tab tab \Bl tab 8 \%O *DN
*SL(5) tab tab 299C1108P001 tab tab tab *SL(2) EACH tab 0.00954 tab tab tab tab tab tab tab tab tab tab tab tab tab tab tab tab tab tab \Bl tab 8 \%O *DN
*SL(5) tab tab 644334P01 tab tab tab *SL(2) EACH tab 0.0287702 tab tab tab tab tab tab tab tab tab tab tab tab tab tab tab tab tab tab \Bl tab 8 \%O *DN
*SL(5) tab tab 644865P01 tab tab tab *SL(2) EACH tab 0.0326 tab tab tab tab tab tab tab tab tab tab tab tab tab tab tab tab tab tab \Bl tab 8 \%O *DN
\^S *SL(5) \%A *SL(5) \%K *SL(5) \{F4}

every code I try comes out wrong. This is a sample of what I am working on now. I would prefer a before save event but I have it set as command button for now.

Please Login or Register  to view this content.

Hi,

I imagine you either solved this or gave up a long time ago. I have no idea what you're trying to do, but even so, I think your code should look something like this:

Please Login or Register  to view this content.

The following changes might improve the code and produce less errors when trying to write the code:

Please Login or Register  to view this content.

Lewis

Yes I have solved this however I will be able to use this code for a new project I am working on. Thank you very much for your help. I am sorry I did not post the resolution when this issue was solved.