Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8
Default Building a sales log

I am trying to build a weekly sales log, so I can keep track of my sales and
also be able to forecast any prospects for the upcoming week. Can anyone help
me with this? Everytime I take my info from database it wont paste into the
cells.... Help me please
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,836
Default Building a sales log

For one thing, I think you should import the data, rather than copy/paste it.
Take a look at this web site:
http://www.dmi.uiuc.edu/excelimport.pdf

Also, you didn't give a lot of information about what you are doing, but I
suspect the data list will change often, perhaps each time you do the import.
With this in mind, I think you should have a look at this web site:
http://www.ozgrid.com/Excel/DynamicRanges.htm

Example 1 and Example 2 probably pertain to your specific situation; study
these. This technique takes a little getting used to, but spend some time on
it and it will benefit you greatly in the long run.

Regards,
Ryan---




--
RyGuy


"richie" wrote:

I am trying to build a weekly sales log, so I can keep track of my sales and
also be able to forecast any prospects for the upcoming week. Can anyone help
me with this? Everytime I take my info from database it wont paste into the
cells.... Help me please

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating sales commission that changes based on a sales volume Elbowes Excel Worksheet Functions 2 June 8th 07 02:48 PM
Sales Invoicing linked to Sales ledger(Accounts Receivable) Cache Excel Discussion (Misc queries) 0 May 15th 07 03:41 PM
Add Sales Goals to Sales Report in Pivot Table Ronster Excel Discussion (Misc queries) 1 October 13th 06 04:17 AM
sales needed to cover costs that increase as sales do donna-LexusWebs Excel Worksheet Functions 5 August 29th 06 06:17 PM
How do I set up a sales forecast to predict sales per hour, when . Greg Excel Discussion (Misc queries) 4 April 17th 05 11:09 PM


All times are GMT +1. The time now is 01:34 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"