I have organised a raffle. I have 20 sheets filled with over 100 rows of data on every sheet. Every row is a ticket and row A is the ticket number.
Is there a way I can have a new sheet purely to pull information from those 20 sheets? Where by all I need to do is tell it what sheet number and ticket number and it will pull the entire data from that row?
Is there a way I can have a new sheet purely to pull information from those 20 sheets? Where by all I need to do is tell it what sheet number and ticket number and it will pull the entire data from that row?