Insert Information in a different worksheet

M

Matt

Hi Everyone,
I am creating a worksheet that keeps track of each member and how many
minutes they workout at the gym for each day. I have a cover sheet that pulls
information from the information sheet using vlookup functions based on the
identification number entered. I also am using the Now function for the date.
On the information sheet I have given each member an identification number -
each member has their own row. Then the columns have the each day for the
next six months.
I would like to be able to input the identification number on the cover
page, then insert the number of minutes they worked out in a seperate cell
and have that number automatically entered where the date and identification
number intersect on the information worksheet and have that number to stay
there permanently.
Is this possible? I have looked online for a while now and I cannot figure
it out.
Thank you
Matt
 
J

Jim Rech

The reason you haven't gotten a response for some 8 hours is that there is
no built-in feature in Excel to do what you want. So you'd have to use a
macro.

--
Jim
| Hi Everyone,
| I am creating a worksheet that keeps track of each member and how many
| minutes they workout at the gym for each day. I have a cover sheet that
pulls
| information from the information sheet using vlookup functions based on
the
| identification number entered. I also am using the Now function for the
date.
| On the information sheet I have given each member an identification
number -
| each member has their own row. Then the columns have the each day for the
| next six months.
| I would like to be able to input the identification number on the cover
| page, then insert the number of minutes they worked out in a seperate cell
| and have that number automatically entered where the date and
identification
| number intersect on the information worksheet and have that number to stay
| there permanently.
| Is this possible? I have looked online for a while now and I cannot figure
| it out.
| Thank you
| Matt
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

all sheets need the same first 6 columns - user friendly presentat 1
Finding data within a worksheet made up of links 7
Converting a negative number to a positive number 3
Lookup on worksheet 1
Query: Link data between worksheets? 8
Excel Monthly Spread sheet. 12
document information from folder 1
Need Macro- Insert rows based on dates and copy info from that row 1

Top