Help with automatically transfering items to another sheet 
Author Message
 Help with automatically transfering items to another sheet

Our warehouse created a worksheet to track inventory.  

When items are received, they enter the data under columns labeled
manufacturer, model number, serial number, ect. on each row.  One of the
columns is labeled "sold".  When the item is sold we enter an "S" for that
item. Then we do a resort by the "sold" column so it puts all the sold
items together.  Then I move all of the sold items to a seperate sheet.  Is
there a way to automate this process.  I am not too familiar with macros.  

Any help or reference would be appreciated.

Thank you\\

Joe Scholz



Wed, 18 Jun 1902 08:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Transfering From Sheet-to-Sheet Without Hyperlinks

2. Request for help transfering data between sheets

3. Excell 2000: Master Sheet-I want other sheets to automatically update other sheets

4. Automatically update sheet 1 onto sheet 2

5. automatically logging info on sheet 1 from source cells in sheets 2-100

6. Help with counting items in sheet

7. transfering data from one work sheet to another

8. transfering data from one sheet to another

9. Transfering from one sheet

10. Need help with duplicate items between sheets


 
Powered by phpBB® Forum Software © phpBB Group