hi,
just copy the data in column A1 then take the curser in another cell , then
right click to curser , press paste special then select transpose then enter
ok
after these steps u get that data in differnt columns
regards,
swati
On Thu, Jul 16, 2009 at 6:36 PM, TAlgo trading.a...@gmail.com
Thanx dilip,
my problem is solved.
A learn a lot form u.
rgds,
Mahesh
On Fri, Jul 17, 2009 at 8:42 AM, Mahesh mahender.bi...@gmail.com wrote:
Hi Dili,
Gud Morning,
I using the same file which is already attached.
On Thu, Jul 16, 2009 at 5:42 PM, Dilip Pandey
Hi,
Try putting the following code in a module, then Run:
Sub ChangeToValue()
A = 2
Do Until Cells(A, 1) =
Cells(A, 1) = Val(Cells(A, 1))
A = A + 1
Loop
End Sub
Regards - Dave
Date: Thu, 16 Jul 2009 23:17:46 -0700
Subject: $$Excel-Macros$$ Value all the Selection
Use Hlookup instead
On 16/07/2009, Manoj Kukrej manoj...@ocimumbio.com wrote:
hI
Can we look for fist column in **1**)) vlookup(e3,r4:y4,1,0)
Regards
manoj
--
*From:* excel-macros@googlegroups.com [mailto:
excel-mac...@googlegroups.com] *On Behalf Of
Hello,
Something new for me so need some help :
I' would like to have a macro which will extract data automatically
and daily from multiple workbooks ( Source ) and copy to Master
workbook ( target ) located under same network drive.
Say around 5 pm EST macro should auto run and complete the
I would suggest recording a macro that does all of the things
you want it to do.
Call the macro auto_Open.
At the end of the macro, add:
Activeworkbook.close SaveChanges:=true
save the workbook.
Next, create a windows Scheduled task that will open this workbook at 5:00pm
daily
(or weekday)
Hello.
Use the OnTime command in your macro. This means that your workbook has to
be open and your macro running at the activation time. However, if you use
Excel 2007, you could place the master workbook in a trusted folder (that is
to say that an auto open macro can run at open without security
Hey all,
I found a very simple macro to track any changes made to any cell in a
row by datestamping the end of the row.
The issue comes in whenever i try to insert a row into the sheet, i
get an error: Runtime Error 1004, Application-defined or Object-
defined error and im not sure how to fix
Thanks ..I've never created Windows task manager..is there a link or
sample guide how to create task manager and .bat file?
On Jul 17, 2:43 pm, Daniel dcolarde...@free.fr wrote:
Hello.
Use the OnTime command in your macro. This means that your workbook has to
be open and your macro running at
Is there a way to create a custom function that will print out row
number that the function is in?
For example, in cell C5, I'll type '=whats_my_row_number()' and I
would like it to say 5.
Thank you in advance,
--~--~-~--~~~---~--~~
This modified code seems to work
Public Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
'Application.EnableEvents = False
On Error GoTo Errorhandler
Target.Offset.Offset(0, 13) = Now()
'Application.EnableEvents = True
End If
Hi,
I pasted your code into my XL2000. I don't get any error when inserting rows.
Dave.
Date: Fri, 17 Jul 2009 12:36:21 -0700
Subject: $$Excel-Macros$$ DateStamp Macro Debug Help
From: pogs...@gmail.com
To: excel-macros@googlegroups.com
Hey all,
I found a very simple macro to track
You don't need a custom function just use the built in =row()
function
You could create a custom function to determine the row of a cell
reference
Function WhatsMyRow(TheCell As Range)
WhatsMyRow = TheCell.Row
End Function
and then in any cell type =WhatsMyRow(A1) the cell will show 1
13 matches
Mail list logo