Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help with formatting Excel sheet.
Could someone please help with a macro or any other suggestion to format an
Excel sheet. Basically data is downloaded from a bank every week and the size of the file can vary but the formatting is constant. That is each record is 7 lines. So first record is line1-7, second record is line 8-14, third record is line 15-21 and so on. I need to format the sheet by taking specific column data from this source Excel worksheet and putting on to another blank sheet. The formatting required for each record is as follows. In the attached sheet the source data is on Sheet 1 and the formatted data is on sheet. The mapping is that in the source data there are 7 lines per record and in the destination data there are 2 lines per record. Some of the destination columns are blank and some have hardcode values. I am desperate and would appreciate any guidance on the same. Record Source Destination Hardcode value if value not coming from Source Data A1 'Document' B1 Blank G6 C1 F1 D1 E1 Blank F1 Blank G1 BLANK H1 P1 SECOND LINE OF DESTINATION A2 'Transaction' B2 BLANK G3 C2 .. D2 BLANK E2 BLANK G4 F2 G2 BLANK H2 BLANK I2 BLANK J2 BLANK P1 K2 L2 BLANK G2 M2 The pattern will repeat itself on every 8th line went the new record start. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I lock ONLY the formatting on an excel sheet? | Excel Worksheet Functions | |||
Inserting an excel sheet without the formatting. | Excel Discussion (Misc queries) | |||
Formatting a excel sheet that has been created using DTS. | Excel Discussion (Misc queries) | |||
formatting a column in excel sheet with VB | Excel Programming | |||
Formatting the default Excel sheet | Excel Programming |