letawellman
New Member
- Joined
- Aug 12, 2011
- Messages
- 9
Hello everyone!
Excel 2007 question here. All worksheets are in the same workbook.
I have 5 wrkshts - DataEntry, MRI, CATScan, XRAY, and ProductInfo
ProductInfo is static, (and hidden from the user) and used by the other worksheets for validating product.
DataEntry is where the user enters their purchasing data.
MRI, CATScan and XRAY are three worksheets where the user can choose different scenarios for analyzing future purchases of those product types.
The fields for all worksheets are:
Manufacturer, Product#, ProductName, QtyPurchasedinUOM, UOM, $$Purchased, and ProductType
There are multiple vendors, multiple products, but only three ProductType - MRI, CATScan, and XRAY.
What I want to do is have the user enter their purchasing history info, (Manufacturer, Product#, ProductName, QtyPurchasedinUOM, UOM, $$Purchased) on the DataEntry wrksht, then have the data automatically transfer to the appropriate worksheet based on the ProductType.
The ProductType on the DataEntry wrksht is NOT entered by the user, it is generated by a VLOOKUP of the Product#and gets the correct ProductType from the ProductInfo worksheet.
The reason for breaking these up into three different worksheets has to do with the future purchasing analysis - it gets really hard to display everything if I crammed all three types on a single worksheet.
I know I could have the user sort/copy/paste from the data entry sheet to the others, but that just opens up more possibilities for user error, especially if they stuck the data in the wrong place on the other worksheets.
I have all my other coding in place for the other worksheets (VLOOKUPS, drop-down lists, etc), but I must have fried my brain cells, as I can't seem to even think of where to start doing this.
Please help!!! Thanks in advance!!
Leta
Excel 2007 question here. All worksheets are in the same workbook.
I have 5 wrkshts - DataEntry, MRI, CATScan, XRAY, and ProductInfo
ProductInfo is static, (and hidden from the user) and used by the other worksheets for validating product.
DataEntry is where the user enters their purchasing data.
MRI, CATScan and XRAY are three worksheets where the user can choose different scenarios for analyzing future purchases of those product types.
The fields for all worksheets are:
Manufacturer, Product#, ProductName, QtyPurchasedinUOM, UOM, $$Purchased, and ProductType
There are multiple vendors, multiple products, but only three ProductType - MRI, CATScan, and XRAY.
What I want to do is have the user enter their purchasing history info, (Manufacturer, Product#, ProductName, QtyPurchasedinUOM, UOM, $$Purchased) on the DataEntry wrksht, then have the data automatically transfer to the appropriate worksheet based on the ProductType.
The ProductType on the DataEntry wrksht is NOT entered by the user, it is generated by a VLOOKUP of the Product#and gets the correct ProductType from the ProductInfo worksheet.
The reason for breaking these up into three different worksheets has to do with the future purchasing analysis - it gets really hard to display everything if I crammed all three types on a single worksheet.
I know I could have the user sort/copy/paste from the data entry sheet to the others, but that just opens up more possibilities for user error, especially if they stuck the data in the wrong place on the other worksheets.
I have all my other coding in place for the other worksheets (VLOOKUPS, drop-down lists, etc), but I must have fried my brain cells, as I can't seem to even think of where to start doing this.
Please help!!! Thanks in advance!!
Leta
