|
Subject:
|
finding and populating next available column
|
|
Posted By:
|
rlrigsby
|
Post Date:
|
4/14/2006 4:08:59 PM
|
I have a worksheet called Data Export that collects data in Column B3:B431 from a collection of worksheets within the same workbook. Each time raw data is entered into one worksheet, the information in Column B changes and represents the total data for one person.
I want Excel to take the data from Column B go find the next available column in the database worksheet and populate it. Each column in the database on row 3 has also been labeled 10001, 10002, 10003, etc to uniquely identify the data as belonging to a certain person. I want Excel to take the first and last name from the worksheet entitled "Scoring Template", together with the database number under which their data resides, and place these two items in another worksheet entitled "key" so that a running list is maintained of who the raw data belongs to. Lastly, I need a button that tells Excel to clear all the unlocked cells on worksheet "Scoring Template".
Can anyone help me with the code to make this work?
Thanks!
|
|
