$$Excel-Macros$$ Re: duplicating data

Hi Lynn, Your description is a little too vague to allow a solution. Can you supply a few sample lines from each of the two sheets, and the result you want to see? David On Apr 2, 2:13 am, Lynn wrote: > I have 2 excel worksheets, both are in different formats. Both will > contain the same data

Re: $$Excel-Macros$$ Filtering in Excel

Hi thanks for pointing out the bug, its http://anonomi.com/iname Also if the topicstarter can provide the raw data it would be helpful is cusotmizing acc. to need. Now it is like working blind. Any in depth solution pls free to contact in link. On 4/1/10, rf1234 rf1234 wrote: > Hello Dear, > I ha

Re: $$Excel-Macros$$ duplicating data

Hi, You can use cell referencing for this. Please share a sample file for more help on this. Regards, Deepak On Thu, Apr 1, 2010 at 8:43 PM, Lynn wrote: > I have 2 excel worksheets, both are in different formats. Both will > contain the same data but spread across different parts of the > wor

$$Excel-Macros$$ Sum Product use in Macro

Hi Friends, Can Sum Product use in Macro Is it Possible to get some examples? I am in trouble Please help me. Regards, Rajesh. Nair -- -- -- Some important links for excel users: 1. Follow us on TWITTER for tip

$$Excel-Macros$$ Sum Product use in Macro

Hi Friends, Can Sum Product use in Macro Is it Possible to get some examples? I am in trouble Please help me. Regards, Rajesh. Nair -- -- -- Some important links for excel users: 1. Follow us on TWITTER for tip

$$Excel-Macros$$ duplicating data

I have 2 excel worksheets, both are in different formats. Both will contain the same data but spread across different parts of the worksheets. if I have filled in the data for 1 worksheet, how can i automate this data to be filled into the other worksheet? --

Re: $$Excel-Macros$$ need help

Hello Dear You can automate your excel workbook,according to need u can write code. If you are new then you can try to download from net. Some of the example are available here. http://www.excel-business-solutions.com/free_download.htm Please have a view of files,template which are uploaded by

Re: $$Excel-Macros$$ Filtering in Excel

Hello Dear, I have checked your provided link.It is showing spam free e mail registration. http://anonomi.com/about/ Now for the topic asked before. Shimmy you can try dependent list.Reply me if you are new and want more information. Hope it Will Help Happy to Help :) Shyam On Th

Re: $$Excel-Macros$$ Can Sum Product use in Macro

Hello As i dont like to use FormulaR1C1 i usually use : activecell.formula = "=SUM(.)" or as my excel is not english i use activecell.formulalocal = "=soma()" soma = sum in my local language understand? you can decide what is better for you Regards. André Luiz D'Avila. 2010/4/1 rf1234 r

$$Excel-Macros$$ Re: filter & print to PDF (or similar)

Hi, You are correct in your visualisation. If you care to send me a sample of (dummy?) data I will send you back a solution. Please specify if you REALLY want distinct files for each member, or would be happy with a sheet foe each member. Regards David On Mar 30, 9:22 am, holt wrote: > I hop

$$Excel-Macros$$ Re: Median in Pivot Table

Hi, This is another example of where Pivot Tables are not always the best solution. Send an example of the data and I will find a solution. David On Mar 16, 4:24 am, "Rahul Gandhi." wrote: > Guys, > > Can anyone help me to Get the Median Value in Pivot Table. > > Actually I am working on huge

$$Excel-Macros$$ Re: Pivot table on horizontal data

Hi, It may be that a Pivot Table is not the best solution to your problem. Send the example, your sample report, and let me try an alternative. David On Mar 19, 1:41 am, Ajay Varshney wrote: > Hi, > > Is there any way of creating pivot table on horizontal data? Means the > headings are in the

$$Excel-Macros$$ Re: Excel - sort with VBA problems

Hi, Where does the macro stop? David On Mar 19, 7:24 am, scubagirl wrote: > Hi everyone, > I have a program that generates Excel workbooks with multiple sheets > of data , and a function that create a chart each time it's called, > which happens 2 times per workbook. In order to make the chart,

Re: $$Excel-Macros$$ Re: How to remove Invisible symbols in a cell.

Hello Dear Try to select range what u want to format.then format cell then time then desired fromat. If you are looking this in VBA Macro.Then try to use this. ''

Re: $$Excel-Macros$$ Track changes macro

Hello Dear If your workbook is in share mode,you can trace the authenticate user,who has made the changes... Just try to check: Worksheets("Sheet1").OnEntry If true then report or save the log with user name and machine id. I am just giving idea,for full programe it will take time. Hope

