Search results

Hi, Please help me with my excel problem: I have a vba script that works fine, however, I don't know where in my script should I define the range so that it will not generate more than one page: =========================================== Sub SaveinPDF_Click() Dim iVis As...

Hi there - hope you're doing fine. I want to ask vbscript for copying data from an excel sheet then putting in into the body of a google mail. I know this works using Outlook but I don't know how to do this in google mail. I have attached my file as sample. I want to paste the entire format in...

Hi, I need your help on my excel problem please.... In my Total sheet, I have a summary of the total MRC and OTC on a per month basis using the data from my Summary sheet. In my Total sheet, how can I show the details if I click on the value of MRC of my desired month, say February. I only...

Hi, I need your help please... Using Forecast sheet, I want to filter column AA (Status) based on column Z (Month Bill Date) then re-number the filtered data (result of column BG) and copy them into another sheet (JAN) Sample: column Z = Jan-15 column AA = Churn Data that...

Hi, Please help me with my problem - I need your expertise again: In my userform is a Customer/Company Name dropdown. Values of this dropdown refers to CustomerName in Logs sheet. With these, I want to do the following: 1. New Customer should be added to CustomerName whenever a new data is...

Thanks so much Nebu. I didn't realize there's more to pivot :)

Hi, I badly need your help please... I have a Date Filter in B2 of MonthlyForecast sheet which is Bill Date column in RawData Sheet. Using B2, I want to extract all the data in RawData sheet and put them into MonthlyForecast sheet (Example: if I select Sep-15 in B2 dropdown, data that should...

Hi, I want to do multiple selection using listbox in my userform. I tried to look for codes to satisfy my requirements but I failed. :( Can you help me with the codes to do the following please: 1. ListBox1 should be one of the required fields upon clicking CommandButton3. 2. Values chosen...

Hi Lymm, I considered Chihiro's advise to use ListBox instead of ComboBox. Next, I tried to look for codes to satisfy my requirements but they don't seem to work :( Can you help me with the codes to do the following please: 1. ListBox1 should be one of the required fields upon clicking...

Hi, It's me again needing your expertise.. I have Userform28 with different comboboxes. Among these comboboxes, I only want one (ComboBox7) to select multiple values from. ComboBox7 should comprise MK1, MK2, CB1, MN1, MD1, UP1. Can you help me do the script please?

Great! thanks again, Ramesh :)

Hi, It's me once more asking for your help... In my userform (userform7), I added an Edit button (CommandButton1). Once clicked, I wanted this button to update the worksheet (logs) when I change or modify any or all previous entries of the textboxes and comboboxes in userform7. The default...

Thanks again, Ramesh - you're such as genius! :)

Hi, It's me again asking for your help. I created a userform (userform7) to view the existing values of a worksheet (Logs). The last value of combobox (combobox12) prompts as a default value. The default value (combobox12) should be able to retrieve the required data from worksheet (Logs)...

Thanks very much for the help Ramesh. It's working the way I want it now! :)

Hi Ramesh, Thanks for the immediate reply....the code works but the loop part doesn't apply to me - items in the ComboBox are coming from one of my worksheets (logs). Said ComboBox is being populated and therefore increasing in data. How can I substitute this using the "For i = 1 To 10"...

Hi, Need your help on this please: What vba syntax can I use to to set the last item of combo box as default value in userform? Your help will be greatly appreciated. Thanks,

Thanks very much, Nebu :)

Hi, I badly need your help on my excel problem please: In the attached file, I need to sum all the MRC by satisfying the following criteria: 1. Sales Agent is the same 2. Stage is the same 3. Month and year are the same I need to put the sum of MRC per Stage and per month just like the table...

Hi, Need your help so badly please.... I used the formula: =IFERROR(INDEX(Sheet1!$D$1:$K$1,1,SUMPRODUCT(($C3=Sheet1!$B$1:$B$100)*(Sheet2!$D3=Sheet1!$C$1:$C$100)*(Sheet2!E$1=Sheet1!$D$1:$K$100)*COLUMN($E:$L))-4),"") to retrieve date values from row1 of sheet1 and put each date in under...

Great! Thanks a lot Prasad DN. Really appreciate it! ;)

Hi, I need your expertise in solving my excel problem. I have an excel sheet that contains different stages on a weekly basis. I want to have it differently - using the same file, the column names will now be Stages 1 to 5 and the values on rows are the dates. I have attached my working file...

Thanks very much, again, Kanti! You're the best :)

Hi Kanti, I also get the same results but I only need only 1 value - Meaning if I selected "Service Management" from cmbProducts, I only want to get 1200. else, if I selected "Service Delivery" from cmbProducts, I only want to get 900 and so on.