Posted to microsoft.public.excel.programming
|
|
Dynamic Creation of Invoice number
I keep getting an error while trying to post so here goes again:
Here's the link - http://www.dslreports.com/forum/remark,17061545
"PapaDos" wrote:
The address I gave you is "auto-cleaning" every night, so I hope you were
able to retrieve my example before it was deleted. If not, let me know, we
will try again.
I was unable to retrieve yours, it was already deleted.
I hope my example was useful to you...
Regards,
Luc.
--
Festina Lente
"neroamdrid" wrote:
I've uploaded my table with embedded comments he
http://www.dslreports.com/forum/rema...58266#17059103
Thank you
"PapaDos" wrote:
I created a simple example for you.
You can get the file at
http://www.dslreports.com/forum/remark,17058266
Don't be shy with your questions...
--
Festina Lente
"neroamdrid" wrote:
There's definitely no reason to apologize :)
I've never worked with macros and the building of new rows is something I
have no idea where to begin with.
Are there any resources you can point me to? If I hit a major snag hopefully
it can be at 80% done and you can help me out with the finishing touches.
I'm also not sure on "unique top row"
Thanks.
"PapaDos" wrote:
Sorry, I made a mistake while editing my formula from ranges to names.
Replace CLIENT_TABLE with PROPOSAL_TABLE, which is the table of proposals ID
already existing.
I think you should use a unique top row to "build" the new entries and use a
button to call a macro that would copy those values to the end of your
PROPOSAL_TABLE. The macro could take care of unlocking, copying and relocking
the table's rows.
--
Festina Lente
|