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 tried looking for the solution everywhere but was not able to. Actually i have created a code to consolidate the data in a specific manner. But this code will consolidate the data from all the sheets available in the workbook. I want to give user the choice to choose as to which sheets...

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

@SirJB7 Well my problem is when i change the country automatically the city cell should either become blank or it should reflect a city from the country. that is not happening and i would really appreciate if someone could help me do it without using VBA

Dont we have any formula where we can put in the data validation form that comes up. Where we put the formula=INDIRECT() in place of this cant we use any formula for the same? And if no, can anyone help me with the VBA code for the same.

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

@ Luke Thank you so much. Your code did the trick. It was so simple and still i couldn't figure it out :). Thank you all for the instant inputs.

Ok let me elaborate the problem. I want the user to insert n number of sheets based on their requirement. The program ask the user to mention the number of sheets to be added in the beginning of the program. Say if the user inserts 2 then the fist client will have three sheets and then there...

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

Thanks Vijay. But i have already tried this. When i close the active workbook the macro too gets closed with it and it does not continue in the new work book. I have thought of a new way. I will create two different macros and call the second one using the first one in any open workbook. I hope...

Thank you so much for the instant replies but..... :( i am still not able to do what is required. I am making another effort to make my problem clear Process 1. Open Master File 2. Do Stuff ( Here the master file gets edited- except the particular client's detail the rest of the data gets...

Well let me explain my problem once again. I have a master file with n number of clients. I have created a code which will take the input from the user the names of the clients whose data is required. this code is in the Master file. Now as the first name is input the formating and editing is...

Ya the macro gets saved in the new workbook. If you want i can post the code too for further clarification

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