YellowLabPro
04-22-2007, 08:10 PM
I have two projects that I need loops for( This is an area of mystery to me still....:dunno), at least I think this will be the approach. A lookup may come into play, I could use some advice on the approach.
I have four sheets that are involved in the equation.
Inventory1.xls (Current inventory)
Inventory2.xls (Online inventory)
InventoryNew.xls (records added to Current inventory)
Upload.xls (records that will be uploaded back to the Onlin inventory)
The reason for this is, Inventory1.xls and Inventory2.xls are big, 15,000 rows by 30 columns of data. InventoryNew.xls is only 5-50 records of data.
Scenario 1
I want to locate the records in Inventory1.xls that I just added from InventoryNew.xls, and copy the entire row of these new records from Inventory1.xls to a 4th sheet- Upload.xls. The reason for this is that once the records are imported into Inventory1.xls they get a great deal more detail added to the records and this needs to be copied to the Upload.xls worksheet. I think this would be easier than trying to do a Vlookup for the 28 additional columns of data.
For Each,
If x=y then
copy y to Upload.xls("B2")
Scenario 2
Compare Inventory1.xls to Inventory2.xls records totals, Column B is item record# and Column E is Qty. Whichever records are different, +/- then copy these records to Upload.xls.
I will do the leg work, but I need help in getting started....
Thanks for taking the time to read...
YLP
I have four sheets that are involved in the equation.
Inventory1.xls (Current inventory)
Inventory2.xls (Online inventory)
InventoryNew.xls (records added to Current inventory)
Upload.xls (records that will be uploaded back to the Onlin inventory)
The reason for this is, Inventory1.xls and Inventory2.xls are big, 15,000 rows by 30 columns of data. InventoryNew.xls is only 5-50 records of data.
Scenario 1
I want to locate the records in Inventory1.xls that I just added from InventoryNew.xls, and copy the entire row of these new records from Inventory1.xls to a 4th sheet- Upload.xls. The reason for this is that once the records are imported into Inventory1.xls they get a great deal more detail added to the records and this needs to be copied to the Upload.xls worksheet. I think this would be easier than trying to do a Vlookup for the 28 additional columns of data.
For Each,
If x=y then
copy y to Upload.xls("B2")
Scenario 2
Compare Inventory1.xls to Inventory2.xls records totals, Column B is item record# and Column E is Qty. Whichever records are different, +/- then copy these records to Upload.xls.
I will do the leg work, but I need help in getting started....
Thanks for taking the time to read...
YLP