Excel formatting

  • Thread starter Thread starter Sam Commar
  • Start date Start date
S

Sam Commar

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 this data and basically I can record a macro for one data
set that is for the record on line 1 to 7. My question is how can I set it
to replicate so that it replicates for line 8-14 and then 15-21 and so on.
The source formatting remains the same except that the total length of the
file( no of records) changes every week.


Thanks very much for your help.

Regards

Sam
 
Sam,
I have had to do this before with a downloaded file from a bank. I needed
it to convert dates from text and the dollar amounts as currency.
Basically, I just had the macro recorder watch me format my first record set
and go to the beginning of the next record set, turned off the recorder, and
assigned the macro to a good letter combo (like alt+z). Then I was able to
just sit there and hold down alt+z without lifting my fingers off the
keyboard until I was approaching the end of my recordset, at which point I
let go of the z (but not alt) and deliberately hit the z once for each
remaining record set until I reached the end. I was dealing with hundreds
and even thousands of transactions per client for about 40 clients each
month, but this method took mere seconds each and every time.
 
Hi Somehow that did not work. It keeps trying to update the first set of my
records. My destination record set is 2 lines. Was your more that one line.

Thanks
Sam
 
Sorry, Sam, my idea won't work for your application. I was not copying and
pasting, just formatting and moving down, formatting and moving down.
The macro jlepack wrote should work beautifully and is much more intuitive
anyway.
 
Back
Top