Hi Everyone...
Just beginning to get the hang of vba coding in excel. I would like
to implement a new feature in a spreadsheet here at the office. We
currently have a master records sheet containing vital information on
unit processing. Each unit then has a sub file containing additional
information. Currently one must populate the master record file. Then
open a template and populate another file with the same information. I
would like to streamline this process and have the data in the master
record file automatically inserted into the template, allowing the user
to only have to fill in a few other minor details. What I would like is
to have a "Create Record" button. When clicking the button the user
should be prompted for either a record number (stored in the B column)
or a row number (not as elegant). The macro would then pole that row (x)
and transfer the value of cells BX, CX, DX, etc to cell A3, D9, E6 etc
in the newly created file based on an existing template (template.xlt)
Any help would be greatly appreciated as I am lost when it comes to
something this complex.


--
jmootrey
------------------------------------------------------------------------
jmootrey's Profile: 1387
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=170486

Microsoft Office Help