selecting or copying columns conditionally

  • Thread starter Thread starter busyman5_au
  • Start date Start date
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
 
For the bottom part of your post--try using paste special and selecting transpose. You may have to do it onto a new sheet, but it should solve the filtering problem. It worked for me on Excel 2002 and 2003. It transferred the formatting just fine
The first part of your post will probably require VBA code. More advanced programmers than myself will have to help you there

t

----- busyman5_au > wrote: ----

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
 
Thanks TJ, but I need to rerun this when the base data changes, so
manual cut/paste won't be enough... and the transpose fundtion losse
the formatting.

keep the ideas coming P L E A S E I'm stuck
 
Back
Top