Copy columns from source data preserving blank cells

Hi,

I have a spreadsheet with a tab of source data laid out in columns (this tab is named 'inputs' on the attached example, and there is a header identifying each column. The desired data is in red).

I am interested in being able to add new columns of various types of data to the inputs tab, and having a formula in an output tab that extracts just the data from columns labelled 'cash book'. I was hoping the formula could copy the data from the 'cash book' columns across to a new tab (without the column title), and arrange the columns of data side by side. The relevant data (cash book columns) always span from row 5 to row 147.

These 'cash book' columns contain data of various types (dates, text, numbers, and blank cells), all of which I hoped to copy across as they are (including blanks). The same data format will always be in the same row number, so hopefully I can just pre-format each row to the right data type, so that the formula can just copy across the raw data and it will appear in the right format.

It will always be a day of the week in row 4 of the inputs tab for example, as well as in row 1 of the output (cash book) tab.

I am hoping to copy across just the data, not the header / column title. The tab name is the same as the column title of the columns that I hope to copy across (if that is at all useful in the formula). The word 'cash book' is also written in cell A1 of the output tab, in case this would be useful to reference in the formula.

The example attached shows the data exactly as it is laid out in the final project.

Thank you in advance for any replies.

nunez100 This is a double post. Double posting is a forum rules violation. Please return to your original post https://www.excelforum.com/excel-for...ml#post5040281

There is a solution 'Cash Book' only posted there.