I have a excel sheet which is located in my D:/complete folder called complete.xlsx
This excel sheet is very large and contains alot of data.I have tried to use macro only in excel but the type of function i am trying to automate is too much for excel to process, hence trying to take help of database. unfortunately i do not know anything about database.
I am trying to work with a small portion of the data contained in the sheet, but the sheet takes a long time to process. I would like to import the excel sheet into MS Access and delete columns that are do not match the below cell values, located in the 11th row. i.e. the titles are located in the 11th row of the sheet.so the columns having Name, Age and Address as the title, I want all the data in that column, There are many column names and need to find and keep the below three.
Name
Age
Address
What I would like as a complete function is to be able to run a macro as described below:
When inside excel sheet we run the VBA code ( Macro) where in it calls the MS Access software, which deals with the data and deletes all unnecessary information, after which the output is opened or viewed in the same excel sheet from where the VBA code ( Macro) was initially run, After which I can perform the next steps.
Is it possible to do this? Would appreciate any assistance.