Previous in Forum: Trojan SPM/LX Infection   Next in Forum: What's the Best Way to Learn C?
Close

Comments Format:






Change Mode
Close

Subscribe to Discussion:

CR4 allows you to "subscribe" to a discussion
so that you can be notified of new comments to
the discussion via email.

Close

Rating Vote:







Add Vote
7 comments
Rate Comments: Nested
Labyguy
Guru
Engineering Fields - Manufacturing Engineering - New Member Hobbies - Target Shooting - New Member United States - Member - New Member Hobbies - Hunting - New Member

Join Date: Dec 2006
Location: Charlotte, NC USA
Posts: 791
Good Answers: 17

Help with Excel

10/09/2009 9:56 AM

Hi Everybody,

Here my problem. I'm using excel as a log book for the shop floor. We are using it to track parts run per shift. In the spreadsheet, we are logging the cutter number, which needs to be sent out and re-coated every now and again. The idea is for us the catch the cutter when it gets dull before we start making bad parts. So I have excel set up to track parts by cutter number.

I would like to set this up so that the current cutter being used is displayed in the header. Does anyone know how to get excel to track the last entry in a column, regardless of where the end is. (remember the end of the column will change at the end of every shift and I'll have to extract that last entry every time without editing the the spreadsheet.)

thanks in advance.

Laby

__________________
 Be careful of what you wish for .....
Register to Reply
Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.

Good Answers:

These comments received enough positive votes to make them "good answers".
2
Anonymous Poster
#1

Re: Help with Excel

10/10/2009 2:39 AM

Hi Laby, thats quite simple.

Assuming your data is all in COLOUMN A of a spreadsheet as follows

CELL A1 - Cutter No.X

CELL A2 - CUTTER No.Y

CELL A3 - CUTTER No.Z

CELL A4 - CUTTER No.XX

You now wish to get the last entered CUTTER No. (in this case No.XX in CELL A4) to be displayed in CELL B4 (i.e. on top of the workbook), all you need is to do this formula in CELL B4 - =INDEX(A1:A1000,COUNTA(A1:A1000))

This will track all values that you add to coloum A until the row number 1000 i,e A1000. If you have a database that runs more than 1000rows just expand that range in the formula and each new addition of CUTTER Number at the end of the database will be reflected in CELL B4 (dynamically).

Regards

Baiju
Register to Reply Good Answer (Score 2)
No more Good Answers.
Labyguy
Guru
Engineering Fields - Manufacturing Engineering - New Member Hobbies - Target Shooting - New Member United States - Member - New Member Hobbies - Hunting - New Member

Join Date: Dec 2006
Location: Charlotte, NC USA
Posts: 791
Good Answers: 17
#3
In reply to #1

Re: Help with Excel

10/12/2009 8:07 AM

Thanks, that worked GREAT !! CR4 did me proud again !!!

__________________
 Be careful of what you wish for .....
Register to Reply
tanpreet
Participant

Join Date: Dec 2008
Posts: 4
#2

Re: Help with Excel

10/10/2009 11:19 AM

Hi Labyguy,

Are you willing to use macros? I can tell you a very sweet and simple method to do this task. If you mail me a sample excel book (if you don't want to share your log book) then I can implement it and send it back to you. Let me know if you are ok with macros.

You can mail me at tanpreet@gmail.com.

Regards,

Tanpreet
Register to Reply
Labyguy
Guru
Engineering Fields - Manufacturing Engineering - New Member Hobbies - Target Shooting - New Member United States - Member - New Member Hobbies - Hunting - New Member

Join Date: Dec 2006
Location: Charlotte, NC USA
Posts: 791
Good Answers: 17
#4
In reply to #2

Re: Help with Excel

10/28/2009 8:04 AM

Tanpreet,

It's working great now, what would the macro do for me?

laby

__________________
 Be careful of what you wish for .....
Register to Reply
tanpreet
Participant

Join Date: Dec 2008
Posts: 4
#5
In reply to #4

Re: Help with Excel

10/28/2009 9:50 AM

One obvious advantage with Macro as compared to the solution mentioned above is that you wouldn't have to change the formula once your number of rows exceed 1000. Let's do one thing, give me your email and I shall mail you an example which will show you what I want to explain. Cheers, Tanpreet
Register to Reply
Labyguy
Guru
Engineering Fields - Manufacturing Engineering - New Member Hobbies - Target Shooting - New Member United States - Member - New Member Hobbies - Hunting - New Member

Join Date: Dec 2006
Location: Charlotte, NC USA
Posts: 791
Good Answers: 17
#6

Re: Help with Excel

11/21/2009 2:27 PM

Yes, Thank you

__________________
 Be careful of what you wish for .....
Register to Reply
Kris
Guru

Join Date: Mar 2007
Location: Etherville
Posts: 12362
Good Answers: 115
#7
In reply to #6

Re: Help with Excel

11/21/2009 4:04 PM

You're most welcome. I learned something myself in finding that out - it's nice when we can all learn from a question

__________________
 For sale - Signature space. Apply on self addressed postcard..
Register to Reply
Register to Reply
Have a Different Question?
7 comments

Good Answers:

These comments received enough positive votes to make them "good answers".
Copy to Clipboard

Users who posted comments:

Anonymous Poster (1); Kris (1); Labyguy (3); tanpreet (2)

Previous in Forum: Trojan SPM/LX Infection   Next in Forum: What's the Best Way to Learn C?
You might be interested in: Parts Feeders

Advertisement

Got Something to Say?
Ask a Question
Start a Discussion

Search this Forum
Software & Programming:
Go

CR4 Sections
Aerospace
BioMech & BioMed
Chemical & Material Science
Civil Engineering
Communications & Electronics
Education and Engineering Careers
Electrical Engineering
General Discussion
Instrumentation
Manufacturing
Mechanical Engineering
New Technologies & Research
Software & Programming
Sustainable Engineering
Transportation

Site Directories
Forum Directory
Blog Directory
User Group Directory
RSS Feeds

CR4 Rules of Conduct
CR4 FAQ
Site Glossary

Who's Online (58 right now)
Show Members
Advertisement