Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy Specific Cells To A New Sheet On Condition
Summary of Challenge: I have a workbook with two sheets, LeadTracking and
Commissions. I need to copy specific cells (not the entire row) LeadTracking to Commissions if the value in column X is CL. The values in cells C,D,E,J,X,L and AA need to be copied to Commissions in columns A,B,C,D, etc. The first two rows of LeadTracking are column labels, Commissions has one row of labels. I have a starting point which accomplishes part of what I want to do, but it copies the entire row, not specific cells within that row. (Note that I did not write this code but found it via a web search). Appreciate any suggestions. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sum cells that meet a specific condition | Excel Worksheet Functions | |||
Copy from one Sheet and paste on another sheet based on condition | Excel Discussion (Misc queries) | |||
copy data to another sheet on condition | Excel Worksheet Functions | |||
Copy certain cells from one sheet to another with a condition | Excel Worksheet Functions | |||
how 2 Count number of cells that have specific condition format? | Excel Worksheet Functions |