Work Sheet

  • Thread starter Thread starter vijaydsk
  • Start date Start date
V

vijaydsk

I have a work sheet with more than 300 customers in rows with sales
volumes posted in
month wise for the last 3 years (Apr, May, June etc.,).

I can attach the sheet for your ready ref.

I want a comprehensive caliculation of the data on current vs
historical
(2006-07 vs 2005-06)
1. Percentage growth
2.Market Share
3.Sales in trading area.
4.Any advanced help in analysing the sales of the dealer in that
trading area.
 
so do you want to learn how to do this yourself, or are you looking
for someone who will do it for a fee?
susan
 
it's an awfully big project.
i don't know who would be available to do it for a fee.........
(if you want to hire somebody, perhaps start a new thread titled
"looking for fee-based project assistance")

you could start, yourself, by adding a worksheet as a summary sheet.
then turn on the macro recorder & do some of the tasks that would be
involved in this (such as copy & pasting, entering formulas to sum
worksheets, etc.).
that will at least give you a place to start.
also/or, search the newsgroup for "consolidating worksheets" & you may
find some ideas there.
good luck
susan
 
it's an awfully big project.
i don't know who would be available to do it for a fee.........
(if you want to hire somebody, perhaps start a new thread titled
"looking for fee-based project assistance")

you could start, yourself, by adding a worksheet as a summary sheet.
then turn on the macro recorder & do some of the tasks that would be
involved in this (such as copy & pasting, entering formulas to sum
worksheets, etc.).
that will at least give you a place to start.
also/or, search the newsgroup for "consolidating worksheets" & you may
find some ideas there.
good luck
susan





- Show quoted text -

Thank you susan. I will start this project. May be i require your help
in sorting out some problems when i working on it. Please bear with me
 

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

Back
Top