Search results

oops. Sir i want this in the subroutine and not in the Function.

sir i would like to in macro because in future the sheets should be add. regards shahul

Dear Deb I output appearing in B2 Value. I want same like should come in B3 and B4 in the output file.

hi i want this run the macro not in the formula.

Hi In the workbook i have Output sheet and Sheet 2 & Sheet3. I want the sum total of the Sheet 2 & Sheet 3 to in the output file. I tried but the total is not working and not fill down. i am attaching the sheet for your reference. regards Shahul

check this

how to create multiple folders say example ten folders

yes i wish to gather all files in the folder console without combined data in the folder For example i have 3 files. the Three files should save in the console folder with different workbook 1) File1.xls 2) File2.xls 3) File3.xls

hi can u clearly explain how the output should come.

hi can u help on the macro

Now the excel files are save in the single worksheet.I want these excel file would be save separately as different workbooks in the folder mentioned.

Hi i want the files to save in the folder name Console console not as excel separately

yes working thanks

Hi I want to create one Folder and save Folder Name as Test using VBA Macro. regards shahul

Thanks i tried this option earlier but i put the double quotes in the end.

Hi, I am trying to put one macro which would open the excel file by path name and save as the excel file in the same name in the different folder. I am attaching the file for your reference. The File to be Save as in the below Path with the Same excel file. i tried but it is not working...

Hi I have a Folder Name Jan 2014 in that the There was date wise folder like 01st Jan , 02nd Jan etc. In that date wise folder i have a excel sheets. I want a macro which will console all the excel files in the different folders in one and the same excel file save in One Folder Name Called...

hi i need one more help i want to activate the open workbook by workbook name how to do that in excel macro code.

thanks deb working fine

Hi i tried that the macro is not working I stored the file Name as TESTFILE.XLS in the same folder.

Hi i have Folder Name "TEST" in that folder i have excel sheet (i have create workbook name test macro). In that Folder i have another excel file Name called "TESTFILE.XLS" With the help of macro i want to open the "TESTFILE.XLS" I have searched the macro but all has given to put the path...

how to refill the formula to right.

Hi i am attaching the macro code i have wrritten the macro code for auto sum the values. In that the dollar symbol is appearing i want to remove the static which is dollar symbol. For example in the B column=SUM(B$2:B15) i want this as SUM(B2:B15) and also help in writing the Macro code for...

Hi I am attaching the sample file which contains two sheets In the first data & Second Data i want the macro to put the average of Total wages / Total number of days. For sample purpose i am attaching the two sheets 4 sample datas. In the original the data nos will vary 10 to 50000 nos of...