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

2015-01-22 Thread sswcharlie
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

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

2015-01-22 Thread sswcharlie
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 fr

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

2015-01-22 Thread amar takale
Dear Experts Pls tell me solution. On Tue, Jan 20, 2015 at 10:59 AM, amar takale wrote: > any solution? > > On Mon, Jan 19, 2015 at 4:24 PM, amar takale wrote: > >> Dear Experts >> >> Can anybody tell me why this word not change its pagesetp format. We can >> change word page setup through VBA

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

2015-01-22 Thread Vaibhav Joshi
Hey Bill Share a sample sheet with data.. Cheers! ᐧ On Fri, Jan 23, 2015 at 3:25 AM, Bill Q 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 all ? > > On Thursd

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

2015-01-22 Thread MLT
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 ??

2015-01-22 Thread Bill Q
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". > ("ta

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

2015-01-22 Thread Shyamayi Dakoju
*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 and I will get back as soon as possible.* *ONLY GC AND CITIZE

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

2015-01-22 Thread Paul Schreiner
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$$ Search Box - Event Macro ??

2015-01-22 Thread Bill Q
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 g

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

2015-01-22 Thread Mazhar Khan
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 earl

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

2015-01-22 Thread Mazhar Khan
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. *Pos

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

2015-01-22 Thread Mazhar Khan
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 cont

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

2015-01-22 Thread Mazhar Khan
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: Need a Formula or Macro to pick-up values from other sheets

2015-01-22 Thread Ashish Kumar
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, Urgent,

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

2015-01-22 Thread Pravin Gunjal
Thanks. On Thu, Jan 22, 2015 at 5:00 PM, Ashish Kumar 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 Alternate Options for it

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

2015-01-22 Thread Paul Schreiner
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: VBA - Cell with comma separated serial numbers - send list to individual cells

2015-01-22 Thread Ashish Kumar
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 Help,

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

2015-01-22 Thread Vaibhav Joshi
Cheers Buddy!! ᐧ On Thu, Jan 22, 2015 at 4:15 PM, Ashish Kumar 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 of this forum @

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

2015-01-22 Thread Ashish Kumar
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. S

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

2015-01-22 Thread Pravin Gunjal
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 G

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

2015-01-22 Thread Pravin Gunjal
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 wrote: > Thanks. Pravin ...!! > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's > =TIM

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

2015-01-22 Thread Ashish Kumar
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 tit

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

2015-01-22 Thread dza49
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 H

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

2015-01-22 Thread Vaibhav Joshi
Its working Good Ashish.. ᐧ On Thu, Jan 22, 2015 at 1:41 PM, Ashish Kumar 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 @ > https://www.facebook.com/discusse

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

2015-01-22 Thread XLS S
You can also use Split function with array in VBA . Enjoy Team XLS On Thu, Jan 22, 2015 at 1:41 PM, Ashish Kumar 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

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

2015-01-22 Thread Ashish Kumar
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$$ Re: VBA Intersect Range...

2015-01-22 Thread Ashish Kumar
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 titles