Search results for query: *

I want to produce a millage calculater in Excell, but it involves 2 millage rates. any millage less than 2000 is calculated at 40pence per mile and any subsequent millage is at 20pence per mile. I enter the total millage in one cell but need the sintax for the differentiating between the 2...

Save as problems ? Could any help with this, I need to use a cell value as the file name, and then save to a specific directory. I have the sintax to get the cell value and save, but do not know how to save to a specific place. The code I already have is: ActiveWorkbook.SaveAs...

VLookup, ive used this code but keep getting an error message highlighting $c$999. I need A3 in the first sheet to display a value from one of the 2 data sheets. The value entered in A1 shows which data sheet to use, A2 in the first sheet shows what value to look for in the data sheet and A3 of...

Toga, I have 3 sheets in excel, the 1st is used to get data from the other 2. The data is in the form of 3 columns A, B, & C all numbers. As below Data Sheet 1 Data Sheet 2 1st Sheet A B C A B C A1= 1 (data sheet 1) 1 10 50 10 50 1000 A2= 2 (val to...

Can anyone help, I have 3 sheets in one docement, 1 is a form and the others are data to be used as inputs for the form. What I would like to do is enter a number in the form sheet, say enter a value of 1 in A1 that tells the syntax which data sheet to use, then again in the form enter a value...

Could anybody help, I have a spread sheet that has a top row of dropdown lists, when selecting any cell in the row directly below the drop down I would like the value from the dropdown to be put into the originaly selected cell. I.e. If A1 has a dropdown with values 1 to 10 in it, selecting cell...

Could anybody help, in a spread sheet I would like to have a top row of dropdown lists, this I can do, when selecting any cell in the row directly below the drop down, having selecting a value from the dropdown list it is putt into the originaly selected cell. I.e. If A1 has a dropdown with...

Works a treat, thanks for your time. Cheers Andy Hickson

I've just written some code to check the lottery numbers, I have a large sindicate and need to check 16 columns of 6 numbers against the 6 lottery numbers that are placed in a row of six. Heres what I've got so far, the code works by checking every numbers in each row and returning the matched...

I've just inherited some excel files to amend and update, the problem arises when I try to change any of these files as they are password protected and have all the code hidden. What I would like help with is either removing the protection or unhide the code so I can save it as something else...

Xlbo, I get no error message, the file just happily saves its self to the directory I'm working from. Cheers Andy Hickson

I need to save a spread sheet to a specific directory using the value of a cell as the file name, the code below refering to the cell value to be used works, but the saved file is saved to the drive I am currently working in and not the directory path in the code below. Any help would be much...

Cheers mate, thanks for your time. Andy

I am trying to save an excel file to a specific directory using the value of a cell as a file name, the using of the cell value works in the code below, but I cant for the life of me get the file to save anywhere but where the original file is saved? ActiveWorkbook.SaveAs Dir =...

I am trying to save an excel file to a specific directory using the value of a cell as a file name, the using of the cell value works in the code below, but I cant for the life of me get the file to save anywhere but where the original file is saved? ActiveWorkbook.SaveAs Dir =...

Cheers, thanks for your time. Andy

Anyone, I would like to use the value of a cell within my spread sheet as the file name for the saved version of my file, I.e Cell A2 value is 100200, I would like to use this number to save my excel file as 100200.xls. The value of the cell changes with different clients but will always be a...

Could someone help me, I need to send my spread sheet via email when I save and exit? Anyone help.

Cheers !!

Please forgive me, for I do not understand the fName variable, what I need to do is take a number from a cell in another spread sheet and use it as the file name for the one that is to be saved !