Search results

This is a monthly report, we does it every month. I will prepare a sheet & will send you the latest one?

I don;t have the sample automatic one. To be honest I have different data in the drop down list meaning months(Jan, Feb, Mar, till Dec & Q1 to Q4) so everymonth I should select respective months accordingly, then I am pasting the data in different tabs, so there are 40 tabs. This task I am...

ok, is there any way to do that?

Thank you for your help. Vletm, I can see you have written sheet level coding right?. I cannot run the code by hitting F8 key. Will it be possible in module level?

Thank you for the quick response. To put it in a simple way, What I exactly want is in the Sheet1 A1 cell I have data validation, whenever I change the name from the dropdown list the data is automatically getting changed. So the question here is how do I change the names from the dropdown list...

Thank you for the quick response. I appreciate your help. But I need: 1) Macro to go select a person’s name from the drop down 2) Copy the resulting data from B6:D6 and paste in new worksheet 3) Do the same task for rest of the names available in the drop down list This is not based on the...

Hi All, Please help! I am trying to write a macro that is dependent on the drop down list. Once a name is selected from the drop down list that will show us some data related to the name selected. I need to copy the resulting data to another workbook. Problem is, I am unable to see anything when...

ok Vletm. One last question is it right the both answers will vary? I mean when we perform the calculations through Excel formulas & VBA the result we get is different right?

Vletm, thank you for your quick response. By Excel in C2 & D2 it is to be 40.73 & 73.71 not (C2=40,73 D2 =73,71). In the above answer you have mentioned the differences. Which is the one correct?

Hello All, I am trying to do multiplication with the help of VBA code instead of using excel formula. But the strange thing is I am getting two different results when I run through macro and excel. I would like to know the difference. Please find the attached excel sheet. Excel Result- 3002...

Vletm, thank you for quick response. I am little confused on your replies.To make it simple i want to find out last used cell in the selected range with the help of macro? would it be possible? if possible how?

Vletm, thank you for the quick reply. Yes i do agree we shall do by selecting the range by mouse. But i have a task where i shall open 40 files and need to copy data from all the sheets(like i've given in the excel sheet) and the same should paste into master sheet, so for this i'm trying write...

Hey Vletm, thank you for the code. But i am unable to run the code. When i run the macro through F8 & F5 command key it is not functioning. Any help will be appreciated.

Hey Alansidman, thank you for your help. But still i am unable to get what i want. Could you please check in detail?

Could someone help me out on the above?

Here is the question, I have attached two sheets Sheet1 & Sheet2 . I want to select the last used cell from the selected range, here my range is yellow color one. In this case I have colored the cell in red color that is the result I want. This cell may vary I mean it suppose to be in any other...

When i am trying to run the code which is there in sheet1 as you suggested it is working well for me. thank you.

Vletm, I am really sorry to trouble you, I can able to see the code now. Once again thank you for your patience and time. I really appreciate it. Thank you. Cheers.

I didn't missed any reply from you, Apologies i could not see any macro code in that post #25 sheet. Could you please send me that sheet again so that i can use that macro,

Could i know were is the macro code for this..?

Ok, thank you for your patience and insights. I will try writing the macro code for this.

I reread it, still confusing how it can happen automatically? Sorry for bothering you please bear me.

Vletm, it is working well. Thank you for it. Could you please let me know how did you do this? Did you do formatting cells or some other thing like this..?

Yes,

ok, Vletm. I have the option to use macros. what would be the code if i want to write in XLSX...? Could you please suggest..?