How can I create a master item list from orders?
 

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.
--
Suzuki Steve

How can I create a master item list from orders?
 

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
"Suzuki Steve" wrote in message
...
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.
--
Suzuki Steve

How can I create a master item list from orders?
 

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.
--
Suzuki Steve


"Otto Moehrbach" wrote:

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
"Suzuki Steve" wrote in message
...
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.
--
Suzuki Steve

How can I create a master item list from orders?
 

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.
--
Suzuki Steve


"Suzuki Steve" wrote:

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.
--
Suzuki Steve


"Otto Moehrbach" wrote:

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
"Suzuki Steve" wrote in message
...
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.
--
Suzuki Steve

How can I create a master item list from orders?
 

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
. Remove the "nop" from this address. HTH Otto
"Suzuki Steve" wrote in message
...
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.
--
Suzuki Steve


"Suzuki Steve" wrote:

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.
--
Suzuki Steve


"Otto Moehrbach" wrote:

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
"Suzuki Steve" wrote in message
...
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.
--
Suzuki Steve