Hey Skip,
I'm running MS Office 2003 Excel
11.5612.5606
what I did was select coulumn Accounte and then Data and then Auto Filter. this worked but also pu the auto filter on all coulmns as well ie BDM I createda seperate sheet with three column of garbage now the account column is on A but...
I did that skip and yet it place the pull down tab on all columns??
Jamie
Is this normal the other column do no show all the info like the account column
Hi Skip thanks again for your help I'm thinking the auto filter might due no the question is can I do the auto filter on just the one column
Account BDM ISO SA CSM Products Margin
As the I have more heading than this but the auto filter shows on each column it would be really nice just to...
hmmm sounds like that might be it but will I have to remove all the hyper links??? ya another silly question lol
and I can just add that a s a formula correct??
Hey Skip your right thanks I have taken out the spaces etc and will try ands see if it meets our needs I just basically want our sales support to use this when looking up who belongs to what and any special in. Thanks for all of your help.
Jamie
well skip, that kinda work but still shows additional information about the other customers in the columns\rows below. Also when I set the filter to auto and if there is a space between listing of customer which there is (more so because I created the sheet first using an account assignment...
basically the idea is to have one sheet with important customers then click on the customer to view information about them ie sales rep for that account etc there are 9 columns on the second sheet of needed information incdluding the customers on sheet 1 I'm now sure how the auto filter works is...
hey there bascially sheet one has the customers and then yes the second does show the customer ie
sheet one
select as a customer
asd
rty
uio
asd
qwe
then sheet two has information regarding them
ie
asd kjasdfkj askljdhkasjdf lksjdhjkasdh kljsdjkahsdf
rty sdaff sdfdasf sddf...
Hi The I have created a spread sheet using two seperate sheet and hyperlinking them ie customer to information regarding the customer ie contacts etc all in a row now the problem is when I click on the hyper link it gives me the entire page with the row info I need highlighted this is great but...
Hey folks thanks for the info, Keith I already have started doing you suggestion just becomes cumbersome as the master and the slave are fine but I have many other sheets that are not part of the master yet.
Hey Folks,
I 'm in some desperate need of some advice I do the pricing for my company and over time have created many excel work books that I have to update thoughout the year and it is insane I do the update then I make the same change to about 10 different sheets so my questions is how do I...
Hey Folks,
I ran the EXPERT utility and it looks like the tape drive is
writing/reading. If you have any other suggestions as to why I
continually receive the "Cannot locate the specified media or backup
device. This backup operation will terminate." message from within
ntbackup...
hey Folks,
Anyone ever senn these error with a DLT 8000 My backups have been failing lately. One symtom gave all lights on solid and yet the leader. here are the system log file entries, mt status output and the output
of cat /proc/scsi/aic7xxx/1 -- I do notice that the Tape drive entry...
Ok here it is
2 servers intel STL2 with on board ultra 160 and both after install win 2000 report "the driver detected a controller error on Device\Scsi\adpu160m1" no crashes, parity errors or anything, drives have beeen replaced and mother board as well. Any thoughts.
Jamie
Hello Folks,
I was wondering if anyone has seen this. I have an exb-480 with 4 mammoth 2 in it running with solaris 2.7 and legato 6.X. Every once in a while I get tapes being marked full when clearly they are not ie 2 gig out of a posible 60 gig native. I have replaced tapes and tape...
HI Badash57,
I have not tried that per say just to note my tapes 1 to 4 do the incremental during the week and 5 to 9 for fulls on the weekend. The bad tape is reported on the slot 5 and then continues ok to slot 6.....etc
Hello all,
I hope you can help. Every once in a while I have Bad media reported, with a LXL8110 with one DLT 8000 and at this time it looks like the slot ie 5. I have replaced the drive several times. The slots seem to vary. So am I looking a BAD media. Note I'am using backup exec for Win...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.