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 This
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, koul.ash...@gmail.com wrote:
Can u share how output will look like
Sent on my BlackBerry(R) from Vodafone
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
--
=OFFSET($A$1,0,0,COUNTA(A:A),3)
Thanks regards,
www.MrExcel4U.com http://mrexcel4u.blogspot.com/
On Mon, Mar 10, 2014 at 3:12 PM, Prafull Jadhav prafulltjad...@gmail.comwrote:
Dear All,
Good Afternoon,
I want a examples of Dynamic Range of Pivot.
for example
if i added new data in
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:
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
Hi Team,
Can you help me to fix this small thing.
Regards
Atul
On Sun, Mar 9, 2014 at 7:04 PM, Atul Kesaria atul.kesa...@gmail.com 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
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:
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,
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
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 caroline@gmail.comwrote:
Olá Ricardo.
Na verdade eu preciso manter dois arquivos atualizados ao mesmo tempo, vou
atualizar somente a pasta 1, e a pasta 2 deve
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 With
End Sub
On Mon,
12 matches
Mail list logo