![]() |
#1
|
|||
|
|||
![]()
Hi Community,
I'm busy with the following little project: Given is an input table in Excel. (input.xlsx) It contains following fields: ID, name, address, postal code, date_of_start (headings are in first row A1, A2, A3, A4, A5) This table has 300.000 records. (data start at row 2) I would like to create a new Excel File (lookup.xlsm) where I can filter the data in the original Excel-file. (filter based on name and address) In the filtered results, it has to be possible to change/update the value of "date_of_start" and that should be saved in the original table. (input.xlsx) => is such thing possible with Excel/VBA? I discovered the Excel Advanced Filter function, but my need is a little bit more complex than that I guess: - I need to have 2 files: one with the data (backend) and one with the search & update function (frontend). - the changes made in the frontend has to be saved in the backend. - The use of MS Access is not possible. Any advice how to manage this would be appreciated. (with Excel Advanced Filter, I nearly had what I wanted, but the problem is that when you use "copy to another location", you can't make changes in the filtered results, and that's what I need) |
Tags |
filter, lookup, update |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Cross-reference / lookup data from one tab and display on another - How to | lonniepoet | Excel | 0 | 02-24-2016 01:31 PM |
Lookup problem for data input | zulugandalf | Excel | 2 | 09-22-2015 03:21 AM |
Vba to Filter data | saurabhlotankar | Excel Programming | 5 | 05-29-2015 06:07 AM |
![]() |
newton.rogers | Excel | 7 | 08-15-2011 11:50 AM |
![]() |
udea | Excel | 12 | 04-25-2011 04:34 AM |