August 29, 2008, 12:52:53 AM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length

There are currently 0" users in chat
News: Have you registered yet? If not then you might want to do so as we continue to explore the benefits of registration such as adding games and other sections of the forum.
 
 
  Website   Home   Help Search Affiliate Chat Calendar Members Tags Links Gallery Media Center Login Register  
Gł Solutions Network
In short, the goal of Gł Solutions is in the title. We attempt to define technology in easily understood terms.
From the end-user to the entrenched and battle scarred professional - we all have questions. And answers.
We attempt to answer these questions - in a round-about fashion - as this: "How can technology help?"
MAIN SITE BLOG Main Site Search HOSTING PRIVACY CONTACT ABOUT



Digg This!
Subject Statistics
Topic: Excel Spreadsheet Help Replies: 3 posts
Read 608 times 0 Members and 2 Guests are viewing this topic.
Pages: [1]   Go Down
  Reply  |  New Topic  |  Send this topic  |  Print  
Author Topic: Excel Spreadsheet Help  (Read 608 times)
 
0 Members and 2 Guests are viewing this topic.
runswithscissors
Helpers
Dedicated Poster
********

Karma: +3/-0
Offline Offline

Mood:

Gender: Female
Posts: 1061


Libra  

Topic starter
Insert Wit Here


View Profile
« on: January 21, 2007, 10:35:40 PM »

Ah, it was a weird week last week, and I actually wasn't at my desk that often.

You know what I need help with? Making an inventory spreadsheet for merchandise that I am in charge of. I need to know what we have in stock, what goes out, and when it was sent. I also put the name of the person who ordered it. The price isn't important, what I'm trying to see instantly is how much we have left and what we've sent out each week.

Make sense?
« Last Edit: January 22, 2007, 05:56:41 PM by runswithscissors » Report to moderator   Logged
Gł Solutions - Technology Defined
« on: January 21, 2007, 10:35:40 PM »
Reply with quoteQuote


 Logged
4fit?
Full Member
***

Karma: +2/-0
Offline Offline

Mood:

Gender: Male
Posts: 36


Gemini   White Dog - Loves HeartElectric

That guy.......4fit?


View Profile WWW
« Reply #1 on: January 22, 2007, 04:15:54 PM »

Ah, it was a weird week last week, and I actually wasn't at my desk that often.

You know what I need help with? Making an inventory spreadsheet for merchandise that I am in charge of. I need to know what we have in stock, what goes out, and when it was sent. I also put the name of the person who ordered it. The price isn't important, what I'm trying to see instantly is how much we have left and what we've sent out each week.

Make sense?
Can you make up a bogus sampling of what data would be in the sheet?  Sounds like a simple pivot table might do most of what you are needing.
Report to moderator   Logged

Mustangs Of Burlington Admin

Specialize in MS Office Automation
KGIII
Official Code Wrecker
Administrator
Dedicated Poster
********

Karma: +15/-2
Offline Offline

Mood:

Gender: Male
OS: Vista, XP, Ubuntu
CPU: 2x AMD64 4800+
RAM: 3 GB
HDD: 500 GB (Raid0)
Posts: 11274


 

Yes, yes I can.


View Profile WWW
« Reply #2 on: January 22, 2007, 04:28:55 PM »

Topic split.
Report to moderator   Logged
runswithscissors
Helpers
Dedicated Poster
********

Karma: +3/-0
Offline Offline

Mood:

Gender: Female
Posts: 1061


Libra  

Topic starter
Insert Wit Here


View Profile
« Reply #3 on: January 22, 2007, 05:58:18 PM »

Yes... I could probably post a sample of what I actually have... but I'm at home now ,and not at work. LOL!

Will do so tomorrow. Thanks!
Report to moderator   Logged
Tags:
Pages: [1]   Go Up
  Reply  |  New Topic  |  Send this topic  |  Print  
 
Jump to:  

+ Quick Reply
With a Quick-Reply you can use bulletin board code and smileys as you would in a normal post, but much more conveniently.

Reminder:
Why not introduce yourself or register?
Powered by SMF 1.1.4 | SMF © 2006-2008, Simple Machines LLC | Sitemap
This page was magically conjured in about 0.111 seconds with 38 spell components. No animals were harmed in the making of this page.

Google visited last this page Today at 12:49:39 AM