Posts by sudarshan.kmr

Re: Run macro code stored in xlsm file in all the other xls files in the same folder

There are around 30 xls file in the folder and each having around 15000 rows of data.First of all I tried to collate data from all the xls file in the master file but because of the huge data size file hangs hence i am trying to run a macro " Churn Data" in each excel file one by one and then collate only the specific data (churned data) which will have maximum 1200 - 1500 rows of data in the master file.As requested i am attaching the master file.

Hi All,

I have a master file(Xlsm file) in a folder which has few codes in it.There are several others xls file in the same folder and with data in only one sheet of the workbook.I am trying to open all the xls file one by one,run the code stored in the master file ,save the workbook & close the file .I am able to open all the files but unable to run the code in the other xls file.
I tried every possible thing but failed. Please help...

Hi,

I have two workbook "Raw Data" and "Summary".
I have two macros M1 and M2 in "Summary" with 30 plus sheets in it which i use to get data from "Raw Data" workbook.In the Raw Data wb, there is a filter with almost all the sheet names in it.i m looking for a code which will select the sheet name in that filter and run Macro "M1" in the same sheet name of the summary wb.If the sheet name is not present in the raw data wb it will run macro M2.
I know it is bit confusing so attaching the two dummy files.kindly assist.

Re: macro to repeat row data down based on datedif criteria

thanks a lot Mike.This is exactly what i was looking for.

Re: macro to repeat row data down based on datedif criteria

Hi mike,
thanks for ur quick reply.i wanted data to be repeated till the from date and to date is equal and datedif is equal to 0.but in the above code data is repeated till the datedif is 1.

i m looking for a code which will repeat the data down based on datedif criteria.Col A contains From date,B contains TO date and C contains datedif in days.if datedif is 10 it will repeat the whole data down 9 times and everything remains except the from date which will repeat till the from and to date is same.I m attaching a sample file which might help in understanding my problem,pls advice as i m stuckup on this problem for a long time.

i m looking for a code which will repeat the data down based on datedif criteria.Col A contains From date,B contains TO date and C contains datedif in days.if datedif is 10 it will repeat the whole data down 9 times and everything remains except the from date which will repeat till the from and to date is same.I m attaching a sample file which might help in understanding my problem,pls advice as i m stuckup on this problem for a long time.

Hi,

I have a workbook with 17 sheets.Each sheet is linked with formula.I am looking for a macro to return to the previously viewed sheet.Say i moved from sheet 1 to Sheet 7 ,is there a way i can again return back to sheet 1 from sheet 7 by running a macro.


Regards,
Sudarshan

Re: Fill formulas down column and convert to values

Hi Shree/Nagesh,

Thanks a lot for your help.

Regards,
Sudarshan

Re: macro to drag formulas down depending on data in the other sheet of the same work

Hi Shree,

i am attaching the dummy file. I have to dump more than 2000 rows of data daily in dump sheet and then have to manually drag formulas in calc sheet accordingly.we use one file for a months and by the end of month file gets very heavy and takes a lot of time to update.please check the dummy file hope that will make it more clear.

Sudarshan

Re: macro to drag formulas down depending on data in the other sheet of the same work

please help

i have a workbook with two sheets-dump & calc.in the dump sheet i dump data on daily basis ,in calc sheet have calculated formulas which i drag down depending on the no of rows of data in the dump sheet.i m looking for a code which will drag the formulas down in calc sheet and except the last row will change all the formulas into value

Re: macro to change series color in a pivot chart based on its value

it really worked.thanks a ton

hi everyone,
i am looking for a code which can be used to change the color of a series in a pivot chart based on it value.like if series value is greater than 60 - green,between 50 - 60,yellow and less than 50 red.
please help.