wildcataz2012
New Member
- Joined
- Jun 2, 2014
- Messages
- 7
I have to change these dates every month, but need only certain columns to change. I have a program and trying to see if excel will change do a "c" but then skip the data that is in 'abcdefghij', skip data in column 'a', skip 'b', skip 'c', then input the date of '070114', input '071414' and finally skip 'abc' column. So really only want what is highlighted to be changed but don't want the rest of it changed. I have tried the 'C' and then spaces. But when I do that, it replaces 'abcd..' with blanks which I don't want.
<colgroup><col style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560;" width="70"> <col style="width: 52pt; mso-width-source: userset; mso-width-alt: 2523;" width="69"> <col style="width: 23pt; mso-width-source: userset; mso-width-alt: 1133;" span="3" width="31"> <col style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560;" span="2" width="70"> <col style="width: 23pt; mso-width-source: userset; mso-width-alt: 1133;" width="31"> <tbody>
</tbody>
Need input | skip | skip | skip | skip | Need input | Need input | skip |
c | abcdefghij | a | b | c | 070114 | 071414 | abc |
c | abcdefghij | a | b | c | 070114 | 071414 | abc |
c | abcdefghij | a | b | c | 070114 | 071414 | abc |
<colgroup><col style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560;" width="70"> <col style="width: 52pt; mso-width-source: userset; mso-width-alt: 2523;" width="69"> <col style="width: 23pt; mso-width-source: userset; mso-width-alt: 1133;" span="3" width="31"> <col style="width: 53pt; mso-width-source: userset; mso-width-alt: 2560;" span="2" width="70"> <col style="width: 23pt; mso-width-source: userset; mso-width-alt: 1133;" width="31"> <tbody>
</tbody>