Simple Copy from Worksheet to Worksheet

  • Thread starter Thread starter emailreynolds
  • Start date Start date
E

emailreynolds

Hi

I have 2 Spreadsheets, one is a for monthly quotes and the other is for
monthly business obtained.

The quote sheet could have 100 entries but the business sheet would
only contain say 20 of those 100 entries.

I need to copy certain columns from the quote sheet onto the business
sheet. I would only copy them if the quote sheet contained a Yes in
one of its columns.

I have tried an IF Statement but this still produces 100 entries on the
business sheet (80 blank and 20 containing information)

As you can tell I dont know any code so I would great appreciate some
simple examples of code to try.

Many thanks

Mark
 
I would greatly appreciate some code where I can simply add the
path/file names and the relevant columns names for each file.


Many thanks


Mark
 
It's difficult for me to create a code since I'm not really clear wha
you want to gain. What is your criteria in the IF statement? Is it lik
copy all the rows if column C = YES? Do you need to compare any valu
between this two sheets like if column C = "Yes" and column A in sheet
= column B in sheet2?

Best regards
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Move or Copy Stopped Working? 0
combining data from multiple worksheets into one 6
dynamic data copying between worksheets 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
I have not got a clue 1
Copying info from worksheet to worksheet if info matches 2
Worksheet + 1 1
Copy from worksheet to worksheet 3

Back
Top