Hi all,
I have a spreadsheet with data in a number of sheets in columns A-P. I'm looking to combine all of the data into 1 sheet (the data may change on a daily basis). The headings within each sheet are identical and so this should not cause an issue, but the number of rows in the inititial sheets may change; with my lack of skills this means a combined set of columns which have empty rows [I would be doing a simple =sheet1...], but empty rows are not any use to me!
I hope someone can point me in the right direction to fix this.
Bookmarks