| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
table/list & macro help
Running excel 07
I have a table/list created where I log quotes. Customer / Reference / Quote number Currently I have a formula in the quote number formula that takes the previous quote number + 1. So the quote number listed in C10 is 110. As I tab through it creates a new line and therefore gives me my next quote number ei 111. My problem is, if I were to resort or filter my results, my quote numbers go out of whack. Goal: what I want is possibly a macro that as I create a new line, it converts the value in row C from a formula (=c10+1) to a value of 111. Any good ideas here? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| table to xyz list | Excel Worksheet Functions | |||
| List from a table | Excel Worksheet Functions | |||
| delete a macro that isn't in macro list | Excel Discussion (Misc queries) | |||
| list to table | Excel Worksheet Functions | |||
| How to create a macro that compares a list to another list | New Users to Excel | |||
Linear Mode
