Sales Comparison Template

Replies to This Discussion

Permalink Reply by rashmi on May 24, 2010 at 3:40am

Hi....good work..can you plz tell me how to make this type of excel.

• ▶ Reply

Permalink Reply by danyal mansoor on May 24, 2010 at 1:55pm

i cant understand wat r u asking?this type of excel mean i ve already mentioned everything on the work book.

• ▶ Reply

Permalink Reply by Vincent on June 8, 2010 at 6:47am

Hi

Très intéressant, on pourrait aussi utiliser la validation des données pour changer les entreprises dans chaque cellule et introduire la fonction RechercheV pour associer les ventes relatives aux entreprises sélectionnés.

Very interesting, we could also use the validation of the data to have all choice of company in one cell. After that, introduce the RechercheV function to associate the relative sales to selected company.

Vincent

Attachments:

• COMPARISON SALES v2.xls, 33 KB

• ▶ Reply

Permalink Reply by danyal mansoor on June 8, 2010 at 12:12pm

yep u r rite we can use it but wat i think scroll bar is easy way to move in scroll bar u dont ve to go cell all the time and chk but ur solution is gud too.

• ▶ Reply

Permalink Reply by Vincent on June 8, 2010 at 1:14pm

While passing, how do you make this scroll bar?

PS : Sorry, if you see inconvenience in my post. I'm french-speaking.

Kindly regards

Vincent

• ▶ Reply

Permalink Reply by danyal mansoor on June 8, 2010 at 3:02pm

sir no inconvenience in ur post sir, i m just giving my point wat i feel easy to use.

r u asking me how to make scroll bar i m not getting u.

if u r asking me then here is the answer just go in developer and then in insert n then u ll see some buttons in it spin button combo button and other buttons so from there u can make scroll bar.

if u dont know who to bring developer toll in ur ribbon then here is the solution of it 2

just go on office button in excel 2007 at the left corner of excel sheet n open it n then click on excel option n then go in popular and tick developer tool.if still there is some problem let me know

thanx

danial pakistan

• ▶ Reply

Permalink Reply by Vincent on June 9, 2010 at 10:09am

The scroll bar is not difficult to insert for me, but the way to move company when you click on arrow.

That is my problem

With all respect

Vincent

• ▶ Reply

Permalink Reply by nguyen ngoc tan on June 21, 2010 at 2:44am

from the bottom of my heart, thank you so much for ur useffull tool!

• ▶ Reply

Permalink Reply by Jamal on June 21, 2010 at 3:56am

This is good, appreciate your working.


Jamal

• ▶ Reply

Permalink Reply by danyal mansoor on June 21, 2010 at 7:23am

thanx u all i ve shared one other template of bullet and thermometer chart hope u ll like this too.

• ▶ Reply

Permalink Reply by Roger Emerson on June 21, 2010 at 9:35am

I appreciate the download, but I am not sure if I will be able to use it . I don't have Excel program on my computer.

• ▶ Reply

Permalink Reply by MUHAMMAD AZIM on June 21, 2010 at 2:36pm

Good initiative sharing knowledge with others, I appreciate it, Regards, Azim

• ▶ Reply

• ‹ Previous
• 1
• 2
• Next ›
• Page