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 |
Hi!
Why not just copy/paste to the other sheet then sort by the column that contains the #1, #2 etc? Biff -----Original Message----- 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 . |
There are over 1,000 rows, lot of coping and pasting I was trying to avoid,
then I have to send each sheet to that advertiser there are over 223 advertisers with respondents to ads. So, I'll just auto filter and send via that way, one at a time. If I had email in access I would'nt have to export the file out, I could just email from access, which is where the data original resides. Thanks anyway Biff "Biff" wrote: Hi! Why not just copy/paste to the other sheet then sort by the column that contains the #1, #2 etc? Biff -----Original Message----- 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 . |
All times are GMT +1. The time now is 06:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com