• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 231
  • Last Modified:

Copying Data to Another sheet based on column Values

excel 2003 vba

Routine Needed

I have 2 sheets in this workbook
"List"
"ExactList"

I need to data from "List to "ExatList"

In List"  I have columns from A to BB  :  NO COLUMN HEADERS
In "List" the row numbers vary  from 0 to ?

In Column BA AND BB I may or may not have the following present:
In Columns BA   I have a phrase  "EXACTMATCH"
In Columns BB   I have a phrase  "EXACTNAME"

What I need:
I need to copy all rows that have data in column BA  AND/OR  BB  TO
"ExactList"

Thank
fordraiders

 



0
Fordraiders
Asked:
Fordraiders
  • 2
  • 2
2 Solutions
 
FordraidersAuthor Commented:
Thanks but looking  for vba code
0
 
Rob HensonFinance AnalystCommented:
You can do this with an Advanced Filter.

This can be done manually and recorded using the VBA recorder or there is similar on this question:

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_24615743.html

Thanks
Rob H
0
 
Rob HensonFinance AnalystCommented:
Just read - NO COLUMN HEADERS

You will need unique column headers for the Adv Filter to work.

I guess the quickest way round this would be to have a line in the VBA that inserts a row above the data and adds column headers even if its just Col1, Col2 etc.

Thanks
Rob H
0
 
FordraidersAuthor Commented:
Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now