467,169 Members | 1,065 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,169 developers. It's quick & easy.

New to Excel

Hi guys,

I'm fairly fluent in MS Access but I've been handed a task that is
baffling me. I've been asked to produce a report(s) in Excel that has
a series of sales by territory. I have a bunch of raw data in a
spreadsheet that has several items including Name, Address, State,
ZIP, Territory, ItemCode, SaleDate, Quantity and Price. From this
data, I would like to create a macro or something that would take the
data for a given territory and "dump" it into a workbook to track
sales performance over the past 6 months.

Apart from the most simple use, I've never used Excel in this way and
I'm currently pulling my hair out so I'd be so grateful if anyone
could help or point me in the right direction.

Many thanks, Dean...
Jun 27 '08 #1
  • viewed: 858
Share:
4 Replies
Dean,

Do you know what programming is, you are in the complete wrong newsgroup for
your question.

Have a look at excel programming.

Cor

"DeanL" <de*************@yahoo.comschreef in bericht
news:0a**********************************@t12g2000 prg.googlegroups.com...
Hi guys,

I'm fairly fluent in MS Access but I've been handed a task that is
baffling me. I've been asked to produce a report(s) in Excel that has
a series of sales by territory. I have a bunch of raw data in a
spreadsheet that has several items including Name, Address, State,
ZIP, Territory, ItemCode, SaleDate, Quantity and Price. From this
data, I would like to create a macro or something that would take the
data for a given territory and "dump" it into a workbook to track
sales performance over the past 6 months.

Apart from the most simple use, I've never used Excel in this way and
I'm currently pulling my hair out so I'd be so grateful if anyone
could help or point me in the right direction.

Many thanks, Dean...
Jun 27 '08 #2
Try your question here

microsoft.public.excel

"DeanL" <de*************@yahoo.comwrote in message
news:0a**********************************@t12g2000 prg.googlegroups.com...
Hi guys,

I'm fairly fluent in MS Access but I've been handed a task that is
baffling me. I've been asked to produce a report(s) in Excel that has
a series of sales by territory. I have a bunch of raw data in a
spreadsheet that has several items including Name, Address, State,
ZIP, Territory, ItemCode, SaleDate, Quantity and Price. From this
data, I would like to create a macro or something that would take the
data for a given territory and "dump" it into a workbook to track
sales performance over the past 6 months.

Apart from the most simple use, I've never used Excel in this way and
I'm currently pulling my hair out so I'd be so grateful if anyone
could help or point me in the right direction.

Many thanks, Dean...
Jun 27 '08 #3
"DeanL" <de*************@yahoo.comwrote in message
news:0a**********************************@t12g2000 prg.googlegroups.com...
Hi guys,

I'm fairly fluent in MS Access but I've been handed a task that is
baffling me. I've been asked to produce a report(s) in Excel that has
a series of sales by territory. I have a bunch of raw data in a
spreadsheet that has several items including Name, Address, State,
ZIP, Territory, ItemCode, SaleDate, Quantity and Price. From this
data, I would like to create a macro or something that would take the
data for a given territory and "dump" it into a workbook to track
sales performance over the past 6 months.

Apart from the most simple use, I've never used Excel in this way and
I'm currently pulling my hair out so I'd be so grateful if anyone
could help or point me in the right direction.

Many thanks, Dean...
Explain to them that excel is the worst possible way to do this. Data should
be in a database and a report should be written to format the data in the
way they require.

Michael
Jun 27 '08 #4

Dean,

Wrong forum ... but:

- if you have all the raw data, simply put the raw data into an excel file.
- teach your users how to use PIVOT tables.
- this will give them ALL the reporting / analysis they will need!

Now when sending the data to EXCEL, you may want to derive some fields
FOr example, you have DATE ... you will want to supply to excel ...
- Year Column
- Month Column
- Week Column
- Quarter Column
Basically, any period grouping the user wants, you will need to supply a
column.

I have done this for costing monitoring ... it is very simple:

For service based ... using ole,
- create an excel file.
- write the data to excel
- build a few 'predefined' pivot tables and graphs
- save the excel file
- email it to the designated employees

For on demand...
- as above, but have it 'push button' process from within the application.

Jeff.

"DeanL" <de*************@yahoo.comwrote in message
news:0a**********************************@t12g2000 prg.googlegroups.com...
Hi guys,

I'm fairly fluent in MS Access but I've been handed a task that is
baffling me. I've been asked to produce a report(s) in Excel that has
a series of sales by territory. I have a bunch of raw data in a
spreadsheet that has several items including Name, Address, State,
ZIP, Territory, ItemCode, SaleDate, Quantity and Price. From this
data, I would like to create a macro or something that would take the
data for a given territory and "dump" it into a workbook to track
sales performance over the past 6 months.

Apart from the most simple use, I've never used Excel in this way and
I'm currently pulling my hair out so I'd be so grateful if anyone
could help or point me in the right direction.

Many thanks, Dean...

Jun 27 '08 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

13 posts views Thread by Allison Bailey | last post: by
6 posts views Thread by Matthew Wieder | last post: by
14 posts views Thread by pmud | last post: by
22 posts views Thread by Howard Kaikow | last post: by
7 posts views Thread by Alain \Mbuna\ | last post: by
16 posts views Thread by alexia.bee@gmail.com | last post: by
9 posts views Thread by Doug Glancy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.