Entering data in Excel

[michfan]

OK, I'm not an excel expert but I'd like to know if I can do something in excel by setting up a macro?

I need to enter 17 different variables that make up the dimensions of a certain type of steel plate.

I have these fields set up at the top of an excel spreadsheet.

After entering the first set, I'd like to be able to take that data set and move it to a row further down in the spreadsheet and call it "1".

Then I'd like to enter the 17 numbers again and run the macro and move them to row "2", etc.

Basically, I want to fill a spreadsheet in this way, but I want to make it easy on the person who will use it by grouping everything in a small table at the top of the page.

I could ask my brother (he IS an excel wizard...) but then he'd be so smug and condescending for at least a week...

 

[PHV]

I want to make it easy on the person who will use it
Why not using an UserForm ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[michfan]

I'd rather keep the data rows of the spreadsheet as they are, and have no experience setting up forms. I just want to take what's at the top of the sheet and move it to successive rows at the bottom, creating a new row each time data is entered.

 

[SkipVought]

Hi,

Since you are beginning a new application, here are some general suggestions.

A TABLE of data in Excel, ideally has the following characteristics.

1. It is the ONLY data on the sheet

2. Row on has a unique heading value in each column of data

3. It is CONTIGUOUS

4. One or more columns, preferably the left-most one(s), are the key values that can be used for identifying subsets of data.

If one were completely rigerous, one might normalize the data and deconstruct it into more than on table that could later be joined together using a database query, but most of Excel's data analysis and reporting tools, work better with a single source data table.

Having a row above the table is not at all a desireable data structure for a good functional table. Take a look at Data/Form for adding new rows and finding rows. It's kinda klunky, but it does a job.

Generally the more tht you get in the way of the user and the sheet, the more problems you will have with users.

What's wrong with entering data in the next empty row?

Skip,

_[red][/red]

 

[michfan]

That was what I want to happen...every time I enter all the variables at the top, I want them to transfer to a new row below the entry area. The last place I worked had a spreadsheet that did that using a macro but I wasn't smart enough to keep a copy of it.

Anyway, maybe I need "Excel for Dummies"...

I would be the only person using this, so I'm working on it for my own benefit, but I figure if I left the company I'd try to make it fool-proof so that the other people here could use it, too.

My brother is an excel genius, I think I need him to work on it with me. I don't think I have the mental capacity at this point!
Thanks for your help!

 

[SkipVought]

Hi,

Take a look at the Data/Form feature on the sheet.

Skip,

_[red][/red]