Insert Data From Multiple Worksheets Into One (With Criteria)

Ok, I have created a sales report list that tracks what customers we are 
contacting, how we are contacting them, if they are a new or existing 
customer and if we sent a quote, along with some other details. There is a 
worksheet the salesmen fills out for each day of the month (its linked to a 
calendar) and that all goes into a "dashboard" that shows the breakdown with 
graphs. Now what i would like to do is have another worksheet list all the 
customers that we sent quotes to so they can mark if the quote was won or 
lost , state sales projections and give reasons why won or lost. How can i do 
this?

Ive tried vlookup and macros and advanced filtering, copy to another 
worksheet, and keep hitting snags along the way. I'm pretty good at excel but 
i'm no guru. The customer is in column A and the quote is a drop down yes/no 
list in column E. Basically, i need a formula to say if E#=yes then copy A# 
to worksheet "monthly review" ... please let me know if this is possible! 

Thanks in advance!
0
Utf
2/9/2010 2:36:12 PM
excel.worksheet.functions 4936 articles. 2 followers. Follow

0 Replies
844 Views

Similar Articles

[PageSpeed] 27

Reply:

Similar Artilces:

Secondary Axis Data Series "Clumping"
I have a chart that has 3 data series. 2 are related to percentages and are tied to the primary axis. The third series is a whole number, and tied to the secondard axis. it has always displayed properly. For some reason the data tied to the secondary axis is "clumping". That is, all 17 data points are displaying before the second category tick. The first 2 series' data is displaying just fine. What have i done wrong? What are the chart types of the three series? - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Mike wrote: > ...

How can you add the same data series to all charts in a workbook
I have numerous charts on separate worksheets in one workbook and would like to add the same data series to all the charts. I have tried highlighting all the worksheets and adding the series to no avail. I'd save your workbook, just in case this doesn't work as I think it should. You can select the series in the chart that includes the series and copy the formula for the series. It looks something like =SERIES(...) Paste that in each chart you want to add it to. "MBubier" <MBubier@discussions.microsoft.com> wrote in message news:AF363BA3-47A2-4364-89D8-02A60...

Inserting (and extracting) pictures into word
1-I used ctrl-PrtScreen to copy a graphic on my screen. 2-Then I opened a word doc and hit Ctrl-V to insert the graphic into the document. Here is my Q: How can I retrieve the graphic from my word document and turn it into a JPG or other graphic file? Why I want to do this: I want to create a collage with the graphics. To do so, I need to extract the graphics from the word document and transform them into individual, discrete graphic files that I can manipulate. Can I do this? If so, how. I thank members of the community in advance for any help you can provide. David R...

How do I prevent tekstoverlap in inserted graphics?
I have no clue what tekstoverlap is. Do you mean text overlap? Are you asking about wrap? -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "SD" <SD@discussions.microsoft.com> wrote in message news:03CF912A-A906-469D-B5E6-563E5AEE6CC7@microsoft.com... > ...

problems printing multiple copies on one page, only prints 1
Hi there I am trying to print four copies on one piece of A4 paper, the system and printer resizes the document and prints it in the top left hand corner, but no other appear on the same page Verify your work area is � or less the size of your paper stock. When you go to print select File Print Page Options "Print multiple copies per sheet." -- Don Vancouver, USA "Gary" <Gary@discussions.microsoft.com> wrote in message news:7412DEB1-B05A-427C-9D42-6C71E85A23F0@microsoft.com... > Hi there I am trying to print four copies on one piece of A4 pap...

MVC2: linking from one area view to another area view
I am working on an MVC 2 app. I have 7 different areas in it which has a view that should be accessible from the home page (or anywhere else really). The links most likely will go in a sitemap and get put on the apps master page. Either way, How would I say link to Headlines/home/ from the apps master page? ...

filtration of worksheets tallying 2 million seperate phone numbers
Hi, I am a loan officer at a mortgage brokerage. We have recently put the new nationwide no-call list on an excel spreadsheet. I have 2 questions for you. First: is there a way to make excel have more rows than 65,536 (preferably like 2 million) as the colorado part of the national no-call list is about 2 million. And second;can you tell me how to filter one workshet against a second with 30 columns and 65,536 rows(the filter feature I use only takes into consideration the left-most column) ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com...

adding multiple contacts at one time from a received email
Is there a way to add multiple contacts from the header of an email sent to me as part of a distribution group? I know I can right-click on them one-at-a-time and do "Add to contacts..." but that's a nuisance for 50+ addresses. Is there a way to do this in bulk? for a reply. thanks. Liz I don't think so. -- Judy Gleeson MVP Outlook Outlook trainer and author of Productiv_IT with Outlook www.acorntraining.com.au <lizzoob@gmail.com> wrote in message news:1162228944.601011.176680@e3g2000cwe.googlegroups.com... > Is there a way to add multiple contacts from t...

