Thanks !
On Fri, Apr 17, 2009 at 6:46 PM, Frans2134 frans.elsendo...@gmail.comwrote:
Shelly,
You could try the following
use the formule:
=VLOOKUP($B20,INDIRECT(FilenamePivot-ST'!$B$5:$I$398,8,0)
create a cel named Filename and put in here the the name of the
workbook.
''[ABC ltd
Hi All
I want the names under the column Code1 to be copied to one cell seperated
by semicolon (;), please let me know if I can do it using any formula.
Please check the attached sheet.
With Regards,
Putta Madaiah
Bangalore
--~--~-~--~~~---~--~~
Hi,
Why not use PivotTables? That would be the most natural way. However, there
are more than one ways to do it, a macro and/or UDF or even formulae.
Pivots: make Party Name, Order No. as Row Fields. And Average Of W. Days as
data field.
Regards
Ajit
From:
Thank for the replies.
On Apr 19, 7:52 am, Ashish Jain 26may.1...@gmail.com wrote:
TRY THIS:
Select Case Crit_Value
Case 0
Cells(25, 1).Value = No Order
Case Is 0
Cells(25, 1).Value = Error Crit_value 0
Case Is Init_Inven
Cells(25, 1).Value = No
import a numerical value from a text pad into a excel sheet everytime i open
the excel sheet
thanks
On Mon, Apr 20, 2009 at 7:16 PM, NIRAJ KOTHARI nirajskoth...@gmail.comwrote:
Hello,
I want to import a numerical value into text field everytime i open the
excel sheet.Kindly pls explain
Hello,
I want to import a numerical value into text field everytime i open the
excel sheet.Kindly pls explain indetail.I dont kknow how to use macro .
Thanks
Niraj
--~--~-~--~~~---~--~~
On Apr 17, 12:41 pm, steviewood steven.w...@ctcplc.com wrote:
Hello,
I have managed to code some of this but would really appreciate some
help with the final part.
I have a worksheet doubling up as a questionnaire, structured as
shown...
0 1 2
This could should work
Sub insert()
i = 1
Do
If Range(A i).Value = Then Exit Do
If Range(A i + 1).Value - Range(A i).Value 1 Then
m = Range(A i + 1).Value - Range(A i).Value
Range(A i + 1).Select
l = i + 1
For k = 1 To m - 1
Range(A l).Select
See attached file.
On Sun, Apr 19, 2009 at 10:09 PM, Mayank Patel mkpat...@gmail.com wrote:
Thanks Ashish
is there any other way than Macro
I appreciate ur help.
Regards
Mayank Patel
ITC LTD
9822978041
9422749110
On Sun, Apr 19, 2009 at 9:08 PM, Ashish Jain
lastrow = Range(a1).End(xlDown).Row
try this one as well
On Sat, Apr 18, 2009 at 10:37 PM, Tom Jeffries tjeff...@gmail.com wrote:
Try:
LastRow = ActiveSheet.Cells.Find(What:=*, SearchDirection:=xlPrevious,
SearchOrder:=xlByRows).Row
On Fri, Apr 17, 2009 at 8:01 PM, boney shwet...@gmail.com
try the below code
Sub dsf()
Select Case Crit_Value
Case Crit_Value = 0
Cells(25, 1).Value = No Order
Case Crit_Value 0
Cells(25, 1).Value = Error Crit_value 0
Case Crit_Value Init_Inven
Cells(25, 1).Value = No order inventory on handCrit value
Order_Amt = Desire_Inven -
Hi,
Could you please provide the password for the macro written in the attached
file.
It seems very useful and I need to do some modification according to my
requirement.
Thanks Regards,
Prem
On 4/8/09, Mudassar Ramzan johnplaye...@gmail.com wrote:
Please find the attached file. Maybe
Hi all,
I am new to excel vba, but need help with a project i have that is due
tomorrow.
This is my question ... i have a spreadsheet with 10 columns like
this..
Id col1 col2 col3 . col6 col7 col8col9
col10
1a a a
2b b b
3c c c
Hi Can you attach the excel file.. that makes it easy to understand..
Regards,
Andy
On Tue, Apr 21, 2009 at 7:35 AM, goog amadugu...@gmail.com wrote:
Hi all,
I am new to excel vba, but need help with a project i have that is due
tomorrow.
This is my question ... i have a spreadsheet with
Hi goog,
Attach a sample workbook with 20 or so lines of data, with manually entered
results of what you want. We should be able to help you.
Regards - Dave.
Date: Mon, 20 Apr 2009 17:35:46 -0700
Subject: $$Excel-Macros$$ Need Help with autofill please !!!
From: amadugu...@gmail.com
To:
15 matches
Mail list logo