Re: $$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets

Hi I am working with it and observed that while opening the window for batches it's taking much time. Can we do something for it. On Tue, Jan 20, 2015 at 7:28 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Thanks. Pravin ...!! -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

Re: $$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets

Thanks. On Thu, Jan 22, 2015 at 5:00 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Hi, Hardly it's take 3 second for showing Batch Details. Did you checked the count of Batch Data which was in the user form. The Count is more than 5000. It's heavy..!! Yes We have two more

Re: $$Excel-Macros$$ Re: VBA - Cell with comma separated serial numbers - send list to individual cells

Cheers Buddy!! ᐧ On Thu, Jan 22, 2015 at 4:15 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: Thanks for ACK. Vaibhav Bhai. Say Cheers...!!! 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

Re: $$Excel-Macros$$ How to Save DBF files in Excel 2007

You MAY have your Excel versions backwards. You said FoxPro wants to save as 2007 and you said: I do not have 2003 version and having only 2007 which means you shouldn't have a problem! However, if you really DO have 2003 and NOT 2007, and FoxPro only exports 2007, THEN you have a problem.

Re: $$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets

Hi, Hardly it's take 3 second for showing Batch Details. Did you checked the count of Batch Data which was in the user form. The Count is more than 5000. It's heavy..!! Yes We have two more Alternate Options for it. First is, Use the First Sheet, which I'hve send to you on dated 17th Jan.

Re: $$Excel-Macros$$ Re: VBA - Cell with comma separated serial numbers - send list to individual cells

Thankyou Vaibhav Bhai. -- 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 Please

Re: $$Excel-Macros$$ Re: Need a Formula or Macro to pick-up values from other sheets

Welcome...!!! -- 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 Please Help,

$$Excel-Macros$$ How to Save DBF files in Excel 2007

Hi Good Evening I am working with foxpro and unable to save DBF files in excel 2007 while saving it's asking to save in current formats of excels. Can you tell me is there anyway to overcome from this issue / any solution because I do not have 2003 version and having only 2007. Thanks, Pravin

$$Excel-Macros$$ Immediate interview === Looking for Production Support Analyst ==== Nashville, TN. Weekend Drive.

Hello , I'm Mazhar Khan, with Systel Inc. We've an urgent requirement with one of our client for *Production Support Analyst – L2 (Unix Shell)*. *Nashville, TN. *Please find below the job description for the same and revert back to me with your consultant updated profile and contact details at

Re: $$Excel-Macros$$ Re: VBA - Cell with comma separated serial numbers - send list to individual cells

You can also use Split function with array in VBA . Enjoy Team XLS On Thu, Jan 22, 2015 at 1:41 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: PFA Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s

Re: $$Excel-Macros$$ Re: VBA Intersect Range...

Charles, PFA for find last value in column. 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

Re: $$Excel-Macros$$ Re: VBA - Cell with comma separated serial numbers - send list to individual cells

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 Please Help,

Re: $$Excel-Macros$$ Excel Macro to Protect Sheet - password application not working

Excellent, thank you sir!! -- 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 Please

Re: $$Excel-Macros$$ Re: VBA - Cell with comma separated serial numbers - send list to individual cells

Its working Good Ashish.. ᐧ On Thu, Jan 22, 2015 at 1:41 PM, Ashish Kumar kumar.ashish...@gmail.com wrote: 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 @

Re: $$Excel-Macros$$ Re: VBA - Cell with comma separated serial numbers - send list to individual cells

Thanks for ACK. Vaibhav Bhai. Say Cheers...!!! 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

$$Excel-Macros$$ Very urgent need of Siebel Apps Developer/Lead ==== Charlotte, NC.

Hello Associate, I'm Mazhar Khan, with Systel Inc. We've an urgent requirement with one of our client for *Siebel Apps Developer/Lead**. Charlotte, NC *. Please find below the job description for the same and revert back to me with your consultant updated profile and contact details at the