Re: $$Excel-Macros$$ Can Sum Product use in Macro

Hello Dear Definately you can any formula in macro. R1C1="Your Formula" Hope it Will Help Happy To Help :) Shyam On Thu, Apr 1, 2010 at 5:10 PM, pushpender nath wrote: > Hi Rajesh > We can use any formula in Macro. > > Pushpender Nath > > On Thu, Apr 1, 2010 at 1:56 PM, Rajesh Nair wr

Re: $$Excel-Macros$$ Filtering in Excel

write in here: http://anonomi.com/DM yourorgname.net/branch/div/emplmgr/mgr/smgr/jmgr/sup/sub in excel format. On Wed, Mar 31, 2010 at 6:36 PM, Shimmy wrote: > Hello EXCEL_lent people. > > I am working for an emerging organisation/company. I would like to > create a spreadsheet in Excel for my

Re: $$Excel-Macros$$ Can Sum Product use in Macro

Hi Rajesh We can use any formula in Macro. Pushpender Nath On Thu, Apr 1, 2010 at 1:56 PM, Rajesh Nair wrote: > Hi Friends, > > Can Sum Product use in Macro > Is it Possible to get some examples? > > Please help me. > > Regards, > Rajesh. Nair > > -- > ---

Re: $$Excel-Macros$$ need help

yes. what do you want to automate. On Wed, Mar 31, 2010 at 11:47 PM, Shilpa Rao wrote: > HI > any automation tools getting graphs in excel or any other automation tools > in excel to get report or any free softwares to get report automated. > > > On Sat, Mar 20, 2010 at 2:47 PM, yogananda muthai

Re: $$Excel-Macros$$ Track changes macro

can you elaborate unauthroised access / On Thu, Apr 1, 2010 at 12:04 AM, seema mba wrote: > Hello Master, > > I have got a macro to track changes made in excel sheet. But the changes > are tracked in sheet1 of the same work book. I want a macro which keeps the > track of changes, in a different

Re: $$Excel-Macros$$ Re: Please help In seperating alphabets and numbers from a cell

Great point Paul, @Abhi To add to Paul's Excell insight with a working example, Suppose two functional links. http://j.mp/gate2010csit http://j.mp/gate2010cs exist Does your function need to identify the csit link from the cs link or not. Regards, DM http://anonomi.com/iname http://anonomi.co

Re: $$Excel-Macros$$ Data Import

On.Count >1l goto next worksheet. On Thu, Apr 1, 2010 at 11:44 AM, Mahesh wrote: > Dear All, > > Need ur expat advise... > > I got around 20 text files in a day,which had 13 to 15 columns separated by > "|" this sign. each file contains around 15 lacs or more line items. > > when i import that

Re: $$Excel-Macros$$ Tip of The day:Extract Number FROM Alphanumeric String

Hello Dear Syntax would be as follows... =SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( SUBSTITUTE(A2,"1",""),"2",""), "3",""),"4",""),"5",""), "6",""),"7",""),"8","") You guys are doing fine job,to giving the helping hand. Hope it Will Help Happy

$$Excel-Macros$$ Re: Help......................

Hi Abdul, Just send in your spreadsheet, so we can see it with our own eyes and then work on a solution Greetings Paul Willekens -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tric

$$Excel-Macros$$ Can Sum Product use in Macro

Hi Friends, Can Sum Product use in Macro Is it Possible to get some examples? Please help me. Regards, Rajesh. Nair -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : h

Re: $$Excel-Macros$$ Help......................

Hi Rasheed , You have to go to toolbar Tool --- > Option --- > Calculation and select "Automatic" . may be can help Worawat ~ Blog ~ 1 ~ Blog ~ 2 2010/3/31 Abdul Rasheed > hi fellows > i hit a prob in excel sheet ... on cha

RE: $$Excel-Macros$$ Tip of The day:Extract Number FROM Alphanumeric String

Hi, You could try using the formula provided for finding the numbers only, then use that result with the SUBSTITUTE function substituting the numbers with "" Regards - Dave. Date: Wed, 31 Mar 2010 11:03:55 +0530 Subject: Re: $$Excel-Macros$$ Tip of The day:Extract Number FROM Alphanumeric

$$Excel-Macros$$ Data Import

Dear All, Need ur expat advise... I got around 20 text files in a day,which had 13 to 15 columns separated by "|" this sign. each file contains around 15 lacs or more line items. when i import that text file in excel 2007, it takes the first 10 lacs records; rest does not come. Need ur help to