Hi All,
I have a named range as datavalidation in one cell and in another range I have the same named range. I would like to change the second data validation based on first one.
Eg:
In Cell A1 I have first data validation and in B2 i have second data validation. Both of them have same...
Hi All,
I need help in getting the selected items from a pivot table report filter. I have Country field in my report filter and I have multiple selections . I want to get through code what are the selections made by user.
I am attaching a screenshot for reference.
Hey All,
I have a scenario where I have to rank positive to negative and also to ignore zero's. I have attached a sample workbook. Any help would be much appreciated.
-Dinesh
Download link for sample wbk:
http://www.fileconvoy.com/dfl.php?id=gd08bec0452a32e45999269815da70cd365334f4c5
Hi All,
I have written a module to login into a webpage, do some operations to pull a report using VBA. I need help in downloading the file in IE. When i click the download option a pop window opens and I am not sure how to connect it in VBA.
Thanks in advance.
Thanks,
Dinesh
Hi,
I have a set of data which has a column with years eg:2001,2002..20110.
I would like to show only 2010 in the report filter. Is there any way to do this?
-Dinesh
I went through the forum and viewed text sorting using formula's but could not get..
What I would like to do is I have a list if text as below
A
Z
D
B
C
To
A
B
C
Z
D
I want to sort it to in ascending order Except D as i always want this in last .
Recently my system got upgraded to Windows 7, My addin is loaded and it shows in the ribbon but when I click nothing is happening. I have enabled all macros in trust center settings. I am using Win 7 & Excel 2007(Addin developed in 2007 with XP). Please let me know if you have any solutions.
I have created a dependent combo box (Form controls). I am filling the data for the combo boxes using named ranges.Each combo box is lined to a cell to get the index. The problem I am facing is the cell link(for Country) is not updating when the combo box has only one value. I have sample...