Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 05-31-2016, 04:45 AM
fre_ fre_ is offline lookup or filter data, update it and save it Windows 7 64bit lookup or filter data, update it and save it Office 2010 32bit
Novice
lookup or filter data, update it and save it
 
Join Date: May 2016
Posts: 2
fre_ is on a distinguished road
Default lookup or filter data, update it and save it

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)
Reply With Quote
 

Tags
filter, lookup, update



Similar Threads
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
lookup or filter data, update it and save it lookup dates and return corresponding data newton.rogers Excel 7 08-15-2011 11:50 AM
lookup or filter data, update it and save it Lookup a value from non-sorted data udea Excel 12 04-25-2011 04:34 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:46 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft