Thanks !
On Fri, Apr 17, 2009 at 6:46 PM, Frans2134 wrote:
>
> Shelly,
>
> You could try the following
>
> use the formule:
>
> =VLOOKUP($B20,INDIRECT(Filename&"Pivot-ST'!$B$5:$I$398",8,0)
>
> create a cel named "Filename" and put in here the the name of the
> workbook.
> ''[ABC ltd billing d
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
--~--~-~--~~~---~--~~
-
Hey Paul,
I am using Microsoft Outlook.
The source for the e-mail is an Excel worksheet (not standard) from
the people I receive the figures from (35 in total). This e-mails I
have to process further in an Excel worksheet.
With the logging I mean that within the spreadsheet and in Outlook (to
co
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: excel-macros@googlegro
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,
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 wrote:
> Hello,
>
> I want to import a numerical value into text field everytime i open the
> excel sheet.Kindly pls explain indetail.I dont kknow
Hello! I am new to this group, and new to VBA in general, so I would
appreciate any insight / explanations into this =)
Here is the situation:
There will be raw data in the form of a spreadsheet which is in
chronological order, though not in steps of 1. So for instance, Column
A could be numbere
Hi Ujjwal,
I think I have a solution for your problem.
But how can I attach files???
Regards,
Sergio
On 19 Apr., 11:38, Ujjwal Jha wrote:
> Attached is the file on which macro was created and used.
>
>
>
>
>
> On Sun, Apr 19, 2009 at 2:52 PM, Ujjwal Jha wrote:
> > Please find below the macro
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
--~--~-~--~~~---~--~~
--
Hi,
Running a pool, and trying to create a macro to sort the results
automatically. Have a colunm with names and beside a colunm with
point totals (sum of three fields). Created a button that will sort
the results in order, based on points from highest to lowest.
any ideas??
Thanks
m
--~--~
On Apr 17, 12:41 pm, steviewood 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 Resul
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 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 <26may.1...@gmail.com>wrote
lastrow = Range("a1").End(xlDown).Row
try this one as well
On Sat, Apr 18, 2009 at 10:37 PM, Tom Jeffries wrote:
> Try:
> LastRow = ActiveSheet.Cells.Find(What:="*", SearchDirection:=xlPrevious,
> SearchOrder:=xlByRows).Row
>
> On Fri, Apr 17, 2009 at 8:01 PM, boney wrote:
>
>>
>> I have two s
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 hand>Crit value"
Order_Amt = Desire_
This example sorts the range A1:C20 on Sheet1, using cell A1 as the first
sort key and cell B1 as the second sort key. The sort is done in ascending
order by row, and there are no headers. This example assumes there is data
in the range A1:C20.
Sub SortRange1() Worksheets("Sheet1").Range("A1:C20
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 wrote:
>
> Please find the attached file. Maybe helpful for you.
>
> I
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 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 10 columns like
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
> T
Hi ,
U can use this code in your module
Sub Test()
Dim strTest As String
Range("A6").Select
While ActiveCell.Value <> ""
If ActiveCell.Offset(1, 0).Value <> "" Then
strTest = strTest & ActiveCell.Value & ";"
Else
strTest = strTest & ActiveCell.Value
End If
Activ
The form is from a secure page & would have some fields as dropdown.
Main reason for this requirment is to fill the form very quickly
On 4/20/09, Abhishek Jain wrote:
> Hi Friends
>
> I have a simple worksheet having data as below -
>
> A B C D
Hi,
Check attached file
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Putta Madaiah
Sent: 20 April 2009 05:33 pm
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ All the names copied to one Cell seperated b
23 matches
Mail list logo