Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Simple Copy from Worksheet to Worksheet
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to copy subtotalled cells to a new worksheet (in a macro), wi. | Excel Discussion (Misc queries) | |||
how do i copy the format of a cell from one worksheet to another | Excel Discussion (Misc queries) | |||
How do I copy only the month from a date | Excel Worksheet Functions | |||
PLEASE HELP......COPY DATA FROM ONE WORKSHEET TO ANOTHER | Excel Worksheet Functions | |||
How can I copy an .xls worksheet to another worksheet | Excel Worksheet Functions |