Hi
thanks for revert but i dont want to use vlookup. I want macro code for
entering name n nos.
for example:
if i put Delhi in City field then name and phone nos of ADM and GM of Delhi
should automatically come in theri fields. Same as i put Mumbai .
Regards
Deepak Rawat
On Wed, May
Hai
Use the below formula in Summary Sheet B2 Cell:
=Sheet1!B2+Sheet2!B2+Sheet3!B2
Regards
On Tue, May 19, 2009 at 11:02 PM, Vandana Vallam vandanaval...@gmail.comwrote:
Dear Friends, Can someone help me to run a macro to calculate the sum of a
cell across sheets...for Example
Sheet 1 B2,
As far as I know it will not be possible to achieve what you are trying to,
by a simple macro.
Other way, I can think of, is to print each invoice to a file (prn file)
using the following code. Then combine all the prn files into one(using
macro). Then sending the print command using
Dear Chande,
Please use the following code.
Sub putclp()
Dim Txt As String
If ActiveCell.Locked = True Then
MsgBox this cell is locked
End
Else
MsgBox this cell is not locked
ActiveCell.Copy
End If
End Sub
Please let me know if it helps.
Regards,
Andy
On Thu, May 21, 2009 at 1:54 PM, DOLLAR
Hello all,
I have some hyperlinks in Excel 2007 that point to an external
webpage. Rather than clicking the hyperlink, copying the data, etc.
I'd like to have a function/macro that would grab the contents of the
webpage based on the Hyperlink and populate another cell in the
spreadsheet with
I'll try that out and get back to you.
For this example, creating multiple print jobs is trivial - but the
actual application involved many thousands of records that will be
printed, so it is a little more important to have separate print jobs
if possible.
On May 21, 3:45 am, Akhilesh Karna
pls send a sample data sheet, will write the code there.
Paul
On Tue, May 19, 2009 at 11:02 PM, Vandana Vallam vandanaval...@gmail.comwrote:
Dear Friends, Can someone help me to run a macro to calculate the sum of a
cell across sheets...for Example
Sheet 1 B2, Sheet 2 B2 and Sheet 3 B3 have
Hi All,
Can anyone provide the vba code to protect and unprotect all sheets in
excel.
Thanks regards,
Suresh
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1.
Hi all
How's everyone doing?
I am novice to macro, I need a help from you guys. I hope it should be
simple.
Present Scenario: I have a macro which remove non-breaking space
from all the cells at once in the worksheet. (If anyone need, I can
share the code).
Usefulness of the Macro: When you
Hi,
If you don't need any merged cells in your sheet, try putting these lines at
the beginning of your present code:
Cells.Select
With Selection
.MergeCells = False
End With
Range(A1).Select
Regards - Dave.
Date: Thu, 21 May 2009 23:11:30 +0530
From:
10 matches
Mail list logo