ads_3131
06-11-2012, 01:06 AM
Hello again people...
Im stuck :( , I have a workbook that contains two worksheets.
Sheet1 is pure data, & Sheet2 is where im wanting to lookup the data from Sheet1 but in an formatted / organised way.
What i am wanting to do is pull values from sheet1 in a tabled column called supplier, and place them in Sheet2.... but.... in this supplier column there is gaps between the data, unfilled etc
so with this lookup im wanting to place in Sheet2 the data neatly under each other so the result will be a column of suppliers (in sheet2) with no gaps between rows/values.
I doubt that an formula is able to do this? or if a macro is best ?
Any help would be great! thanks :)
Im stuck :( , I have a workbook that contains two worksheets.
Sheet1 is pure data, & Sheet2 is where im wanting to lookup the data from Sheet1 but in an formatted / organised way.
What i am wanting to do is pull values from sheet1 in a tabled column called supplier, and place them in Sheet2.... but.... in this supplier column there is gaps between the data, unfilled etc
so with this lookup im wanting to place in Sheet2 the data neatly under each other so the result will be a column of suppliers (in sheet2) with no gaps between rows/values.
I doubt that an formula is able to do this? or if a macro is best ?
Any help would be great! thanks :)