Search results

Hi, I have been trying to group the data in pivot tables weekly. But not 7 days a week. I just want to club the data for the five working days. So for example if 1/3/2013 is a friday and the next week is from 4/3/2013 to 8/3/2013 i want the data to be clubbed as 1/3/2013...

Hi, I would like to know if it is possible to consolidate data from various sheets into one sheet. Actually there are multiple sheets in my excel workbook. I want to create a macro in which i can select as to which sheets i would like to consolidate as i want only selected data and not...

Hi, I am trying to create two Data Validation lists (one dependent on the other). when i change the value in the first drop down i would like the other drop down to either show a blank or one of the items in the list. Eg. If the first drop down is a country and other is cities India (in the...

Hi, I have paused the macros by using Exit sub and now i want the user to click on a button in the excel which will help him resume the code. I have tried the following but it seems that Goto works only in one Sub: Sub Next_Client() Goto 10 End Sub but this doesnt work. Is there a way...

Hi Chandoo, I am trying to run a VBA code in a workbook and after making changes i save the file with a different name. I need to run this macro n number of times. But when its run for the first time and the sheet is saved with the changes, i have to open the master workbook again through the...