Bob,
link information from the "Data Entry" into a corresponding row
Sound like you have a direct link between sheets?
e.g. A1 in the Data Entry sheet has a formula like
Wage Summary!A1
There are many things that you can do (you did want ideas?)
A VLookup is the first thing that comes to mind.
As you enter names in the Wage Summary, the lookup would get
the corresponding data from the Data Entry sheet based on the name.
(SSN number would be a better lookup though).
For some help on lookups, try he
http://www.mvps.org/dmcritchie/excel/vlookup.htm
You could also AutoFilter the Wage Summary sheet and select Non Blank
cells as the filter. Look at AutoFilter and Advanced Filter on this site:
http://www.contextures.com/tiptech.html
If you wanted to go the VBA route, there's even more possibilities.
Without knowing how your sheets are set up, it's difficult to offer
any specific advice.
John
"Bob Reynolds" wrote in message
...
I am trying to make a form in excel 2002 that has the following
characteristics.
I enter data on one worksheet "Data Entry" consisting of name, address,
ssn,
address, monies owed, interest and total wages owed. The data entered can
be
for one person or 300 plus people. All data is confined to one row per
person.
I have a final version of this "Wage Summary" located on another tab in
the
workbook and link information from the "Data Entry" into a corresponding
row
in the "Wage Summary".
My problem is if I only have two or three, I don't want to print 300 blank
rows on the "Wage Summary" sheet. Right now I have different "Wage
Summary"
sheets linking 15, 30, 45, 60 and 96 persons and I am required to select
the
appropriate worksheet for them to fit.
I need to have one "Wage Summary" that will show either the one or two
persons owed wages or the 100 people or whatever amount of persons I have,
using only one final worksheet to print (Wage Summary) Is there some type
of
programming that will look up and use only the data that is found and size
the final product accordingly?
Can someone give me some guidance with this. My skills are medium in
excel.
Thank you
Bob Reynolds