ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Updating from another spreadsheet (https://www.excelbanter.com/excel-programming/282912-updating-another-spreadsheet.html)

Merry

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