RE: $$Excel-Macros$$ Avg. Revisit in number of days

2012-03-04 Thread Amit Desai (MERU)
Can you please provide me your contact number..I think so I need to explain you on call. Best Regards, Amit From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: 01 March 2012 19:15 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$

Re: $$Excel-Macros$$ Object Hyperlin : Deletion

2012-03-04 Thread Chandra Shekar
Hello, Thanks for the reply. I have nearly 1000 graphical object in the work sheet. Macro is taking lot of time to get run some times it hangs also. I have a good processor & ram speed. Could you please suggest on this. Thanks in advance. Regards, Chandra Shekar B On Fri, Mar 2, 2012 at 3:34

Fwd: Fwd: $$Excel-Macros$$ condition problem in data receive from another sheet

2012-03-04 Thread Ashish Bhalara
I need only those data which date match with cell B32. Sorry Maries, your condition not worked -- Forwarded message -- From: Maries Date: Sun, Mar 4, 2012 at 11:15 AM Subject: Re: Fwd: $$Excel-Macros$$ condition problem in data receive from another sheet To: excel-macros@googlegr

Re: $$Excel-Macros$$ Need advise

2012-03-04 Thread xlstime
use Google Insert Image option in G mail or you can use link a .gif file... [image: Inline image 1] On Mon, Mar 5, 2012 at 12:41 AM, rekha siri wrote: > hi Experts, > > I Am excel trainer, just wanted to know how can we place this kind of > animation in mail for excel functions or training's >

$$Excel-Macros$$ Re: Macro to compare highlight and copy value to a new sheet

2012-03-04 Thread bpascal123
thanks, g'luck On Saturday, March 3, 2012 6:51:25 PM UTC, trawets wrote: > > Hi > > I have a standard work book with 3 sheets , in sheet 1& 2 there is > data, > in a column of sheet 1 there are a list of values, 10 digit string > with letters and numbers these values may or may not match value

Re: $$Excel-Macros$$ Macro to compare highlight and copy value to a new sheet

2012-03-04 Thread trawets
Again I must say, Pascal you have been extremely kind in spending your time with this, it is very much appreciated I am now going through the code trying to understand, Thanks and very best wishes Stewart On Mar 4, 9:08 pm, bpascal123 wrote: > Please find the code below with comment, although it

Re: $$Excel-Macros$$ Macro to compare highlight and copy value to a new sheet

2012-03-04 Thread bpascal123
Please find the code below with comment, although it is a little erratic... It's really a basic pattern matching. I assume G3198/3 is not the same as G31983 or 000G3198/3 or else... Sub CompareCopyPasteByeBye() '''DECLARE VARIABLES FOR OBJECTS AND ELSE Dim wbk As Workbook Dim wksA As Worksheet

Re: $$Excel-Macros$$ Need advise

2012-03-04 Thread dguillett1
google utube excel Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: rekha siri Sent: Sunday, March 04, 2012 1:11 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need advise hi Experts, I Am excel trainer, just wanted to know how can we place this

$$Excel-Macros$$ Need advise

2012-03-04 Thread rekha siri
hi Experts, I Am excel trainer, just wanted to know how can we place this kind of animation in mail for excel functions or training's Use CTRL + Enter To Enter Same Data in to Multiple Cells(Quick Tip) created by Raja Sekhar P on Mar 4, 2012 1:34

Re: $$Excel-Macros$$ how to save file in 2 different locations

2012-03-04 Thread dguillett1
I personally like the methods mentioned in David’s web site. Wonder why? Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: xlstime Sent: Sunday, March 04, 2012 6:45 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ how to save file in 2 different loc

Re: $$Excel-Macros$$ Macro to compare highlight and copy value to a new sheet

2012-03-04 Thread trawets
Thanks for the code and having tried this it works well, would it be possible to comment the code so I could follow it step by step and maybe try understand whats happens and when On Mar 4, 2:55 am, bpascal123 wrote: > Hi Trawets, > > Find your workbook attached, it should do. > Please check the

$$Excel-Macros$$ Macro to compare highlight and copy value to a new sheet

2012-03-04 Thread Pascal Baro
Hi, I don't known if the message is to go to Ayush, if it is, please Ayush, could you remove files sent to the discussion's subject since it seems to be files with confidential infos. Please find the user request below. If it's not Ayush, could someone else in charge of the forum do it? Regards, Pa

Re: $$Excel-Macros$$ how to save file in 2 different locations

2012-03-04 Thread xlstime
press F12 or save as or please find the below link http://dmcritchie.mvps.org/excel/backup.htm On Sun, Mar 4, 2012 at 5:48 PM, raghu gr wrote: > hi, > > I want save same excel file in two locations (different folders) if ctrl+s > is pressed, so that there will be no need to take data backup.

$$Excel-Macros$$ how to save file in 2 different locations

2012-03-04 Thread raghu gr
hi, I want save same excel file in two locations (different folders) if ctrl+s is pressed, so that there will be no need to take data backup. how to do it sir with regards raghu -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread title

RE: $$Excel-Macros$$ Turn Tab Order on/off

2012-03-04 Thread Asa Rossoff
Hi Charlie, The "button" is actually just a cell that is colored. It has Data Validation enabled for that cell that restricts values to "Activate" and "Deactivate". The "tab order" macro seems to be pretty straightforward and I would expect it to work with Excel 2000, but I am not an expert a