Search results

I have been forwarded a worksheet where rows 1-11 are not visible. I have tried to unhide them but this is not working. What else could be going on that would prevent me from being able to access these Rows and what I could do about it. More Info 1 - The rows are visible in Print Preview 2 -...

Thank you very much Brian So that I learn too, I will try both methods. Regards Matt

Thank you Brian. Is there a none VBA solution that your aware of. With Vlookup and Match and Countif and Address I have been able to:- Locate the Lookup Identify How many entries there are The address of the first entry What I am failing is being able to use this information to populate...

Hi all On 'Sheet1' Range A1 the user enters a "product code" and using Vlookup on a range on 'Sheet2' a number of ranges on 'sheet1' are populated. The issue is that using Vlookup I can only populate with the first entry that meets the criteria. The problem is that the "product code" entered...

Thank you Guys Regards, Matt

Hi all I have a worksheet that within column G I enter my mileage (a row each day). What I currently have At the top within the Freeze panes is a =Sum(G5:G234) which clearly adds up all the mileage from G5:G234. The only downfall is that I have to keep adjusting it each time the data goes...

Done I now have the means to control, just need the ability now. One step at a time. Thank you Guys Matt

Brian Thank you for your help, but my initial problem is now that I have to use Excel 2007 I cannot find how to get hold of the VB Editor or any of the controls that I once had in earlier edditions of Excel. Once I have that I will try the process you have uploaded. Thank you, Matt

Brilliant, perfect Thank you Holger. If I knew how to make that an add-in I would, its a very handy code. My only other problem is that I have to now use Excel 2007 and cannot find the usual icon's on the toolbar for creating ComandButton, ComboBox etc or even how to edit one all ready...

Thank You Holger I have copied and pasted the code into Sheet1. I guess its not going to be as easy as copying and pasting. I have read the code to try and understand what and how to apply it so that it works. Unfortunately I am hard of thinking and cannot work out, where, how or what I did...

This may be an ask too far. What I currently have:- A range (on sheet 1) A1:K2572, What I would like to know/how to:- Automatically select from each of the 59 names listed in column A (as in Filter), copy all of the information (rows) from each name and create a tab to copy the information...

Brilliant Thank you. Matt

Is it possible without VBA to:- Based on the value of range A1 to allow corresponding drop down list in B2 ie If range A1 = "yes" then the drop down list (Data Validation) in range B1 will display 1, 2, 3, 4, 5 If range A1 = no then the drop down list (Data Validation) in range B1 will display...

Thank you Brian I have changed a couple of things and it works the way that I wanted it too. I just have a lot of Case's to add. I have attached the file with the changes for information. Once again thanks for your help. Regards, Matt

I would have to programme the linked cells. The worksheet for the user is purely for visual information once its been populated by me. (well with lots of help) I am having a look at your attachement now. Thanks, Matt

Thank you Brian My only concern is that I haven't use CASE before so nows as good a time as any to start. I will still hold out for anyone with a dynamic approach too. Thanks for your help. Matt

Guys as always its not the quality of the response that’s an issue but the quality of the question raised. I think that I may have a better way of asking the question. 1. The User selects a single Cell in Range E6:I47 (this range will increase) 2. Specific cell(s) in Range J6:Q47 need to be...

Please find attached a file that I hope is self explanatory. Details are on the worksheet. I am getting unexpected results and I am sure that there is probably an easier way of writing what I am trying to achieve. My issue is explaining clearly what I am trying to achieve. There are hundreds...

What could I have done to stop me from being able to format some cells on a worrksheet. If I right click in some of the cells on the worksheet and click format, nothing happens. If I drag an adjacent cell over the cell that I previously could not format, then I am then able to format that cell...

Thank You There will be no break in the numbering sequence as I don't intend the user to view this sheet. That is some formula. No chance of me stumbling on this one through trial and error. Regards, Matt