Excel

I have a master worksheet (Worksheet1) that has two columns titled ID and Route. Each Route has a corresponding ID assigned to it. There are about 1600 rows (records) in this worksheet.

3

Can any one help me with this formula?

 

3

Just looking for advice on how to eradicate macros from an excel file.

I originally created two macros in the monthly management accounts file

3

An increasing number of clients are paying by standing order and as such keying the information in Sage is becoming a tiresome task.

8
1

Giday UK.

'A' contains a month & year, ie: Nov 2001

'B' contains a random value, ie: 320,000 (Three hundred & twenty thousand,)

9

Last year, we created a spreadsheet tp keep track of various data for our clients, consisting of a workbook for each client containing the sheets:

1

I am trying to create a list box in Excel 2007.  I can draw one successfully, but when I right-click and select "Format Control", I do not have the dialog box "Control" available - so I can't speci

3

If I enter a number beginning with 0 such as 01234 unless I put a ' in front it drops the 0 when I press enter. Is there a way of stopping it doing this other than entering a ' each time?

6

Pages