Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Getting Vlookup to work via macro in multiple spreadsheets
Happy Friday...I'm tagging on to my earlier question, as I'm a little further along with this process. I'm running my Macro from a active spreadsheet (Macro1.xlsm) and I have manually copied my tax table into the second tab, named ("Tax Table"). I need to write the code to copy the tax table...- HoShe
- Post #6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Getting Vlookup to work via macro in multiple spreadsheets
Thanks, SkipVought. I was afraid it wasn't as easy as I was trying to make it. My next goal is to get IT to great a global report so that instead of running the report 190x, I can run it once and get all the data in one file. I appreciate your time and answer.- HoShe
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Getting Vlookup to work via macro in multiple spreadsheets
I'm very (VERY!) new to writing Macros, so I think I'm biting off more than I can chew... We have about 190 locations that we pull files from. I'm trying to pull these files and do a Vlookup to a tax table available on our Intranet. The problem I'm having is that when I "write" the macro...- HoShe
- Thread
- Replies: 6
- Forum: VBA Visual Basic for Applications (Microsoft)
