| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating a template that I can reproduce every month by keying ininformation from SAP
Hello,
I am trying to navigate through Excel, and one of the issues I'm running into is being able to create a formula template that will save formulas to automatically enter information when importing from SAP. I have two different worksheets and am linking the imported sheet to a cover sheet I've created in Excel. The easy part was summing the different parts of each category that link perfectly. The problem is that when I sort the imported sheet, it will scramble the order, and my summations in the cover sheet will no longer be the same. I thought this would be easy until I did that. How should I go about locking the cells in the imported sheet, so that when I sort from greatest to smallm or smallest to greatest, that the sums in the cover shet DO NOT CHANGE! I think this is way above my level of expertise on Excel! Thankyou |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Template (Creating a Function in the template) | Excel Worksheet Functions | |||
| Excel Lags When Keying Numeric | Excel Discussion (Misc queries) | |||
| How Excel help to reproduce a form like this | Excel Worksheet Functions | |||
| I need an excel sheet to creating a new folder every month, and save a new spreadsheet every day, untill the next month, when it creates a new folder | Excel Programming | |||
| Over keying a formula - Can I set this to automatically bold ? | Excel Worksheet Functions | |||
Threaded Mode
