| 1870 |
1999-05-15 01:29:00 |
I'm using Office 97 Pro. I have an application that saves it's data in a format not recognised by Excel. The data contains records that are imported into an Access database. The records can be saved as .txt files, imported into Excel as tab delimited records, specifying the type of character that seperates each record and then edited. The problem with the records is that information is contained in 8 seperate lines and once imported into Excel still contain spurious characters e.g. trailling apostrophes etc. I have extracted the needed information from the worksheet that I originally imported the data to using the LEFT, RIGHT and MID functions within Excel and displayed the resulting data in a seperate worksheet on one row. This is necessary for the importation of the data to Access, one Excel row = one Access record. There are approx. 8 columns and 500 rows of data in the orignal import work sheet. I'm trying to find a way to automatically fill my functions within the final display worksheet, at the moment my cells contain the following formulas:
Cell A1 =MID(<worksheetname>!A1,5,5) Cell A2 =MID(<worksheetname>!A9,5,5) Cell A3 =MID(<worksheetname>!A17,5,5) etc Is there anyway to copy/fill this formula down so that the cell reference increments in multiples of 8? If I highlight the three cells and drag/fill down my cell references in the new cells are relative to all three cells highlighted i.e. A2, A10, A18: it's driving me crazy. Any help would be highly appreciated. Keep up the good work, great mag!!!! Great column!!! |
Guest (0) |