I have 2 excel sheets with 2310 companies name in first sheet and 2850 companies name in second sheet, whereas the 2nd list contains all the names of companies which i added in first sheet. I hope u got, I mean the second sheet has all the companies of first sheet so indirectly i have same companies in second sheet as well. Now my issue is that i want to know the newly added companies that is 540 companies are being added in second sheet, the big blunder i made is i sorted them alphabetically else, i would have got the names, but will ny1 can suggest me how to sort 540 companies and to highlighted them.I followed Advance Filter option in Data, whereas it is giving me all unique records which is fine, but want to know which are not duplicated by first sheet. any questions please mail me allwyn1f@yahoo.com
133832
If for example your older data is on Sheet1, then in the column next to the 'New company name type this formula in cell B1\n\nHere is the formula\n\n=IF(ISNA(VLOOKUP (A1,Sheet1!$A$1:$A$2310,1)), "New Data","Existing Data")\n\nCopy this formula next to each of the new addresses.\n\nIf it finds an existing entry the Word "Existing Data" will appear, and if it's a brand new entry then the word "New Data" will appear!\n\nYou can then simply use an AutoFilter to sort out the new and existing data (You will need headings over your data)\n\nHope this helps.
253890
#1.  You are assuming that the active worksheet is the first one in the book .. if it's not, it will bomb ... see ActiveSheet property\n\n#2.  You are assuming that the macro/VBA is running in this book, but if the user has multiple workbooks open, this may not be the case ... see ActiveWorkbook object.  Better?  Select Workbooks by name (see Tag values independent of filenames)\n\n#3.  Font, color, bold are meaningless for a programming problem.  Omit them for future clarity in asking a question.  Less meaningless stuff we have to wade through.\n\n#4.  Cells(1,1) depends on where the active cell is, the user or your macro may be jumping to a different place than you think it is.  Has someone inserted a row or column ?\n\nI've been doing VBA for 15 years and I have no clue what you mean by "The server threw an exception" ... you mean what ?\n\nClues as to how to fix ... use named ranges and offsets.  Name a range (always relative to the range).  Offset from there.  Always select the correct window, workbook and sheet by name, not index value.  Omit needless code from your recorded macros such as "Transpose=False" ...\n\nStop recording macros and trying to make them work.  Recording is good to get you started, not for real code.\n\nAll in all, it's a very nice semi-adjusted recorded macro.\n\nI'm not dissin' on ya Partner !   ;-)\n\nThere are good habbits and there are bad.  Learn the good habbits and life will be a cake-walk.\n\nAlways define a marker cell ... typically the top/right corner of your range or table or whatever.\n\nAlways reference everything from that point.\n\nLock the worksheet to prevent users from inserting/deleting rows/columns.\n\nUsed named sheets ... not index values.  All one has to do is insert a sheet and you're hosed.\n\nSuspenders and a belt ... this is Visual Basic here ... anything can happen.\n\nHere's a useful link for you ... just understand that here, you're pretty much expected to know your stuff or be very, very concise and specific in your inquiries and responses ...\n\nhttp://www.tek-tips.com\n\nI would encourage you to look through the forums and judge for yourself before you post.\n\nGood luck.  If I can help you out, my contact info is in the Bio.  There is always more than one way to do things ... collect the best, chuck the rest !   ;-)
481183
Are there duplicates in either column? That could make this not work very well. If not, use this in a third column, just copy it down alongside.\n\n=IF(COUNTIF($A:$A, B1)>0, B1, "")
311514
To completely automate the deletion of duplicates you have to code (not record) a macro. However, with some manual intervention you can do it without any code.\n\nThese methods assume your data is in one or many columns of contiguus data with a label in the first row)\n\nMethod 1 (more manual)\nSort your data\nScan for the dups and delete the rows\n\nMethod 2 (less manual)\nClick anywhere in the data you are working on\nGo to Data, Filter, Advanced Filter\nIn this new window select the following:\n Copy list to another location\n Your list range should already be selected\n Click in Copy To and select a destination cell\n Click Unique Records Only\n Click OK
149843
Youl should list them in reverse order.  Your current position first and your first position should be listed last.  It is probably a good idea to list all 3.  It will show your prospective employer that you were promoted twice and that you are versatile.
420160
Let us call the first 2 "2 sub 1", the second "2 sub 2" ... same thing for the 6's.\n\nLet us say that "2 sub 1" is distinct from "2 sub 2", and so on.\n\nWe have 8 choices for the first number, seven choices for the second number, etc. This means that there are 8*7*6*5*4*3*2*1 choices, or 8!. \n\nNow if you look at any number, take all of the 2's out. You see that you can rearrange the 2's in 3! different ways (including the original arrangement) using the procedure in the paragraph above. If we take out the 2's rearrange them, and put them back in we have created the a new arrangement. So for each arrangement of numbers, we have counted it 3! times. So we divide by 3!. The same thing for the sixes, we divide by 2!.\n\nThe result it (8!)/((3!)(2!)) = 3360 choices.
463245
Column B forumula:\n=COUNTIF($A$1:A1,A$1:A$6)\ncopy & paste down. Formula will change. Second cell will be:\n=COUNTIF($A$1:A2,A$1:A$6)\nThe "$" forces the cell letters and numbers to stay the same.\nResults:\n\nColumn A Column B\nTexas ............ 1\nOhio ............... 1\nOhio  .............. 2\nMichigan ........ 1\nOhio ............... 3\nTexas ............. 2
223781
I faced these issues in Excel2000, What is yours?\nAny way\nThis is happening when you use a big file for a long editting time.\nI suggest to make a new file and copy the your sheets to it.\n- Right click on sheet name and select Move or Copy..\n- In the "To Book" select (New book)\n- Check the "Create a copy" below and press Ok\n- Do the same to other sheets but select book1 in "To book" drop down box\n- If you have macros you can copy them also into the new book\n\nI guess this is a problem in Excel2000. This is how I solve this issue..\n\nXLMan
629951
You cannot do that in Windows folders. You may have to use some other software for this purpose. One way is to create an excel spreadsheet with following columns:\n\nFirstName MiddleName LastName Folder\n\nNow put the link to the folder in the Folder column so that you can click and open the folder. You can sort by first name or last name using Data -> Sort menu
597709
You could add a temporary number column and use autofill to fill it down to the row which contains the last of your name data.\n\nSelect both this column and your name column and sort the name column alphabetically (ascending). Delete the blank rows (which should now be at the top) and then re-sort (ascending) by your temporary number column.\n\nThen delete the temporary number column.
636264
Not sure if this is what you mean, but ...\nCreate an Excel sheet,\n\nRow 1 is the titles, in this order\nDate, Value, Sale, Month 1, Month 2, ... Month 6, Month 7, Sale Total, Accumulated Total.\nYou can use whatever titles you want.\n\nIn Row 2,\nLeave Date and Value blank.\nIn Sale, type '=B2*0.045',\nIn each month, eg, Month 1, Month 2, etc, type '=B2*0.025'\nIn Sale Total, type '=SUM(C2:J2)'\nIn Accumulated Total, type '=SUM(K2)'\nSelect the columns, C2 to K2, then grab the little square in bottom right hand corner of the selection you just made.  Hold you mouse button down, go down the page to how many entries you want.\n\nThe only thing you will have to do manually, is to update the Accumulated Total column.\nRow 3, =sum(k2:k3)\nRow 4, =sum(k2:k4),  etc
601060
I think its called conditional formatting. If value is cell b2 is greater than value in cell c2 then format cell b1 with bold color italics etc.
190569
This is tricky.  You really need a new field that will tie the correct entry and exit records together.  The only way I can see it is to add a new numeric field (call it entry_exit_id or something).  Then you'd need some code that sorts your data by persons name, entry time.  Then it would loop through each record and assign a unique counter number to each entry/exit pair that goes together.\n\nAfter that - you'd be able to use Group By to group on the name and entry_exit_id. Then you could do the math.
374574
Hello,\nThe inner query, which is\n\nSELECT [Employee Information].FirstName, [Employee Information].LastName, Courses.CourseTitle, CoursesCompleted.CourseID\nFROM Courses INNER JOIN ([Employee Information] INNER JOIN CoursesCompleted ON [Employee Information].StudentID=Courses... ON Courses.CourseID=CoursesComple...\nWHERE (((CoursesCompleted.CourseID)=... THE COURSE NUMBER])))\n\nreturns a set of first names, last names, course titles and course id numbers; however you are checking whether >only< the first name and the last name of a particular employee is in that set. If I'm not mistaken, both sides of the 'NOT IN' clause should contain the same information. In this example, one side (outer query) contains the name of the employee, and the other side (inner query) contains the name of the employee + course information. \nTry this: in the second query select only the first and last name of the employee (not the course info) but keep the joins in the FROM clause.\n\nIf I had designed the tables, I would assign a unique id to each employee, just as courses have their unique course ids. It would have eased this task a lot.\n\nI know I sound confusing, but hope it helps
523552
[EDIT - DELETED A WHOLE BUNCH OF TEXT]\n\nthat kind of thing is complex to create in a macro form, normally the kind of thing that you'd pay someone to do because i'd imagine it's easily a couple of hours work to write all the code, test it, iron out bugs etc. there *may* be a built in function in excel to do something like this but i wouldn't have thought so - i'm happy to be proved wrong:\n\n----found on t'internet----\nA1:A10 (your list of values)\nB1:B10 (leave blank)\nC1: =A1*B1 (copy thist fomula down through to C10)\nC11: =SUM(C1:C10)\n\nNow to use Solver....\nTools>Solver\nSet Cell: C11\nEqual to the Value of: 1173.76\nBy Changing Cells: B1:B10\nSubject to the Constraints....\n(click the add button and constrain B1:B10 to Binary)\nClick [OK]\nClick [Solve]\n\nExcel will toggle cells B1:B10 between 1 and 0 until it comes up with a combination that sums to 1,173.76\n----end of instructions----\n\nit depends on the setup of your spreadsheet - if it's one huge page that's a jumble of undistinguishable invoices with no reference to who the invoices belong to, it means manually checking the results of the macro for the set of results that applies only to one 'customer'. ideally you'd want a seperate sheet for each customer and then the macro or above method can be ran on whichever sheet/customer the cheque is from.\n\ni dunno about other people on here but i wouldn't spend hours of my time creating such a thing for the sake of 10 points which aren't really worth anything - i CAN tell you that if the above method doesn't do the job that it'd mean creating a loop that will add up every possible combination of totals from the sheet then comparing it each time against the grand total until it gets a 'hit'.\n\ni can't imagine this kind of sorting being practical for huge amounts of figures, probably a list of 20 at most because you could get into some big big processing time otherwise.\n\ni would be interested in hearing anyone elses ideas about doing it?
417199
http://www.officerecovery.com/excel/\n\nTry here if the help in Excel doesn't help.\n\nRegards\n\nRob
9997
I'd copy the emails from each sheet & do a vlookup to each set. Delete the ones that are matched & then do a vlookup to the original sheets to bring ini the rest of the details.\nI'd take them into Access tho if you can. You could link the sheets to a data base & export the query results back to Excel.