I have a spreadsheet with a source tab that has columns of different types of data, each named with a title at the top. I wanted to filter out the columns involving 'fuel cards', of which there are 9 different types (all labelled with 'fuel cards' appearing in the title, but with some slight variation).
I am looking for some way for this data to copy across to a table with the 9 columns reproduced on a separate tab, with new data added in the table, below the old data.
The relevant data is in red in the example file. I was hoping to add a new batch of data columns to the source tab each day. This would be added in new columns to the right of the old ones, and mixed among it will be other types of data that I wanted the formula to ignore.
So the intention is to have the 'fuel cards' tab set up to collect any relevant new data from the inputs tab, and add it to the table, with new rows of data beneath the existing data.
I was hoping that it might be possible to have a formula in the final table that looks for the correct columns and copies the data across, but which could be changed slightly for each column of the table (to collect the specific column in question). Ideally it could look for the exact text of the column title, and use that to identify the data to copy across.
My original idea was to use the SMALL function or maybe HLOOKUP to identify the correct columns, but I do not know exactly how to execute it, in terms of getting the data to copy into the table beneath the old data.
Thank you very much in advance for any help.
Bookmarks