Search results

Hi, I know just enough about Excel to make me dangerous and to make my boss think I can do anything :). I have a spreadsheet with 44 sheets, it is for inventory going to our conference. out = inventory being sent to conference and in = inv coming back from the conference. we have a column...

Thank you so much for the quick replies, I will study the macro code and see what I can learn, but yea, this is doing exactly what I need it to do and should be able to print labels out just fine. Thank you again Birdiegirl

SirJB7, I apologize that I posted in the wrong room. I will make sure any future questions will be in the correct room. Thanks :)

I actually will use A G I H J,K,L on a 2x4 white avery label or equivalent (10 to a page) currently, I have an access file that I have to update everytime there is a change to an address and that is the file I use to create the labels. I am looking to create labels from an Excel file as my...

Yes, both of those addresses should have been the same as each other. I have a number of clerks that imput information and it can be a challenge to get them to not leave a hidden space or to put the NW after the street and not before.

loaded the file just now, I will check out Macro's and learn what I can, it Excel can do what I do for me as a macro, I'm game to learn it. thanks for the suggestion I appreciate it

here is a sample of my file

Hi, I am birdiegirl, and I am not sure how to ask for what I want. I have a spreadsheet that lists 175 different addresses, but the addresses repeat for each unique person at that address. So, the total line items in somewhere in the 865 range. I want to figure out how to cull that master...

Sir, Thank you so much for the tips here. I really appreciate it. somehow I knew that it would be that darn space and I guess I could also fix it by nameing my sheet my_info instead. again, thank you very much Birdiegirl

all right, I am trying to change your formula to my information. It has your 1st list in 1st sheet A1:B5, your 2nd list in 2nd sheet at same place. A2:B5 cells (list without titles) has this conditional formatting formula to highlight matches...

SirJB7, your spreadsheet does look like it is doing what I want. I will try to apply to my spreadsheet and will reply with Success or not soon. Birdiegirl

okay, went to rapidshare, hope i did it correctly http://rapidshare.com/files/2284477268/comparing.xlsx sheet one is what I get from my financial services group sheet two is what I keep through out the month it is a list of shipping charges and the # of the person it is associated with...

yes sir, i did search in this site. i found the three matches you listed in your reply. I tried to apply them to my situation but the correct information was not returned. i can compare column a to column b with no problem. where I have the problem is when I try to compare column a & b to...

Hi, i have been looking around for all the answers on comparing two lists. I get how to compare two lists with conditional formating and such. but, my list is a little different and i guess I am just not getting how the conditional formation will help in my situation. let me try to explain. i...

birdiegirl here, use this site a lot to find answers to my questions on Excel. get Chandoo's email every day. :) birdiegirl aka Lisa

Excel Ninja, Thank you for your reply. I will read the posts you suggest to familiarize myself with the netiquette rules and also to search for answers first. I have looked at your example and it it exactly what I need. I have saved it and will disect it to understand how it works. thank you...

I administer a spreadsheet for a non profit organization that sends packages to soldiers overseas. about 7 times a year we send packages to the troops and before each mailing, I send an email to the "sponsor" asking if the troop is still overseas and do I still have the correct mailing address...