News:

You can reach your profile and change its settings here.

Main Menu

Excel users?

Started by SippinTea, March 08, 2008, 08:38:20 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Print
Go Down Pages1 2
User actions

SippinTea

March 08, 2008, 08:38:20 PM
I use Excel spreadsheets all the time, but so far have only scratched the surface of what the capabilities are. I'm currently reading portions of Excel 2002 for Dummies (how fitting! *grin*), but I've got a couple questions I haven't seen addressed yet. If any other Excel users have time to help a rather computer illiterate Oregonian, I'd appreciate it.

Problem One: I need to enter a date in one cell, and have Excel automatically enter dates in other cells based on what I type in the first cell. I'm sure this is related to a formula somehow, but since it's tied to a calender (and not just math) I haven't figured it out yet.

Problem Two: I need to transfer data from about twenty worksheets into one new spreadsheet to consolidate data from music lessons last year. Is there a simple way to do this? Or should I just plan on copying and pasting from each individual page?

:beret:
"Going somewhere means leaving somewhere. Choosing something means choosing against other things. Gaining something means losing something else. And between the old and new--the 'was' and the 'not yet'--there exists only one thing: a very frightening journey called faith."
--taken from the book Coming Up For Air

SippinTea

#1
March 09, 2008, 03:11:07 AM
Problems solved!! Thanks to the wonderful Chel and a phone call.

You're awesome, Girlie!!  :great:

:beret:
"Going somewhere means leaving somewhere. Choosing something means choosing against other things. Gaining something means losing something else. And between the old and new--the 'was' and the 'not yet'--there exists only one thing: a very frightening journey called faith."
--taken from the book Coming Up For Air

JakeLeonard

#2
March 09, 2008, 04:02:27 AM
You're using 2002? Time for an upgrade....LOL  :pound: :pound: :pound:

MelodyB

#3
March 09, 2008, 07:39:28 AM
I thought you said Chel helped you with a FF issue? LOL
Have you slapped that one dude from Indiana with a pie in the face today?
 

SippinTea

#4
March 09, 2008, 04:09:10 PM
Jake... I only said I was reading that book. The library didn't have the one I wanted, and this one is (mostly) helpful. LOL

Mel...Did my misconstrument* of fact confuse you? Yay me. :P



*Is misconstrument a word? If not.... it is now!  :updown:

:beret:
"Going somewhere means leaving somewhere. Choosing something means choosing against other things. Gaining something means losing something else. And between the old and new--the 'was' and the 'not yet'--there exists only one thing: a very frightening journey called faith."
--taken from the book Coming Up For Air

MelodyB

#5
March 09, 2008, 05:23:24 PM
No, but I know for sure you said FF, not excel, not that it matters, I was just sayin.
Have you slapped that one dude from Indiana with a pie in the face today?
 

SippinTea

#6
March 09, 2008, 11:13:29 PM
*giggle* Go read your IMs again.

I said, "YOU don't use FF". That fact had nothing to do with the subject at hand, I was merely making trouble.  :hypocrite:



Soooo... back to the subject at hand.... LOL   What book(s) would you computer geeks recommend I check out?

:beret:
"Going somewhere means leaving somewhere. Choosing something means choosing against other things. Gaining something means losing something else. And between the old and new--the 'was' and the 'not yet'--there exists only one thing: a very frightening journey called faith."
--taken from the book Coming Up For Air

sunlight

#7
March 10, 2008, 03:30:03 AM
lol. I tried to help her with an excel problem... and we got off topic a bit after that... lol.  I was trying to get her to tell me who her guest is for indy. She wouldnt tell me his name yet though, *cough* she is good at evading questions! *cough* hmm...

ohh yeah, by the way, I like Ruby's accent!
  :attackhug: Be full of hugs!

SippinTea

#8
March 10, 2008, 04:28:51 AM
Quote from: sunlight on March 10, 2008, 03:30:03 AM
ohh yeah, by the way, I like Ruby's accent!

:roll:

I don't have one. :P

:beret:
"Going somewhere means leaving somewhere. Choosing something means choosing against other things. Gaining something means losing something else. And between the old and new--the 'was' and the 'not yet'--there exists only one thing: a very frightening journey called faith."
--taken from the book Coming Up For Air

MelodyB

#9
March 10, 2008, 04:33:08 AM
Yes you do.
Have you slapped that one dude from Indiana with a pie in the face today?
 

Babs

#10
March 10, 2008, 04:34:12 AM
short people always have accents lol
Religion is worthless until it is able to move outside the walls.

My latest blog post.

sunlight

#11
March 10, 2008, 04:38:36 AM
BOL! thats great!
* sunlight hugs a short person with an accent... whoever that is... lol!
  :attackhug: Be full of hugs!

SippinTea

#12
March 10, 2008, 04:39:39 AM
*groan* It is NOT pick on Ruby day. I don't know who sent out the memo with the bad info... but I'm gonna pound 'em.

:beret:
"Going somewhere means leaving somewhere. Choosing something means choosing against other things. Gaining something means losing something else. And between the old and new--the 'was' and the 'not yet'--there exists only one thing: a very frightening journey called faith."
--taken from the book Coming Up For Air

Babs

#13
March 10, 2008, 04:41:34 AM
 :hypocrite:
Religion is worthless until it is able to move outside the walls.

My latest blog post.

MelodyB

#14
March 10, 2008, 05:17:15 AM
Yes it is...didnt you get the memo?

Barb? Chel? Yall got it didnt ya?
Have you slapped that one dude from Indiana with a pie in the face today?
 

Babs

#15
March 10, 2008, 05:17:56 AM
i got it, came from the upper management  :freaky2:
Religion is worthless until it is able to move outside the walls.

My latest blog post.

sunlight

#16
March 11, 2008, 05:06:43 AM
BOL! you bet. I hear it's actually pick on Ruby WEEK!
  :attackhug: Be full of hugs!

MelodyB

#17
March 11, 2008, 05:07:39 AM
Oh yeah! I heard that too!

Have you slapped that one dude from Indiana with a pie in the face today?
 

sunlight

#18
March 11, 2008, 05:08:14 AM
* sunlight plots...
* sunlight contemplates calling mel
  :attackhug: Be full of hugs!

MelodyB

#19
March 11, 2008, 05:08:58 AM
* MelodyB looks at her phone and waits
Have you slapped that one dude from Indiana with a pie in the face today?
 

sunlight

#20
March 11, 2008, 05:15:51 AM
* sunlight contemplates some more
  :attackhug: Be full of hugs!

SippinTea

#21
March 11, 2008, 05:36:08 AM
*Ruby contemplates deleting her acct off GP*  :girltongue:

:beret:
"Going somewhere means leaving somewhere. Choosing something means choosing against other things. Gaining something means losing something else. And between the old and new--the 'was' and the 'not yet'--there exists only one thing: a very frightening journey called faith."
--taken from the book Coming Up For Air

MelodyB

#22
March 11, 2008, 05:37:06 AM
:o

Have you slapped that one dude from Indiana with a pie in the face today?
 

sunlight

#23
March 11, 2008, 05:37:38 AM
i still have your numer and im and stuff... REG
  :attackhug: Be full of hugs!

MelodyB

#24
March 11, 2008, 05:38:44 AM
Did you actually save her number Chel? Cause you are bad about that... :P
Have you slapped that one dude from Indiana with a pie in the face today?
 
Print
Go Up Pages1 2
User actions