Hi Yasir,
I do recognize, there is a simple solution im seeing is that you have create
a unique ID of the combination of "Code" & "Color" based on that you can
have your values by vlookup.
the sheet is attached herewith...
On 8/30/08, yasir_shahjee <[EMAIL PROTECTED]> wrote:
>
> Dear pala
Hi Atul,
this formula is not working for rows i think that i am doing some mistakes
pl check why it is not working for cell b4
what is the mistake
Thanks
Regards,
Shaily
On Thu, 28 Aug 2008 SINGHAL, ATUL. wrote :
>Hi Rishi,
>
>The formulae in the enclosed file may help you.
>
>Regards
Hi Darshan,
Thank you so much for this code.
For the following code to work it is necessary that all the other files
namely sales and Emp_Info must be opened. But I do not want to open those
files. All these files are saved in a particular location say on E:\Data.
Hence, I will open only file Con
User GetOpenFileName method for the same. attached is an example workbook
_
"There are known knowns. These are things we know that we know. There are known
unknowns. That is to say, there are things
Thanks Atul,
I never thought it was so simple
Regards,
Shaily Commercial Office HUL
On Thu, 28 Aug 2008 SINGHAL, ATUL. wrote :
>Hi Rishi,
>
>The formulae in the enclosed file may help you.
>
>Regards
>Atul
>
>
>-Original Message-
> From: rishi [mailto:[EMAIL PROTECTED]
>Sent: Au
Use following code
Sub copy_data()
Windows("Consolidated").Activate
Sheets("sales").Select
Windows("Sales").Activate
Range("a2:b7").Select
Selection.Copy
Windows("Consolidated").Activate
Sheets("sales").Select
Range("a2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, Sk
you are welcome dear
stay smart
On 8/24/08, Ashish Khandelwal <[EMAIL PROTECTED]> wrote:
>
>
> Thanks for your answer the formula is working as was required.
>
>
>
> On 8/21/08, Munson, Herb <[EMAIL PROTECTED]> wrote:
>>
>> If cell A1 contains the value, then I think the first expression be
Hi Folks,
I'm working on a macro that generates a chart on the basis of just
refreshed table. But as the table refreshes each time I need to delete
the already existing chart (that is the only one chart on that sheet).
Could anyone help me please how can I get the properties/name of that
existing
try this
' before copy paste this code you must draw a textbox a label and a commond
button.
Dim rw As Integer, cl As String
Private Sub CommandButton1_Click()
TextBox1.ControlSource = cl & rw
Label1.Caption = cl & rw
rw = rw + 1
End Sub
Private Sub UserForm_Activate()
rw =
Dear palani
I am member of $$Excle-macros$$ one time you was help me about trali detail
Dear now i hve another problem i attached sheet kindly check it.
thanks and regards
--
Masoom Dost
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http:
Thanks for your help.
i have one more question...
i just want to browse folders and select one excle file, without any
predefined file name in program itself.
Thanks,
GK
On Aug 28, 5:34 am, Alokeshwar Tiwary <[EMAIL PROTECTED]>
wrote:
> Opening Power Point is easy:
>
> Sub OpenPPT()
> Applic
if you are asking me then read my previous reply... otherwise put your
question here or directly to me
On 8/23/08, Rashid Imtiaz <[EMAIL PROTECTED]> wrote:
>
>
> Can u send me the same solution
>
> thanks
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:[EMAIL PROTE
Does anyone know how to trap a click event from the forward/back
buttons that are normally used for web browsing on newer mice? I
presume an API call would have to be used. I've written a small
routine that tracks my recent cell selections to help with debugging
and it would be very tidy to link
Hi Rishi,
The formulae in the enclosed file may help you.
Regards
Atul
-Original Message-
From: rishi [mailto:[EMAIL PROTECTED]
Sent: August 26, 2008 11:30 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Vlookup Help
Hi All,
I have a couple of problems :
1.
I
14 matches
Mail list logo
