Interesting... really cool too..
Is this Excel file one that you use all the time?
or is it new each time?
all on the same sheet? or new sheets?
How much do you know about programming in Excel VBA?
I'm rather than wait for 3-4 emails, I'm going to "assume" that
you don't know VBA... you'll have to learn a little along the way.
I'm also going to assume you're using Excel97/2003 (pre 2007)
or if you are using 2007, you've got the Developer menu enabled.
My first approach would be to create a "change event" in Excel
Let's say that your fifth measurement is placed in column "E"
In Excel, right-click on the sheet name and select "View Code"
In the upper section (above the text area) use the pull-down
for the left-hand box to select "Worksheet".
The default "event" is SelectionChange, and the macro is created.
In the right-hand box, use the pull-down to select the "Change" event.
It will create the sub:
Private Sub Worksheet_Change(ByVal Target As Range)
End Sub
(you can delete the one:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
End Sub
)
this macro waits for any changes TO THIS SHEET.
the cells changed are passed to the macro as the variable "Target"
Now, copy/paste this line between the Sub/End Sub lines:
If (Target.Column = 5) Then Cells(Target.Row + 1, 1).Select
You now have:
Private Sub Worksheet_Change(ByVal Target As Range)
If (Target.Column = 5) Then Cells(Target.Row + 1, 1).Select
End Sub
this tests to see if the cell changed is in column 5 ("E")
If it is, then it selects the cell in the next row (target.row+1)
and the first column (,1)
If you want this to work for ALL sheets in a workbook,
we can place a similar macro in another VBA module location.
the name changes, and there is some other changes that you'll need.
let me know what you think, what your situation is, and if you need more help.
Paul
________________________________
From: lucahk <luc...@gmail.com>
To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com>
Sent: Wednesday, April 22, 2009 3:44:14 AM
Subject: $$Excel-Macros$$ Go to new row after column X
Dear all,
I have a problem I would like if some of you could please help me
solve.
I use a digital caliper to measure some parts and check their quality.
Each part I take several measures (diameters, height, thickness,...);
let say one object needs to be measured in 5 different points.
I have an excel table, where each column represents a measure. When I
press the data button on the caliper, the measure is entered in the
excel cell, and the selection moves to next right cell.
What I need is the cursor to go to a new row, at the first left cell,
once I have taken the 5th measurement, so that I can start over with
taking measures of a new piece, and so on.
Thanks in advance to anyone who can gie me an hand with this issue!
Thanks!
Luca.
--~--~---------~--~----~------------~-------~--~----~
-------------------------------------------------------------------------------------
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-------------------------------------------------------------------------------------
-~----------~----~----~----~------~----~------~--~---
