How can I create a master item list from orders?

[Guest]

I am trying to get information from one worksheet to another without
duplicating entries. ex: sheet 1 a1:a100 are my item numbers from an order I
just entered, I want to pull those to sheet 4 and be able to keep them there
on sheet 4 when I use sheet 1 to do a new order. After I enter a new order I
want only new items to be added to the list on my master list. ANY HELP??
PLEASE have been stuck for a few days now.

 

[Otto Moehrbach]

Steve
If I understand you correctly, you will need VBA (programming) for this,
unless you want to go through a rather tedious manual process of copying
everything, and then locating and deleting the duplicates.
Specifically, the code (macro) would loop through all the items in sheet 1
and, for each item, check sheet 4 to see if the item is already there. If
Yes, do nothing. If No, copy what you want copied.
Does this sound like what you want? If so, post back and provide some
details regarding the layout of sheet 1 and sheet 4 (also the sheet name).
Things like:
This columns contains this.
That column contains that.
You want this and this and this copied to sheet 4 and placed here and here
and here in sheet 4.
HTH Otto

 

[Guest]

Sheet 1 column L contain the item number N contain country of origin O
contains weight P contains length Q contains width R height S cubic meters.

I would like on Sheet 4 A=L B=N C=O D=P E=Q F=R G=S

Thanks for your help.

 

[Guest]

PS I am a complete retard when it comes to vba haven't had to write any code
befroe any help with this would be greatly appreciated.

 

[Otto Moehrbach]

Steve
Since you haven't delved into code writing before, it would be easier for
you if I just send you the small file I used for this. Send me your email
address and I'll send you the file. Be sure to mention "Suzuki Steve" in
your email since that is the name of the file. My email address is
(e-mail address removed). Remove the "nop" from this address. HTH Otto