I thought I would just try to keep in EXCEL to do this set of work I have rather than use Access. I was hoping to record a macro consisting of filtering the data. I can do that and such. But the thought came up - If I run a macro in EXCEL then the speadsheet will stay the way it was after I ran the macro. This is something I do not want. I am only wanting to use the macro of filter actions to retrieve data that I want to focus on and prehapes edit it. When I bring up the sheet again I want the edits but will not want the way the filter macro last left the sheet. So I am thinking if I use Access and link to the Excel sheet I can use queries to do what I want. I can edit any data I want but the original order of the data will stay the same. If I want the order different and remain so, I could save as a different speadsheet or table.
Am I correct?
Uriah
Am I correct?
Uriah