Looking for way to reformat without so much copy and pasting

[eggman2001]

I receive data from a vendor, which I then have to reformat
extensively. It is a large amount of copying and pasting as well as
transposing (changing row data into columns) and it takes 2 - 3 hours
each time I do this.

I'm wondering if excel might have some built-in tools that could help
streamline this. I'm considering writing a script that could help with
this, but that probably isn't ideal because it wouldn't be able to
handle the styling.

Any ideas?

 

[Pete_UK]

If your new data is in a Source sheet, then in a destination sheet you
can have formulae to copy the data from the Source sheet in the format
and the column order that you require. Then each time you receive new
data you copy it into the Source sheet, and then copy the formulae in
the Destination sheet down for as many rows as you need. Then you can
fix the values in that sheet, delete the Source sheet and then save
the file with a different name so that your "master" file with the
formulae in remains untouched and ready for the following month.

Should only take about 15 minutes or so, and even faster if you used a
macro.

Hope this helps.

Pete

 

[Moily]

You could try linking. If you get the exact same layout each time from the
vendor then you can set up a new worksheet of links (in the manner that you
wish to present the data) that are linked to the vendor worksheet. Every
time you get a new report just paste the data into the vendor worksheet.