Can multiple versions of Money coexist on a PC?
I'm running Money 2004 but have a copy of M 2005 someone gave me. WIth all I've read here I don't want to replace M 2004 with M 2005. I'd like to run them in parallel until I see if I prefer the newer version, based on all I've read here. Is it possible to install M 2005 on a machine with M 2004 and have them run separately? Yes you can. You should install 2005 in a different directory to 2004. Downloads direct from your bank will go to the newer version by default. When you run Money, you need to make sure you open the correct file with the correct version - ie do...

Multiple Google Calendars and Outlook
I run an app called Google Calendar Sync on my PC. It sync Outlook 2010's calendar with that of the Google one. I've since created a second calendar in Google to try and separate work events from social ones. However, Outlook 2010 and this sync program can't see the second or subsequent calendars. I was hoping that someone here has a way or has seen a way to get Outlook to sync with multiple Google calendars. Thanks Hello Marts, I can do it for you. Please reply if you want it. Regards Andrej > I run an app called Google Calendar Sync on my PC. It sync Outlook 2010&#...

date data type is not a date??
Following is code I am running. I intend to compare two dates. One date (orderrg.value) is from a spreadsheet and is defined as a type date. The other date is the system date. However when I check to see if the orderrg.value is a date via ISDATE, it fails. Following the code is the prinout from the immediate window. It looks to me like it should be able to recognize it as a date, but yet it doesn't. Does anyone have any ideas? Private Sub Workbook_Open() Dim wscommission As Worksheet Dim nindex As Integer Dim lastorder As Integer Dim sheetname As String Dim orde...

One exchange user, cant send email to another particlular user
I have a problem its is only a 1 way problem, user a cannot send mail to user b, user b can send mail to user a. both users are on the same exchange 5.5 server. This means that user b is not recognized as a valid recipient. Check the properties of user b in the Admin Program and make sure you have an e-mail address stamped there. -- Mike Manjunath Microsoft Corp. "Please do not send email directly to this alias. This alias is for newsgroup purposes only." "This posting is provided "AS IS" with no warranties, and confers no rights." "Nema J" <ne...

SUMIF/COUNTIF with missing data
Right now, I'm using the following function to get the average of column B, given that column A has a certain criteria: =SUMIF($A$1:$A$10,"=Blue",$B$1:$B$10)/COUNTIF($A$1:$A$10,"=Blue") Which works fine, except that for some of the entries whose A column says "blue" there is no data in the B column, so the denominator is off. How can I account for missing data in this function? Thanks in advance. Try =SUMIF($A$1:$A$10,"Blue",$B$1:$B$10)/SUMPRODUCT(($A$1:$A$10="Blue") *(B1:B10<>"")) OR try the below...

Consolidating Sheets into 1 new one.
I have a workbook with 52 worksheets, each following the same format. (The sheet lists salespeople by name in collumn A, and statistics for each person across the next columns B - F.) I want to bring all the data for each of the weekly sheets and consolidate it into the same format on a summary sheet. Here's the problem: I have to deal with employee turnover. The first weekly sheet might have in column A starting with A1 Steve, Tom, Mike, and Joe in A4. The second weekly sheet might have (starting in A1) Steve, Tom, Joe, Jim, and Mary in A5. Week 3 might just have Joe, Jim, and Mary....

Chart data labels are not correct or not displayed
I have some charts that I've been using for a long time and I notice that sometimes the data labels do show correctly or not at all. Can someone help? Bolton User Can you give us a few more details. What type of chart (line, XY, column) ??? How is your source data setup? What do you expect to see for labels, what are you actually getting? With a little more information, I'm sure we can help. koday@processtrends.com "Bolton User" <Bolton User@discussions.microsoft.com> wrote in message news:22562EFB-2802-4BEE-9C03-A9866D33DD6D@microsoft.com... >I have so...

X, Plus, and Star marker styles do not show all data points
In a scatter chart, the X, Plus, and Star styles simply mark the right end of each string of data; data points to the left of that position don't show, unless I use a background color different from the Chart's background. The square, diamond, triangle, and circle styles show all the data. Is there a property of these 3 problem styles I should set to make them display like the 4 that work? Thanks for any help. Larry Mehl Larry - I've never noticed a problem like that. You're saying the markers only mark the last point in a series? Are these charts you're doing your...

moving worksheets between workbooks
I have three workbooks that I'd like to consolidate into one workbook with 3 sheets. Workbook #1 contains linked cell references in workbooks #2 and #3. How can I move the worksheets from workbooks #2 and #3 into workbook #1 while maintaining the integrity of the linked cell references? Thanks, -Jim Hi Jim, I don't now how this will affect the links, but you can move worksheets this way -Open all the workbooks invovled -Right click on the tab of the sheet you want to move and choose move or copy from the popup menu -In the new dialog click on the dropdown to select the workbook...

