Err, excuse my apparent idiocy, but I can't see how this would form a basis for the commissions system?
If I have salesperon names in dropdown 1, what is in dropdown 2?
Err, excuse my apparent idiocy, but I can't see how this would form a basis for the commissions system?
If I have salesperon names in dropdown 1, what is in dropdown 2?
Thanks Roy, but I'm not sure I understand your idea.
Do you have an eg?
I'm not sure I understand. Where do you want the looked up data to appear?
Hello all,
I was wondering if any of you have done something clever to calculate commissions.
The situation:
I have a sales tracker that records what each salesperson in my company sells.
The salespeople are split into teams, and each team has a different commission structure. There may even be individuals within the teams who have special arrangements.
The commission % will also differ depending on the product type, as well as what % of their target they hit.
:barf:
So far the only way I can think of handling this is to have one sheet for each person, with their set of rules built in, and then I will have to copy in their list of sales manually. As there are over 60 of them, I'm feeling a bit daunted by this!!
Anyone got any brainwaves?
Thanks very much
MKNov
Well, for once I've managed to answer my own question.
It's messy, it's amateur, but it works.
In case anyone's interested:
Hi Guys,
I have this to remove hyperlinks:
Sub RemoveHyperLinks()
Range("A1:Z999").Hyperlinks.Delete
End Sub
But it also removes all my formating. Is it possible to remove the link but leave the non link related formats as they are?
Thanks
MKNov
Hi Will,
This works great.
Gotta love being lazy.
Thanks very much!!
MKNov
Hi,
I'm sure this is very simple, and it's annoying the hell out of me.
I have a sheet that uses an exchange rate. Sometimes I update the exchange rate when I open the file, sometimes I don't.
Below the exchange rate cell is a cell saying when I last updated the rate. How can I make this date cell update automatically?
I know this is supremely lazy, but it's bugging me!
Thanks
MKNov
Thanks for the reply bnix
Actually it turned out I had a reference in my code to a query that was in the wrong format to display the results.
I had mistakenly written into my code a change to the recordset format or something.
Anyway, all sorted now. Thanks!
Hi,
I have a form based on a query.
The query draws data from 4 tables.
The relationships in the query are fine.
When I run the form on its own it is fine, showing all fields.
However, I have written some code that enables a user to search this form for results fitting criteria they type into a front end form.
e.g. if they are looking for a product code that contains HC they type '*HC* in a textbox, click the search button and VBA returns matching records from the query form.
Problem is, when the formis accessed by the user via search, some of the query fields (the ones from linked tables) show as
#Name?
error.
Any ideas?
Thanks
MKNov
Hi vin_us,
Have you tried
Insert > Name > Define
then highlight the offending range in the list and click on the Delete button in that screen?
Save the file, and the link should be gone.
MKNov
Hi smcinrox,
I'm not sure why, but it's the * at the beginning of the entries in column b.
It messes with the filter
MKNov
Hi rhodie,
I did something like this a while ago, with a sheet for each salesperson and then a consolidation sheet containing all the data.
A macro linked to a command button in the consolidation sheet works by
Clearing out all the rows currently there
Opening each workbook in turn and copying and pasting the data into the consolidation sheet.
Deleting any blank rows
Entering the time and date of the last consolidation.
If this sound like the sort of thing you want, post back and I'll give an example.
MKNov
Derk - ah this is better. I had resorted to copying a calendar and using vlookup, but this will work better.
Andy - that works great too. Thanks guys!
Thanks Andy, but the date is referenced in another formula, and for reasons I can't really explain (mainly 'cos I don't get it) I need it to be a real text field.
Thanks tho'.
Just a quick one.
What is the best way to convert a date
in 01/01/2003 format to the month in text. i.e. January.
Is there a function?
Thanks
MKNov
Hi bnix,
Thanks - No I am pretty clueless about database driven sites, but it sounds like a fantastic challenge. Am off to browse the recommended site.
Thanks
MKNov
Hi,
I am totally at sea with this one. I have been tasked with creating a diary for a large sales team to use. The idea is that they all put their client appointments in them and the information is viewable by others.
I also want to be able to run metrics off it, for example number of meetings / days off sick etc per person in any given month.
I am in the process of writing up a full spec, but the problem is I don't know whether to use Excel (favoured), Access, Outlook or something web based (having it on the intranet would be great).
Anyone any ideas? Has anyone done / seen anything like this before?
Thanks
MKNov
That's done it.
Thanks Dave
MKNov
Thanks Dave,
But it doesn't seem to like me. Am I having a stupid five minutes?