Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Help with complex formula
I want to be able to have a cell paste to another worsheet in the workbook. I have finished the salesmans worksheets and now the I need a way for the information based on a name to find the correct worksheet and then the correct range (2 lines with a single name) based on a name in a column and then the correct line based on a comapny name in a column (the sales & PM work for 2 companies) We have 12 sales people and 4 project managers and sometimes a project manager may work some small projects for as many as 5 project managers. Most times it is 3 but not always I am making seperate worksheets for each salesman and each project manager, I also have a seperate worksheet for lists and commission rates. Please Help TJF -- TJF ------------------------------------------------------------------------ TJF's Profile: http://www.excelforum.com/member.php...o&userid=29096 View this thread: http://www.excelforum.com/showthread...hreadid=488170 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Help with complex formula
First, a function in a cell can only return a value to that cell. It
can't directly input information into another cell. Perhaps someone else will understand the situation better, but I can't get a good handle on what you're trying to accomplish. Post back with a more complete description, including range and cell references. I'm sure it makes perfect sense to you, since you've been working on it extensively, but I can envision many layouts that could fit your description.. In article , TJF wrote: I want to be able to have a cell paste to another worsheet in the workbook. I have finished the salesmans worksheets and now the I need a way for the information based on a name to find the correct worksheet and then the correct range (2 lines with a single name) based on a name in a column and then the correct line based on a comapny name in a column (the sales & PM work for 2 companies) We have 12 sales people and 4 project managers and sometimes a project manager may work some small projects for as many as 5 project managers. Most times it is 3 but not always I am making seperate worksheets for each salesman and each project manager, I also have a seperate worksheet for lists and commission rates. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Help with complex formula
Thanks for Helping. On my commission worksheet for the salesman I post in a row the sales and cost of goods, then calculate the percentage of profit and further calculate a percentage for commission, then further calculate the salemans commission portion and the project managers commission portion. In the same row I have the project managers name and the name of this worksheet is the salemans name. Now I need to find a way to get that project managers commission to his worksheet. The kicker is that it is not always the same project manager assigned to the same salesman. I would like to know of a way for Excel to check the names on the salesman worksheet then find the appropriate project managers worksheet (by name) and then place in the appropriate cell next to the name of the each salesman that the project manager has worked for. i.e Mark is the salesman John is the PM and the program would need to look at the line with the Johns name on the Marks sheet, then find Johns sheet, then find Marks name and place the amount next to that. Would or anyone know how to check a name, then find a name of a worksheet, then grab information an place on that sheet. I could even put it all in a macro and just run that once the sales worksheets are done. Thanks, TJF -- TJF ------------------------------------------------------------------------ TJF's Profile: http://www.excelforum.com/member.php...o&userid=29096 View this thread: http://www.excelforum.com/showthread...hreadid=488170 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Complex formula | Excel Discussion (Misc queries) | |||
Hide formula | Excel Worksheet Functions | |||
Complex =mid formula | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Help with Complex SUMPRODUCT formula | Excel Worksheet Functions |