Hi,
I have 2 spreadsheets. 1 contains data that is updated every month. the other is a spreadsheet that I update every month with the data from the first spreadsheet. What is the best way to match the heading of the column and the date of the row to insert the new data every month? Im thinking I could go down the first column that contains the date, then go across the headings and if they match to the destination, then paste them into the destination sheet.
thanks
I have 2 spreadsheets. 1 contains data that is updated every month. the other is a spreadsheet that I update every month with the data from the first spreadsheet. What is the best way to match the heading of the column and the date of the row to insert the new data every month? Im thinking I could go down the first column that contains the date, then go across the headings and if they match to the destination, then paste them into the destination sheet.
thanks
