ads_3131
06-21-2012, 01:22 AM
Morning ! :)
Possibly a simple one, or not....
Have a workbook, contains two sheets. Sheet1 is Data (will be variable as it is an import) Sheet2 needs to breakup the raw data from Sheet1
In Sheet2 i am wanting to put the Supplier problems (including all fields on that Row or range) into one table. And then our problems into the other table...
These 2 categories (ours & suppliers) are in different columns.... maybe that will make the task simplier?
---------------
Maybe the below is the right path? or most likely not?
----------------------------
i used the formula below before (works on the same sheet by adding a name to the range) but this doesnt work on an different sheet.
=IF(ROW()-ROW( SupNoBlanks)+1>ROWS( SupBlanksRange)-COUNTBLANK( SupBlanksRange),"",INDIRECT( ADDRESS(SMALL((IF(SupBlanksRange<>"",ROW( SupBlanksRange),ROW()+ROWS( SupBlanksRange))),ROW()-ROW( SupNoBlanks)+1),COLUMN( SupBlanksRange),4)))
Also to make it more complex.... it only pulls in data from one column while i want rows with it. :(
Picking my brains at it and hopefully a VBA wizzard will put me on the right path :)
Attached is an example sheet... with raw data on sheet1. and sheet2 containing 2 tables which the end result should be a seperation by our problems or the supplier problems
:) thankyou in advance
Possibly a simple one, or not....
Have a workbook, contains two sheets. Sheet1 is Data (will be variable as it is an import) Sheet2 needs to breakup the raw data from Sheet1
In Sheet2 i am wanting to put the Supplier problems (including all fields on that Row or range) into one table. And then our problems into the other table...
These 2 categories (ours & suppliers) are in different columns.... maybe that will make the task simplier?
---------------
Maybe the below is the right path? or most likely not?
----------------------------
i used the formula below before (works on the same sheet by adding a name to the range) but this doesnt work on an different sheet.
=IF(ROW()-ROW( SupNoBlanks)+1>ROWS( SupBlanksRange)-COUNTBLANK( SupBlanksRange),"",INDIRECT( ADDRESS(SMALL((IF(SupBlanksRange<>"",ROW( SupBlanksRange),ROW()+ROWS( SupBlanksRange))),ROW()-ROW( SupNoBlanks)+1),COLUMN( SupBlanksRange),4)))
Also to make it more complex.... it only pulls in data from one column while i want rows with it. :(
Picking my brains at it and hopefully a VBA wizzard will put me on the right path :)
Attached is an example sheet... with raw data on sheet1. and sheet2 containing 2 tables which the end result should be a seperation by our problems or the supplier problems
:) thankyou in advance