Hi Everyone
First time user and absolute noob at VBA so I would realy appreciate your help with my problem.
I have a data set on worksheet called "Demand" and its set out as follows:
Column B2:B58 contain static labels and
Column C2:C58 contains the default, blank lists described in D2:D58
Column D2:D58 contain a series of drop-down lists, text field that users have to complete and select.
I want to create a button ("Add new Record") located at B1 that copies all the formulas, drop-down lists, formatting etc from C2:C58 into the next available column - which would be E2:E58 and F2:F58, G2:G587, etc , every time you select the "Add New Record" Button.
I would be most thankful for any assistance you can offer. Thanks Bruce.
Bookmarks