Updating from another spreadsheet
Users have a spreadsheet that is generated from a web app weekly.
I need to allow them to open the sheet each week (different data) and then I need to open a separate workbook and update the first sheet with data from this workbook. Having worked in vba in access I figure I should be able to do this but excel is another animal. This is a short term fix until the web app is modified to include this data (not due till June 2004), so I don't want to get fancy. Just open this every week; open the other one and update in a new column based on values in column A and column B being a key. Can someone get me started?? |
All times are GMT +1. The time now is 01:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com