3 worksheets same headings consolidating data

[13lack13lade]

Hi All,

Having trouble consolidating 3 worksheets into one worksheet, on these 3 worksheets they all have the same headings which go from A-R. I simply need to be able to run a formula or use some sort of method to incorporate all 3 lists into 1 master list. The only way i currently can do this is to create a vba script which simply copies say 500 rows from the first worksheet paste onto master spreadsheet then copy 500 rows in second worksheet and find next blank row and paste etc.

Is that the best way to do this or is there a better way?


Thanks!

[mongoose36]

I would look into an using an array to transfer the data. You can dimension a range and and array and populate the array by equating it to the range like the following...

Please Login or Register  to view this content.