So I am exporting tables from our internet database into Excel. I am able to record a macro that filters out the info I need and replaces the title with our company header. However, I need this macro to work with all exported data. Right now, when I go to edit the macro, it appears it points to Sheet("AC164127-7") (the name of the table I used), but I need that to be a general sheet that is created whenever I export a table with a different name. How can I fix the code so it is universal?
Thank you!![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks