To Create a Sheet for Data Entry

dileepkumarcp

New member
Joined
Jan 23, 2015
Messages
1
Reaction score
0
Points
0
ABCDEFGHIJK
1codecodecodecodeSeriescode123Input
212340001APPPOOOIIINNNNNNNNNNN
3
12340002BPPPKKKLLLMMMMMMMMMM
412340003CUUUYYYLLLBBBBBBBBBBBB
512340004

Hi
From A2 TO D5 SOME VALUES ARE THERE IT SHOULD BE REPEATED IN FOLLOWING CELLS AFTER PRESSING ENTER IN J2 AND E2 SHOULD BE INCREASED BY "1".
IF I ENTER "A" IN F2 AUTOMATICALLY SOME DATA SHOULD APPEAR IN "G2, H2 AND I2" AND SO ON. SO PLEASE ANY BODY CAN HELP.

THE FONT HIGHLIGHTED WITH THE RED COLOUR IS THE ONLY PLACE THAT CAN ENTER THE DATA , THE REMAINING SHOULD COME AUTOMATICALLY.
 
Back
Top