Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function? Moving the same info from one worksheet to another.
I have a worksheet that tracks sales (date, type of lead, lead owner,
customer name, number, information, and sold or not) and I have worksheets for each sales person with their closing ratios as well as a count of how many leads ect. I am trying to make it so that I can enter the information into the first worksheet (with all the sales people) and have it appear in their own sheet as well. Is there anyway that I can move all the information by row, simply by entering a sales persons initials in the second column?? Any help is greatly appriecated!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function? Moving the same info from one worksheet to another.
Personally, I prefer to have only the one main Database sheet with all the
info on it. Then, groups of data can be AutoFiltered off it and set to a different sheet for each occasion.....this I usually do with a macro push-button.....for instance, I have one program with a MainMenu sheet, a database sheet, and a "report" sheet. The main menu has 8 buttons on it which each fire different macros, and each will put a different Autofiltered "report" on the "Report" sheet.......... hth Vaya con Dios, Chuck, CABGx3 "Naomi" wrote: I have a worksheet that tracks sales (date, type of lead, lead owner, customer name, number, information, and sold or not) and I have worksheets for each sales person with their closing ratios as well as a count of how many leads ect. I am trying to make it so that I can enter the information into the first worksheet (with all the sales people) and have it appear in their own sheet as well. Is there anyway that I can move all the information by row, simply by entering a sales persons initials in the second column?? Any help is greatly appriecated!!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function? Moving the same info from one worksheet to anothe
That will work perfectly!!!!!! THANK YOU SOOOOOO MUCH!!!
"CLR" wrote: Personally, I prefer to have only the one main Database sheet with all the info on it. Then, groups of data can be AutoFiltered off it and set to a different sheet for each occasion.....this I usually do with a macro push-button.....for instance, I have one program with a MainMenu sheet, a database sheet, and a "report" sheet. The main menu has 8 buttons on it which each fire different macros, and each will put a different Autofiltered "report" on the "Report" sheet.......... hth Vaya con Dios, Chuck, CABGx3 "Naomi" wrote: I have a worksheet that tracks sales (date, type of lead, lead owner, customer name, number, information, and sold or not) and I have worksheets for each sales person with their closing ratios as well as a count of how many leads ect. I am trying to make it so that I can enter the information into the first worksheet (with all the sales people) and have it appear in their own sheet as well. Is there anyway that I can move all the information by row, simply by entering a sales persons initials in the second column?? Any help is greatly appriecated!!! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF function? Moving the same info from one worksheet to anothe
You're welcome.......and I forgot to mention, don't forget to code the macro
so it will erase the old data on the "Report" sheet before it sends over the new..... Thanks for the feedback....... Vaya con Dios, Chuck, CABGx3 "Naomi" wrote: That will work perfectly!!!!!! THANK YOU SOOOOOO MUCH!!! "CLR" wrote: Personally, I prefer to have only the one main Database sheet with all the info on it. Then, groups of data can be AutoFiltered off it and set to a different sheet for each occasion.....this I usually do with a macro push-button.....for instance, I have one program with a MainMenu sheet, a database sheet, and a "report" sheet. The main menu has 8 buttons on it which each fire different macros, and each will put a different Autofiltered "report" on the "Report" sheet.......... hth Vaya con Dios, Chuck, CABGx3 "Naomi" wrote: I have a worksheet that tracks sales (date, type of lead, lead owner, customer name, number, information, and sold or not) and I have worksheets for each sales person with their closing ratios as well as a count of how many leads ect. I am trying to make it so that I can enter the information into the first worksheet (with all the sales people) and have it appear in their own sheet as well. Is there anyway that I can move all the information by row, simply by entering a sales persons initials in the second column?? Any help is greatly appriecated!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Updating Info from a previous worksheet | Excel Worksheet Functions | |||
Passing a WorkSheet from a Function??? | Excel Worksheet Functions | |||
numerical integration | Excel Discussion (Misc queries) | |||
Changing worksheet cells from within a function | Setting up and Configuration of Excel | |||
Worksheet Function - Find? | Excel Worksheet Functions |