View Single Post
  #20   Report Post  
Posted to microsoft.public.excel.programming
neroamdrid neroamdrid is offline
external usenet poster
 
Posts: 17
Default 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