$$Excel-Macros$$ Assign already open workbooks name to variables using wildcard

Hi Experts, I require your help in another problem. I have n excel files already opened but want to assign file name to variables like File1 = ForecastLastUpdated_*.xls* File2 = ForecastLastUpdated_ReferenceInformation*.xls* Highlighted in red are file name pattern and will be using these varia

Re: $$Excel-Macros$$ Highlighted rows will be copy and paste in Sheet 2

Hi Ashu, PFA, Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Ple

Re: $$Excel-Macros$$X Copy sand paste dynamic data range

Thanks for response. All solution provided is considering outlook as default mail client. But my need is diiferent innfollwing way; 1. IBM lotus is my default email. 2. Need to paste filtered data (8 column and many row) as part of email. This will be in addition of body of the message. In abo

Re: $$Excel-Macros$$ Filter

You attempt to 1 again. 2014-09-03 14:57 GMT+07:00 daya p : > sir, > not accurate > pls with combo box > some changed bcoz if any 1 change data in sheet its not correct so i hide > that data only want 2 show form > > is i select india than next combo (state) show all state names than i > sele

$$Excel-Macros$$ Highlighted rows will be copy and paste in Sheet 2

Dear Sir, I have Data Table in Sheet 1, I want that, when i highlight rows in sheet 1, these highlighted rows will copy and paste in Sheet 2. Data will be pasted and over lap the data in sheet 2. Example : If I highlight row 1, 5, 8, then these rows was copy from sheet 1 and paste on sheet 2 on

$$Excel-Macros$$ Web query

hi i am new to this forum i have a litle problem to ask for solution i have this macro to search for models from this site but returns to me all the page of the product my question is there something to add in this macro to search a certain div class in this page to return me only the price or

Re: $$Excel-Macros$$ Auto filter issue

Actually i want first step auto filter, do the filter Column H (in this filter 3,4 and update the correct in column I) then again filter column D (in this filter GPRS all type) and in same time second filter column H (in this filter 5) Now update correct in status column. my question is when filte

Re: $$Excel-Macros$$ gogmap

Sir, try this one http://www.earthpoint.us/ExcelToKml.aspx On 3 September 2014 13:14, Aditya Aditya wrote: > Sir, > > thank you for replying to my email, > i already checked this > > i need my visited places movement on my ppt ( msw course field training) > ex: i visited first mumbai than dehli

Re: $$Excel-Macros$$ Filter

sir, not accurate pls with combo box some changed bcoz if any 1 change data in sheet its not correct so i hide that data only want 2 show form is i select india than next combo (state) show all state names than i select 1 state name than it it show its capital with 4 th combo data Country S

Re: $$Excel-Macros$$ gogmap

Sir, thank you for replying to my email, i already checked this i need my visited places movement on my ppt ( msw course field training) ex: i visited first mumbai than dehli than banglore than bidar etc G & H columns contains lat long data other columns are work details which i collected in