Login

u/CharmicChameleon

Dynamically pulling the header of each table to a master summary sheet
▲ 6 r/googlesheets

Dynamically pulling the header of each table to a master summary sheet

Hello,

Link to start

I am currently setting up a sheet to track purchases and sales in a bit more detail than previously done and wanted to pull the headers of each table (grey rows) into a master sheet. Currently i am doing this manually but was wondering if there was a more automated way to grab those specific rows. The main issue being that the tables can be different lengths and so I don't know a way to dynamically pull from it.

I'm not tied to the formatting or structure if it if there is a better solution in another direction.

Thanks in advance

u/CharmicChameleon — 1 day ago