Dear sir,
I want auto save(backup) and update my data(every time when I write some thing) of my excel through VBA CODING in different excel located in different location and folder FOR EXAMPLE save my data to excel name "storage" located in D drive in new folder.(exactly to my original data ) Kindly help me out of the problem. The excel to be copied is attached here
Thank you sir
<colgroup><col><col><col><col><col><col><col><col><col span="2"><col><col><col><col><col><col span="8"><col span="6"><col span="5"><col><col span="7"><col span="2"><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
I want auto save(backup) and update my data(every time when I write some thing) of my excel through VBA CODING in different excel located in different location and folder FOR EXAMPLE save my data to excel name "storage" located in D drive in new folder.(exactly to my original data ) Kindly help me out of the problem. The excel to be copied is attached here
Thank you sir
SYMPTOMs | ACTIVITY | 5. Worksheet 2 - Scoring Criteria for Condition | 6. Work Sheet 3 - Scoring Metabolic Stress | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
SL.NO. | DATE (B3) | NAME (B4) | REG.NO (M3) | AGE (M4) | HEIGHT (C10) | SEX (P3) | BMI(P4) | CW (G9)Kgs | 1MW (G12) | 6MW (G13) | FI (T14) | All relevant diagnoses (E94) | STAGE (E95) | TREATMENT (B98) | SYM.3.1 (A20) | SYM.3.2(A21) | SYM.3.3(A22) | SYM.3.4(A23) | SYM.3.5(A24) | SYM.3.6(A25) | SYM.3.7(A26) | SYM.3.8(A27) | SYM.3.9(A28) | SYM.3.10(A29) | SYM.3.11(A30) | SYM.3.12(A31) | SYM.3.13(A32) | SYM.3.14(A33) | SYM.3.15(A34) | AC.4.1(K20) | AC.4.2(K21) | AC.4.3(K22) | AC.4.4(K23) | AC.4.5(K24) | % Wt.Loss (L49) | SCC.2.1 (K42) | SCC.2.2 (K43) | SCC.2.3 (K44) | SCC.2.4 (K45) | SCC.2.5 (K46) | SCC.2.6 (K47) | SCC.2.7 (K48) | no fever (E58) | no fever (E59) | no steroids (E60) | >99 and <101 (H58) | <72 hrs (H59) | low dose (<10mg prednisone equivalents/day) (E60) | >101 and <102 (K58) | 72 hrs (K59) | moderate dose (>10 and <30mg prednisone equivalents/day) (K60) | >102 (N58) | > 72 hrs(N59) | high dose steroid ( >30mg prednisone equivalents/day) (N60) | PE (S80) | PG-SGA RATING (K90) | TOTAL PG-SGA SCORE (N97) |
1 | 14/06/2015 | S15 | 0 | 50 | 157 | M | 25.15 | 62 | 65 | 0 | unchanged | LY | 0 | CT | YES | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | YES | 0 | 0 | 0 | 2 | YES | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | A | 6 |
2 | 18/04/2015 | S16 | 0 | 67 | 152 | M | 14.72 | 34 | 35 | 0 | less than usual | OC | 0 | SUR+CT | 0 | 0 | YES | YES | 0 | 0 | 0 | 0 | 0 | 0 | YES | 0 | 0 | 0 | Depression | 0 | 0 | YES | 0 | 0 | 1 | YES | 0 | 0 | 0 | 0 | YES | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | C | 14 |
3 | 18/04/2015 | S17 | 0 | 59 | 163 | M | 14.68 | 39 | 40 | 0 | less than usual | OE | 0 | CT | 0 | YES | YES | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Depression | 0 | 0 | YES | 0 | 0 | 1 | YES | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 14 |
4 | 18/04/2015 | S18 | 0 | 28 | 154 | M | 17.29 | 41 | 40 | 0 | less than usual | OC | 0 | SUR+CT | 0 | 0 | YES | 0 | 0 | YES | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Depression | 0 | 0 | YES | 0 | 0 | 0 | YES | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | B | 9 |
5 | 14/06/2015 | madam | 12345/12 | 44 | 160 | F | 21.48 | 55 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Review | 0 | 0 |
6 | 14/06/2015 | sample | 12345/12 | 44 | 160 | F | 21.48 | 55 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Review | 0 | 0 |
7 | 14/06/2015 | test | 12345/12 | 44 | 160 | F | 21.48 | 55 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Review | 0 | 0 |
8 | 14/06/2015 | LAST | 12345/12 | 44 | 160 | F | 21.48 | 55 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Review | 0 | 0 |
9 | 14/06/2015 | BIG | 12345/12 | 44 | 160 | F | 21.48 | 55 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Review | 0 | 0 |
10 | 14/06/2015 | LOOK | 12345/12 | 44 | 160 | F | 21.48 | 55 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Review | 0 | 0 |
11 | 14/06/2015 | END | 12345/12 | 44 | 160 | F | 21.48 | 55 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Review | 0 | 0 |
12 | 16/06/2015 | DNA | 0 | 0 | 0 | 0 | #DIV/0! | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | Review | 0 | 0 |
<colgroup><col><col><col><col><col><col><col><col><col span="2"><col><col><col><col><col><col span="8"><col span="6"><col span="5"><col><col span="7"><col span="2"><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>