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 -...

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...

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...

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...

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...

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...

I have "Sheet1" that contains a range "W14" I have "Sheet2" that contains a range "A:A". Within Range "A:A" is sequential numbering with the last one being the most up to date and always being added to. I need "Sheet1" Range "W14" to be populated with the with the last entry at the bottom of...

I have the following formula that was created using the auto sum, so I don't understand why I am receiving an error message. Cell (B2) contains a postive value Range (B3:B7) contains positive values Cell (B8) needs to subtract the value of Range (B3:B7) from Cell (B2) The auto sum helps...

I have been using the same worksheet for months. All of a sudden the values of formulas do not update when an associated range value is changed. I can F2 the cell and the cell value changes accordingly but there are a lot of formulas. Can anyone tell me:- 01 - Why this may have happened (to...

I have a range of cells (A1:A77) that each contain a value such as:- N002 Lift Lobby N003 Corridor N006 Shower etc etc What I would like Is to extract this information from each cell to the adjacent cells so that Range B1:B77 contains N002 N003 N006 etc etc Range C1:C77 conatins Lift Lobby...

UserForm1 contains 3 x TextBox. TextBox1 the user inputs a number TextBox2 the user inputs a number The User then clicks a ComandButton What I would like when the ComandButton is clicked is the result of this simple calculation to appear in TextBox3. TextBox2/TextBox1 Can this be done...

I have a ComandButton1 on Sheet6. How can I still keep it visible when in use but when Sheet6 is printed and or saved as, ComandButton1 does not print, and/or saved as. The user may save the workbook as another filename (Save As) or print the worksheet at anytime. I would only like...

I have a Macro that starts when Ctrl+Shift+C is pressed. I would also like this macro to start when the user clicks Range("S18") on ("Sheet1") Can you please advise me. Regards, Matt

I have a UserForm1 with a MultiPage1 containing Page1, Page2, Page3, Page4, Page5, Page6. Pages 3 - 6 (inc) Enabled = False. When UserForm1.OptionButton10.Value = True I need Page3 from the MultiPage Enabled = True. What I cannot seem to do is reference the Page3. I have got this far but...

Has anyone got a workbook that if you give the following information. Loan amount Interest rate Duration of loan Monthly payment and whatever else would be needed. That a table would be produced that would produce the following information on a month-by-month basis. Total Amount Oustanding...

I would be grateful if someone could explain what Debug.Print ............. is used for and where. I can see it in code but cannot work out what it is used for. Regards, Matt

How would I go about using multiple ComboBox's to search ie. ComboBox 1 Complete list ComboBox 2 A reduced list based on ComboBox1 choice ComboBox3 A further reduced list based on ComboBox2 choice Regards, Matt

I would like to assign or create on the toolbar an icon/button that will launch a UserForm. Is this possible? Regards, Matt

I have a UserForm1 on it is a Multipage2. On the Multipage2 I have a Page9 What I would like to do. When OptionButton1 is checked I would like Page9. Enabled = False This code comes up with an error. Can you please advise where I am going wrong. Regards, Matt