When I select to insert a page break, it is not inserting.
I have a spreadsheet that is set up to print to fit on one page. However, when I try to insert a page break to split up that page, horizontally or vertically, it is NOT inserting. However, if I set up to print at 100% its size, it's 16 pages long, page breaks will appear, but I don't want to break up 16 pages. Help! Next time you're in file|page setup|page tab, set it to print 1 page wide by 1 page tall. Ok your way out of the dialog. Then go right back into that file|page setup|Page tab. Note the "adjust to" percentage. It's probably less than 100%. Sele...

Transforming a worksheet's functionality?
Hello Everybody. How is your Friday? Okay, is it possible, using a recordable Macro or VBA, to change a worksheet's functionality? For instance, I have a workbook with one Formatted Data Entry sheet and one No-Format Archive sheet that stores all the raw data (no formulas) for future retrieve. Is it possible to change the Data Entry sheet from user input mode to archive retrieval mode? In data entry mode, Column D and G are blank to allow for user input. In archive mode, Column D and G would need formulas which grabbed data from the corresponding cells on the archive sheet. ...

selecting chart data range using arrow keys
Hello, In the past I have been able to select the data range (ie source data) for a chart by (a) clicking on the little square button at the far right end of the source range, which brings me to the spreadsheet; and (b) then using arrow keys to move around and SHIFT select data. OK, I can still do this. But the rub is this: I used to be able to CTRL-arrow around to select ranges, which is very handy in big spreadsheets, since it can bring you to the next full cell (like using the Scout (#9) in Stratego). But now I can't CTRL-arrow around anymore to select chart data, leaving me...

How do put a group of addressee's into one batch to all receive e-
I have a committee and want to inform all of an upcoming meeting. How do I put all the committee members into an address where I click one time and have all of them receive the e-mail? make a Distribution List of them in your Contacts. jkundert wrote: > I have a committee and want to inform all of an upcoming meeting. How do I > put all the committee members into an address where I click one time and have > all of them receive the e-mail? "jkundert" <jkundert@discussions.microsoft.com> wrote in message news:67F9568C-65C2-4543-8892-4C0A3E35947D...

I can't recieve new mail from one contact
I can't recieve new mail from one specific contact. I can recieve replys from him but any new messages that he sends do not go through. We have redone the address in the address book but this dod not help. Any thoughts? "Paul" <Paul@discussions.microsoft.com> wrote in message news:940407C9-8272-42BA-8524-13C1773AA843@microsoft.com... > I can't recieve new mail from one specific contact. I can recieve replys > from him but any new messages that he sends do not go through. We have > redone the address in the address book but this dod not help. ...

Converting Worksheet to all 'Upper'
Hi All, I know how to change lower case columns to upper case with th =upper(cell) function. Then once the new 'upper' column is complete copy, then paste back as 'values' and then delete the old 'lower column. Gosh, I have over a dozen columns to convert in each worksheet. Isn' there a way to convert the whole worksheet to upper in one fell swoop? While I'm here, I'd like to thank all those regulars here for the hel they have contributed on a daily basis to all of us not s knowledgable. You have saved many thousands of hours of frustration, and I, for one...

Display Multiple images
SGksDQogICAgICBKdXN0IHdhbnQgdG8gY2hlY2sgd2hldGhlciBpcyBpdCBwb3NzaWJsZSB0byBk aXNwbGF5IG11bHRpcGxlIGltYWdlcyB1c2luZyBTREkgaW5zdGVhZCBvZg0KICAgICBNREk/DQog ICAgIElmIHllcywgYW55IGhpbnQgb24gaG93IHRvIGJlZ2luPw0KIA0KUmVncmRzDQpMZW8NCg== #LEO CHIN SIM# wrote: > > Hi, > Just want to check whether is it possible to display multiple images using SDI instead of > MDI? > If yes, any hint on how to begin? > > Regrds > Leo It is possible to display anything using SDI. You can paint multiple images on one view, or you can use splitter windows and display somethin...

Moving data to new exhange folders
Hi, I just changed my outlook email accout to use a Microsoft exchange server. This created new folders (inbox, calender, tasks, etc) in outlook that exist on the server. The problem is that all my data is in the old folders. How do I move the data (for instance all of my calender entries) from the old folders to the new folders? Dave Go to old folder and change the view to by category. Press ctrl + a to select all items in folder. Select Edit | Cut. Go to destination folder. Change view to by category. Select Edit | Paste. "Dave" <david.seltz@windriver.com> wrot...