Posts by inktec

Re: Restricting Print/Mail/Export on Sheet

thanks will fiddle with that cheers for advice

HI, is there any way with Excel 2003 to prevent users from printing, e-mailing or copying any of the data from the sheet. Bots.

Re: Chart

getting there, the issue is that at each freq, the x axis is not showing correct scale. i.e. at 5740, the x axis should show 25 for snr, 27 disk 60, 21 for m-wave 2f, 22 m-wave2f ring. Where is it getting the range on the x from 0 - 160. Also the y series needs to increase in 5's not 10's. The X range needs to be between 15 - 50. aaaaarrrrrgggggghhhhh

Re: Chart

been trying to do that, not winning!!!!!!!.

Re: Chart

Hi, thanks for speedy reply, cannot plot the chart. I need to display each of the antennae’s performance against each other with the given range of freq. almost displayed as line charts layered over each other

Please see attached table.

I am attempting to show performance of three wireless antennae against a frequency range. The range starts at 5740 and end at 5830.

I need to be able to demonstrate via a graph, the performance of SNR-SU, dish60, m-wave 2f, mwave 2f – ring against the various frequencies.

PLEASE HELP. confused Motswana

i have two columns with text in each. Say HP in column A, and 51645A in Column B. I would like column C to read HP - 51645A. How do I join these two fields to do this, many thanks. Botswana

Re: Automatic Numbering of Job Card, Insertion of Date and Time into selected Cells

got it mate, thanks very much, works the bomb. Cheers Ciaron

Re: Automatic Numbering of Job Card, Insertion of Date and Time into selected Cells

hi, pls see attached. Need the numbering in the cell with xxxxxx thanks, Ciaron

Re: Automatic Numbering of Job Card, Insertion of Date and Time into selected Cells

hi, thanks for reply. Ideally I would like one copy on a server that can be accessed by all and used to generate the paper trail. The idea is that once printed the doc is attached to a machine for the workshop, work done filled in an invoiced. Once all this is done the job card is filed. Thanks, Ciaron.

Hi,

I have created a job card for computer repairs and rather than print out a whole load, would prefer a system where any of my staff can open the job card, print it and fill in the details. I however want the sheet to automatically (number, date and place the time), once printed the sheet should automatically update the JOB CARD no, thus creating a unique set of numbers that can be tracked. Is this possible???. Also is it possible to protect the excel sheet as to restrict staff access from manipulating the data. I assume read only would do this, but then would the sheet automatically update the job card no for the next time it is opened.????

Thanks, Botswana

many thanks for your help

I have two columns with text and want to link them in a third coloumn.

i.e

Colomn A = 51645AE
Colomn B = HP Orginal Toner Cartrridge

Colomn C = 51645AE - HP Orginal Toner Cartrridge

Help on a formula would be most appreciatted.

Thanks,

Botswana

Formula for price comparisons

Brilliant, Thanks very much.

Botswana

Formula for price comparisons

here you go. Doc attached.

Formula for price comparisons

how do I upload a file

Is there a formula that will allow me to check the prices of a product in three or more columns find the cheapest and display the cheapest price in an additional column? In addition, once this is done in two separate columns it must identify the supplier name and supplier code.

I constantly compare my supplier prices and would like to be in position where a formula does this and identifies the cheapest supplier, code and price. This would save me tons of time. I can attach an example of what I am attempting to do.

Many Thanks,

Botswana