M
Maki
Hello,
I've created a form very similar to the one on Contextures website
(http://www.contextures.com/xlForm02.html).
Only, mine is not as sophisticated as FormSheet.xls since it is a
registration form for a meeting and some fields can be left blank (e.g. there
are three address lines just in case but Address_2 and Address_3 doesn't need
to be filled in). I don't need automatic entering of "Entered (time/date)"
and "Entered By" columns either.
In my Entry Form wks (equivalent of Input wks), the fields are not ligned up
in one column as is the case with Input wks (all in Column D). Also in my
Database wks (equivalent of PartsData wks), there are fields (columns) that
are automatically filled in with VLOOKUP (e.g.
country codes for phone are automatically filled in according to the data in
"Country" field) and therefore a little manuevering is necessary to avoid
copying into cells that are automatically filled in.
How can I do this in an elegant way?
The cells to be copied from Entry Form wks are:
C8,C10,C12,C14,C16,C18,C19,C20,C22,C24,C26,C28,D30,D32,C34,C38,C40,C42,C44,C46,C48,C51
and they would go to columns in Database wks:
B,C,D,E,F,G,H,I,J,K,L,M,O,Q,R,T,U,V,W,X,Y,S
NB: Column A is reserved, N and P are filled automatically in accordance
with the data in M (comes originally from C28 of Entry Form wks) and S is
filled by data in C51.
Many thanks.
I've created a form very similar to the one on Contextures website
(http://www.contextures.com/xlForm02.html).
Only, mine is not as sophisticated as FormSheet.xls since it is a
registration form for a meeting and some fields can be left blank (e.g. there
are three address lines just in case but Address_2 and Address_3 doesn't need
to be filled in). I don't need automatic entering of "Entered (time/date)"
and "Entered By" columns either.
In my Entry Form wks (equivalent of Input wks), the fields are not ligned up
in one column as is the case with Input wks (all in Column D). Also in my
Database wks (equivalent of PartsData wks), there are fields (columns) that
are automatically filled in with VLOOKUP (e.g.
country codes for phone are automatically filled in according to the data in
"Country" field) and therefore a little manuevering is necessary to avoid
copying into cells that are automatically filled in.
How can I do this in an elegant way?
The cells to be copied from Entry Form wks are:
C8,C10,C12,C14,C16,C18,C19,C20,C22,C24,C26,C28,D30,D32,C34,C38,C40,C42,C44,C46,C48,C51
and they would go to columns in Database wks:
B,C,D,E,F,G,H,I,J,K,L,M,O,Q,R,T,U,V,W,X,Y,S
NB: Column A is reserved, N and P are filled automatically in accordance
with the data in M (comes originally from C28 of Entry Form wks) and S is
filled by data in C51.
Many thanks.