Thread: VBA code to format table, insert 3 columns right, do a vlookup and split table in separate workbooks
View Single Post
 
Old 01-19-2023, 03:15 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
  
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,166
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default
Is this assignment only to be done with VBA or can you explore Excel's Power Query to do most of the work?

If you aren't already familiar with Power Query you can start with some youtube videos
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote