simora
09-30-2014, 02:25 AM
I am doing a search and I get the result like this.
With col.Find(ComboBox1, LookAt:=xlWhole)
rsCol = .Column
The search range is restricted to Column Headings.
Now I want to go down that column where my value was found and find every value >0 in that column and copy that and the corresponding value from the same row in Column A to columns CA & CB on the same page.
The Column A values go in Column CA, & the >0 value goes into Col CB
I'm stuck. Can't seem to organise my thoughts on this.
HELP.
With col.Find(ComboBox1, LookAt:=xlWhole)
rsCol = .Column
The search range is restricted to Column Headings.
Now I want to go down that column where my value was found and find every value >0 in that column and copy that and the corresponding value from the same row in Column A to columns CA & CB on the same page.
The Column A values go in Column CA, & the >0 value goes into Col CB
I'm stuck. Can't seem to organise my thoughts on this.
HELP.