Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can anyone help?
Okay, let me give you some background info on this project I'm working on.
I have 2 spreadsheets that I am working with. Spreadsheet A is a 12 month report, a colum for each month. The left side column holds part numbers that are sorted by the different areas that mfg them and there are subtotals when each mfg area changes. Spreadsheet B is a CSV file that I get from our server each month that has the part numbers, several columns of data I don't use and then the qty column. This csv spreadsheet is sorted by part number, so it is not in the same order as spreadsheet A. What I need to do is to have spreadsheet A go out, look at spreadsheet B, find the part number, then copy the qty for that part from spreadsheet B, back to spreadsheet A and then go to the next part number and to complete this process through all of spreadsheet A. I have spent the last week working on various macros trying to accomplish this, and I'm no closer then when I started. Does anyone have any suggestions?? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can anyone help?
On Thu, 8 Mar 2007 13:01:40 -0800, Bryan Maple, Illinois
wrote: Okay, let me give you some background info on this project I'm working on. I have 2 spreadsheets that I am working with. Spreadsheet A is a 12 month report, a colum for each month. The left side column holds part numbers that are sorted by the different areas that mfg them and there are subtotals when each mfg area changes. Spreadsheet B is a CSV file that I get from our server each month that has the part numbers, several columns of data I don't use and then the qty column. This csv spreadsheet is sorted by part number, so it is not in the same order as spreadsheet A. What I need to do is to have spreadsheet A go out, look at spreadsheet B, find the part number, then copy the qty for that part from spreadsheet B, back to spreadsheet A and then go to the next part number and to complete this process through all of spreadsheet A. I have spent the last week working on various macros trying to accomplish this, and I'm no closer then when I started. Does anyone have any suggestions?? Bryan: How about a non-macro solution. Create a new worksheet in spreadsheet A. On that worksheet, create an external data query (Data Import External Data Import Data). Change the file type to CSV, navigate to your file, then complete the import wizard. Now use a VLOOKUP formula to get the quantity off of the new sheet. New CSV on the server? Just go the new worksheet with the external data and click the Refresh button on the External Data toolbar. -- Dick Kusleika Microsoft MVP-Excel http://www.dailydoseofexcel.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|