Connect several columns from data sheet to another sheet
I have searched all over for this and have seen several references to VLOOKUP and INDEX/MATCH.
From what I have been able to gather is those functions are using some type of extra reference to work.
I have a large data sheet with a lot of columns. I am trying to copy the data from a few specific columns into another sheet and then have columns on the new sheet that act on that data.
How do I have columns duplicated straight over to another sheet with no filtering or summarizing?
Again, I have seen the recommendation for VLOOKUP and IDEX/MATCH. If that is what I am looking for, I may need a little deeper explanation to manipulate the function.
Any help would be greatly appreciated.