| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do i use the function to copy and paste a determined variable.
Example I want to move all the rows that have a #1 in the first column to a
new work sheet and #2 and so on. I can use this function =IF('Email Leads'!A2=1,1,"") and =IF('Email Leads'!A2=1,'Email Leads'!B2,"") but that looks for a certain cell. If I have over 25 cells to look from, what is the function to use? Thanks 1 Bound Tree 1 Bound Tree 2 ICOM 2 ICOM 2 ICOM 3 Skedco Inc 3 Skedco Inc |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| In Excel, how do you copy and paste just the subtotals into anoth. | Excel Discussion (Misc queries) | |||
| copy paste cell character limit | Excel Discussion (Misc queries) | |||
| Copy and Paste | Excel Discussion (Misc queries) | |||
| Need Help to Prevent Copy Function Use in a Read-Only Workbook | Excel Worksheet Functions | |||
| copy and paste | Excel Worksheet Functions | |||
Threaded Mode
