B
busyman5_au
I am trying to do somthing simple (?) without unnecessary copies etc o
the data, (my methods so far seems too messy)
Basically What I want to do is scan through these various workbooks an
worksheets copying in all columns that match a specific value (eg wher
row 5 = "XYZ")
More info:
Using Excel 2002 and this needs to be rerunable on a daily basis t
replace the manual copy/paste method in use now.
I have source data in multiple workbooks (submitted by differen
individuals) and I want to scan through these extracting out only thos
columns that match a criteria.
Unfortunately the data is NOT organised ideally for filtering. It i
column oriented rather than row so each column holds data for
particular account (numbers, dates and text) with some fomatting an
calculations happening. If I tramspose the data (which I've bee
playing with) then I can use list filtering etc but then I loose th
formatting etc.
I thought there should be some way to do this elegantly.
Thanks
the data, (my methods so far seems too messy)
Basically What I want to do is scan through these various workbooks an
worksheets copying in all columns that match a specific value (eg wher
row 5 = "XYZ")
More info:
Using Excel 2002 and this needs to be rerunable on a daily basis t
replace the manual copy/paste method in use now.
I have source data in multiple workbooks (submitted by differen
individuals) and I want to scan through these extracting out only thos
columns that match a criteria.
Unfortunately the data is NOT organised ideally for filtering. It i
column oriented rather than row so each column holds data for
particular account (numbers, dates and text) with some fomatting an
calculations happening. If I tramspose the data (which I've bee
playing with) then I can use list filtering etc but then I loose th
formatting etc.
I thought there should be some way to do this elegantly.
Thanks