$$Excel-Macros$$ Very urgent need of iOS Developer ==== Charlotte, NC == 6 Months.

Hello Associate, I'm Mazhar Khan, with Systel Inc. We've an urgent requirement with one of our client for *iOS Developer. Charlotte, NC *. Please find below the job description for the same and revert back to me with your consultant updated profile and contact details at the earliest.

Re: $$Excel-Macros$$ Search Box - Event Macro ??

Hi Paul, Sorry yes, I meant autofilter. Are there any other options that are not overly complicated that can do what I would like without using the autofilter at all ? On Thursday, 22 January 2015 12:34:48 UTC-5, Paul Schreiner wrote: I'm not sure what you mean by filter tabs. (tabs is

$$Excel-Macros$$ Urgent need of Business Analyst with Telecom industry experience ==== San Ramon, CA/Middletown, NJ.

Hello Associate, I'm Mazhar Khan, with Systel Inc. We've an urgent requirement with one of our client for *Business Analyst with Telecom Domain. San Ramon, CA/Middletown, NJ *. Please find below the job description for the same and revert back to me with your consultant updated profile and

Re: $$Excel-Macros$$ Re: sum values with col/row criteria

Vabz, At the bottom of the attached sheet, I highlighted 3 examples and what the expected return values would be for each example. The coloring is meant to show which ranges the example criteria would refer to. Is there a better way to show? Basically I'm lookin a formula that can count the

Re: $$Excel-Macros$$ Search Box - Event Macro ??

Hey Bill Share a sample sheet with data.. Cheers! ᐧ On Fri, Jan 23, 2015 at 3:25 AM, Bill Q ronsmith...@gmail.com wrote: Hi Paul, Sorry yes, I meant autofilter. Are there any other options that are not overly complicated that can do what I would like without using the autofilter at

Re: $$Excel-Macros$$ Change or destroy word page setup through VBA code

Dear Experts Pls tell me solution. On Tue, Jan 20, 2015 at 10:59 AM, amar takale amartak...@gmail.com wrote: any solution? On Mon, Jan 19, 2015 at 4:24 PM, amar takale amartak...@gmail.com wrote: Dear Experts Can anybody tell me why this word not change its pagesetp format. We can change

$$Excel-Macros$$ Search Box - Event Macro ??

Hi, I currently use filter tabs when filtering data. It is a very useful. However, what I would like is to have a search cell (Say A1)that specifically would filter All cells from A3 to A1 that contain what ever is typed in as you type in without having to press the enter button or

$$Excel-Macros$$ Urgent Requirement VM Ware Architect| Savannah GA |4+ Months Contract

*Hi**,* *Hope you are doing great!!* * Please find the requirement below **,* *If you find yourself comfortable with the requirement please reply back with your updated resume with details to this email id s.dak...@esskay-inc.com s.dak...@esskay-inc.com and I will get back as soon as

Re: $$Excel-Macros$$ Search Box - Event Macro ??

I'm not sure what you mean by filter tabs. (tabs is a term derived from the index tabs on file folders that the sheet tabs are made to resemble) You may be referring to the autofilter pull-down/drop-downs? So, it sounds like you want to enter a value into a cell and have the autofilters

$$Excel-Macros$$ Re: VBA Intersect Range...

Hi Ashish Thanks for your WB etc. My Excel2000 will not open. Are you able to post .xls version which I can download. Thankyou Charlie Harris On Thursday, January 22, 2015 at 6:50:01 PM UTC+13, sswcharlie wrote: Hi Excel2000 On code below I get a 'syntax' error. On row-

$$Excel-Macros$$ Re: VBA - Cell with comma separated serial numbers - send list to individual cells

Hi Everyone I am in a different time zone and later to respond. In New Zealand, already Friday evening. Thankyou for your comments and workbooks. I am using Excel 2000 .xls and the WB for 'Charlies Column Split' and 'For Charlie'I had to convert to .xls using OfficeCalc. Iam away