Search results

Sorry Narayan, This does not seem to work. https://docs.google.com/file/d/0B_upMYdtf67Rb0Y1YjJqeG5ZSTA/edit?usp=sharing Please find the link Thanks again Rana

Any help please?

Hi All, The below code only copy pastes values in the sheet that is generated. How do i get it to copy & paste formulas and formats in the sheet that is generated. Sub breakMyList() ' This macro takes values in the range myList ' and breaks it in to multiple lists ' and saves them...

Hi, Can you please share a solution to help me extract contents of a specific coloumn from multiple excel files (saved in a specific folder on my desktop) to a blank new excel file which has the same coloumn headings. Basically I have recieved expense files for the last one year. I dont...

Hi Faseeh, I have followed the above and donet eh graph but I am not sure if its right. If you can have a quick look and let me know if its correct it will help me. Thanks Rana

Hi gurus, I am trying to understand how to create speedometer charts. Having read instruction I have managed to put the graph together. My problem :- I want the speedo meter to have a scale of 1-4 and show me 2.63 in the chart. However the donout should also show me individual weights as...

Hi SP, Sorry but this is not working. https://docs.google.com/open?id=0B_upMYdtf67RYWc0VzRRN1pkZ0E I changed the button name to 'Calendar' and when I right click on the userform1 and click on VBAproperties - it gives me 2 options (Genral and protection) no names were enterend by Narayan...

Thanks Narayan - will look forward to hearing from you.

Hi Narayan, Sorry to be a pain, below is the documnet that I am trying to get the calendar working but dont know what I have not done to make it work like yours. Sorry for being dumb. https://docs.google.com/open?id=0B_upMYdtf67RZEptemN4dkhFc0E Thanks Rana

Hi Narayan, You are a magician :) The next time I come to India if I am anywhere close I would love to meet you and thank you personally :) What I want to understand is how did you do this? I can see the macro code but dont know what have you done behind userform1 to make it populate the...

Hi Narayan, Thank you ever so much for your help but I think I have a different requirment. Sorry for being thick but really appreciate your inputs and the time you invest to answer queries. https://docs.google.com/open?id=0B_upMYdtf67RN05nX3VRS29ISVE&invite=CMj5x94D Let me know if you...

Hello, This would have been perfect but looks like somebody has deleted the sample file. I dont know how to get to the calendar module to put in your codes. Please help. Rana

Hi Gurus, I am working on an excel form, I have a need to add a calendar picklist in the form. I have created a userform and added a calendar. I then went back to my spreadsheet created a button and assigned a macro to it. The macro shows the userform with the calendar. My issue is when an...

Hi Kaushik, Thank you for coming back. I will try my best to explain, but please keep those questions coming in. 1)=IF('Lookup sheet'!C2="all","what?","if not then what?")] RR:- I have named two ranges in the Lookup sheet. Catagory and Item. So if IF('Lookup sheet'!C2="all","then it...

Hello experts, Please pull me out of this - I am struggling to make anything out of this formula. Need some urgent help to get a formula working. I think I have partly cracked the formula but my boss has added a spanner to the wheel. The formula needs to be in ‘Data Sheet’ - column G in...

Hi Muneer, Thank you for your comment - I know how to add a list. My questions was how do I default the cell to show the first name in the list? "3. Type in the source Click Here, AAA, BBB,CCC" How do I get it to display 'Click Here' in the cell. In your process it will only show me a...

Hi Luke, Thank you for helping me out here. Your 4th suggetion sounds more fit for purpose, but dont know how do I do that? Can you please help. I though there will be some VBA code to default 'click Here' in a cell unless something is selected from the drop down menu. Many thanks Rana

Hi gurus, Can you please help me to find a way to give a header to an excel list? cell A1 to be called 'Click Here' and should include a list that I can put using data validation. Please please help as input message in data validation is not a great solution. Thanks Rana

Hi All, How do I give a title to my dropdown list. I want users to see 'Select Here' in the cell. I know how to create a drop down from data validation. please help Rana

The below code is to manage the radio buttons Sub question9y() ' ' question9 Macro ' Rows("17:20").EntireRow.Hidden = False Rows("26:32").EntireRow.Hidden = False Rows("22:25").EntireRow.Hidden = True Rows("33:38").EntireRow.Hidden = True ' End Sub Sub question9n() ' ' question9n...

Some body please help me :( I have posted it on the forum as code conflicts

I have inserted a radio button that hides rows (3:10). In the same spreadsheet I have inserted codes that need to unhide row (4:4) if I select "yes" from range("A1). The radio button works perfect , however the second code to unhide row (4:4) based on list selection is not working. I think its...

Hi All, I am struggling to put this form together. This is quite a complex form and any advice will be great. https://docs.google.com/open?id=0B_upMYdtf67RSlNvS0pDSWVoN3M I think I have understood the logic of hiding rows based on list selection.However, I cant get it to work :(. Tab 1...

Hi Narayan, I am struggling to put this form together. This is quite a complex form and any advice will be great. https://docs.google.com/open?id=0B_upMYdtf67RSlNvS0pDSWVoN3M I think I have understood the logic of hiding rows based on list selection.However, I cant get it to work :(. Tab...