Re: $$Excel-Macros$$ Excel Forum available @ discussexcel.com

Sub copy_data() Dim rowno As Long rowno = InputBox("Enter Row No") With Sheets("Sheet2") .Range("F21").Value = Sheets("Sheet1").Range("k" & rowno).Value .Range("D21").Value = Sheets("Sheet1").Range("E" & rowno).Value .Range("C21").Value = Sheets("Sheet1").Range("C" & rowno).Value End

Re: $$Excel-Macros$$ How to link a cell between two worksheets keeping the Hyperlink?

are you saving both the files in a same folder. You can try this with vba On Mon, Mar 10, 2014 at 11:59 PM, Caroline Campos wrote: > Olá Ricardo. > > Na verdade eu preciso manter dois arquivos atualizados ao mesmo tempo, vou > atualizar somente a pasta 1, e a pasta 2 deve conter sempre as mesmas

$$Excel-Macros$$ Re: Introduce Yourself !!

Hello all, Jean-Yves Hemlin, Programmer, analyst, teacher for the last 30 or so years. Used FoxPro from 1992 until 1995 when I discovered Access. Discovered Excel at about same period. In 1998 I discovered VBA (more exactly Word Macro). I realized shortly after that Microsoft was migrating all

Re: $$Excel-Macros$$ How to link a cell between two worksheets keeping the Hyperlink?

Olá Ricardo. Na verdade eu preciso manter dois arquivos atualizados ao mesmo tempo, vou atualizar somente a pasta 1, e a pasta 2 deve conter sempre as mesmas celulas e dados da pasta 1, ela deve ser atualizada toda vez que salvo o meu arquivo original. Só isso, as celulas devem conter vinculo, por

Re: $$Excel-Macros$$ How to link a cell between two worksheets keeping the Hyperlink?

Olá carolina boa tarde, Pelo que eu entendi, voce criou um link de uma imagem na pasta1 e colou o link na pasta2 e voce quer que ao clicar no link da pasta2 abra a pasta1? Caso seja isso, ao colar na pasta2, com o botão direito do mouse, siga a opção COLAR ESPECIAL, e Depois, mais embaixo: COLAR

Re: $$Excel-Macros$$- Query

Hi Team, Can you help me to fix this small thing. Regards Atul On Sun, Mar 9, 2014 at 7:04 PM, Atul Kesaria wrote: > Hi Team, > > Thanks for the help. However just found one bug in macro. If the status is > N in the AE column then the macro stops at that row and does not processed > over to

Re: $$Excel-Macros$$ How to link a cell between two worksheets keeping the Hyperlink?

Ok, the samples are attached, but you can see that the files are linked, but when i insert a hyperlink in the principal worksheet (pasta1), the other doesn't updates. Thanks for your help! *Att. Caroline Campos (21) 8102-4893* *Preserve o Meio Ambiente* *Por favor, pense em sua responsabilidade

RE: $$Excel-Macros$$ Duplicate Removal

Hello Saurabh, If you are not an expert in Macros (like me :P), try ASAP Utilities:- http://www.asap-utilities.com/ Regards, Prasad K From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Saurabh Madhusudan Patel Sent: 10 March 2014 15:06 To: excel-macros

Re: $$Excel-Macros$$ Dynamic Range for Pivot

=OFFSET($A$1,0,0,COUNTA(A:A),3) Thanks & regards, www.MrExcel4U.com On Mon, Mar 10, 2014 at 3:12 PM, Prafull Jadhav wrote: > Dear All, > > Good Afternoon, > > I want a examples of Dynamic Range of Pivot. > for example > if i added new data in master file then n

$$Excel-Macros$$ Dynamic Range for Pivot

Dear All, Good Afternoon, I want a examples of Dynamic Range of Pivot. for example if i added new data in master file then new rows or data should be added in pivot or suppose i delete the data thane range should be adjust accordingly Thanks in Advance. Regards, Prafull Jadhav 9920553518 -- Ar

Re: $$Excel-Macros$$ Excel Forum available @ discussexcel.com

Hi ashish, I dont have any outputs to provide. but i have explained it all in the workbook. Please do contact me if you need any informations. Thanks On Mon, Mar 10, 2014 at 1:14 AM, wrote: > Can u share how output will look like > Sent on my BlackBerry(R) from Vodafone >

$$Excel-Macros$$ Re: Link Custom Toolbar with a file

Hi Paul Many thanks for the reply. I'm looking at your suggestion, but I need a bit more. You say you ""created a macro called New_CmdBar in which I define the toolbar (called "PMTR"). "" I need to know what the relevant parts of that macro actually say. Also in the code you placed in