Incognitus
10-13-2012, 05:02 AM
Hello there,
I had an idea for something that would really improve efficiency on a set of spreadsheets used by multiple users, however I can only work out how to do it in an extremely inefficient way - and I'm sure there must be something more quick and effective!
In a nutshell - Worksheet B contains rows of data - and chances are when it came to entering the data, the information for column A,B,C was available, but D,E,F weren't.
I've already added a form to Worksheet A which allows entry of A,B,C directly into worksheet B - which is saving us lots of time, however I wanted to a new form which would contain a listbox and several data entry/option buttons to allow an easier update of the outstanding information.
Ergo, a listbox containing all Column A values from Worksheet B where D is blank, and then allow entry of D,E,F and update with the click of a button on the bottom.
At the moment, I'm filtering for all blanks on column D, copying the entire row into a hidden worksheet on worksheet A, and then using that hidden worksheet to feed the values to my form. Once something has been input, I then copy the entire row straight back to worksheet B whilst simultaneously deleting the pre-existing one. Update, rinse, repeat.
^ Can someone advise me of the more efficient way to be doing this?
I had an idea for something that would really improve efficiency on a set of spreadsheets used by multiple users, however I can only work out how to do it in an extremely inefficient way - and I'm sure there must be something more quick and effective!
In a nutshell - Worksheet B contains rows of data - and chances are when it came to entering the data, the information for column A,B,C was available, but D,E,F weren't.
I've already added a form to Worksheet A which allows entry of A,B,C directly into worksheet B - which is saving us lots of time, however I wanted to a new form which would contain a listbox and several data entry/option buttons to allow an easier update of the outstanding information.
Ergo, a listbox containing all Column A values from Worksheet B where D is blank, and then allow entry of D,E,F and update with the click of a button on the bottom.
At the moment, I'm filtering for all blanks on column D, copying the entire row into a hidden worksheet on worksheet A, and then using that hidden worksheet to feed the values to my form. Once something has been input, I then copy the entire row straight back to worksheet B whilst simultaneously deleting the pre-existing one. Update, rinse, repeat.
^ Can someone advise me of the more efficient way to be doing this?