Search results for query: *

Good morning. I have a column(B) of numbers (with extra info next to each number)106048 r89989 bhk227t. In column(A), I will key numbers that may match column (B)numbers. If column (A)match any in colulmn (B) then I want to change background colors in column (A) and column (B)(with the extra...

Gents, My error. For some reason it didn't work b/4. The =IF(I6>"","","ea") formula works fine. I quess I syntax erored it or something....thanks much guys!!!!!!!!!1

Gents, Thanks for the info. I have tried all of them, but alass, none of them seem to work. The only one that works is if a zero "0" is in the H4 cell. If it is blank it won't work. Unless Vestax's... =If(H4="";"";if(H4>,"ea","")..may work but...

Using Excel in the cell I4 , =If $H4>" ","ea"," ") ??? what I'm trying to accomplish is: if H4 is greater than a blank then put "ea" in I4 else I4 is blank. The above formula works only if H4 has alpha charactors. I need it to work for numbers. ???...thanks

Microsoft Outlook (windows 2002XP)...Sent messages area In windows '98 there was a "tracking" tab that showed the time & date read...of the person you sent the message to and the time & date that person forwarded the message on to the next person. In windows 2002XP that tab does not...

Good morning. On a worksheet I have created a header (top row) with command buttons used to sort various data. The data is purchasing info. I want to add another button ?? that shows a person's name & # times that person's name appears in the list(how many times he/she has ordered things). I...

tanks berry much..

this works great. thanks much..where did you find the REPT ? I assme that is a repeat.

thanks..much

I have a list of names. The cell next to the name adds the number of times the name shows up in the worksheet. I'm wishing, in another area of the worksheet, to show a "*" (star) for every time over 10. e.g. 11=* 12=** I'm using EXCEL...thanks

good afternoon. I am creating a list of names. Next to each name is a cell showing how many that name is used. In another place on the same workpage I wish to show a "*" (star)for every time that name is used over 10 times. e.g. 11 times= * 12 times= ** etc. I am using this in EXCEL...

thanks for the info..I used the 1st one.Merry Christmas!!

Good morning. I use an excel sheet(many pages)for input of purchasing info. I am forever paging up & down looking for things. Right now the object is to have the cursor goto the bottom of the list & sit on the next unused line. I use Autofilter to find the next "blank" in the date...

trampkp, I found it...It was in the customize,toolbars section. the "stop recording" box was not checked... Thanks so much for the help you have given me. Now I have toobars for record, play & relative reference at hand.

The relative reference tool is usually on the right side of the "stop recording" toolbar. It changes the mode from absolute(a particular cell)to relative(the currently active cell,eg;anywhere you are on the page). My stop toolbar that usually appears when recording is missing.

Trampkp, Thanks for the info. I also need the relative reference tool that is usually with the "stop recording" toolbar. Please.

Good morning. I am creating a macro. Normally, when the macro starts there is a small "stop recording" window that shows up on the screen. This window does not show at this time. How do I activate it?

Geoff, I have practiced with the AutoFilter(couldn't figure out the AdvancedFilter). This one will work. The entire file has to be sent, but that's ok. Thanks for your help.

Geoff, Thanks for the info. In my situation, I have to forward a listing to another manager showing all the open PO's along with the rest of the corresponding info in the same row. I was trying to create a list on sheet2 that would be automatically updated. I'm not sure how to do that with...

Good morning.. File has rows A?:K? (open ended as rows are added frequently). row B?(date submitted) row F?(date rec'd) All this on sheet1. The "want to do" is: On sheet2 show all rows(A?:K?)that do have row B?(date submitted)filled in, but do not have row F? (date rec'd)filled...