I would like to save or print each row to separate file

[backyarder1]

I get a copy of a huge excel spreadsheet every week. The cells are so full of data it is very difficult to read. My job is to create webpages from each row of data.

Is there some way to write a script or macro that will step through a workseet and for each row of data, it will save it to a separate file? If not, is there a way to have each row of data PRINTED to a separate file.

Thanks so much for ANY help!

 

[Norie]

Yes there are ways to do what you describe, but are you sure that's the best approach.

You say it's a huge spreadsheet, which implies that you would end up with a lot of files if you create one for each row.

What are you actually going to do with with the data?

PS Can give more information on the data and how you would like to create/structure these files? eg do you want to create CSV files?

 

[backyarder1]

Each row is a description of a job. I need to take each row and create a webpage describing the job. Most of the data I need is really only in a few of the cells in the row so I don't need ALL of the data.

The data in the rows isn't in "pretty" enough format so that I can just create an html file that is ready to put online.

It might be easier to do something like:

for each row
merge the cells (3 cells I think)
then print the data to a separate file

Even if it is just printed to a txt file, I can then cut and past it into an html file and dress it up, as needed.

 

[Norie]

Why don't you create the HTML from the data rather than exporting it to separate text files?

 

[backyarder1]

I'm not sure how the spreadsheet was created, but I can't even see all the data in the rows unless I click on each cell. Formatting the cells to autofit doesn't work. So I can't just highlight a cell and copy the data and then paste it into an html document. I haven't been able to figure out any way other than highlighting each cell and copying the data and then pasting it into html and there are a LOT of rows for that.

 

[Norie]

I'm a little confused.

You say you can't 'see' the data but it's there?

If the data is there then you should be able to work with it, be that creating a text file or HTML, whatever.

Also, as far as I know, most apps/tools for creating webpages have options to import data.

Any chance you could post some data?

 

[backyarder1]

I don't see anyway to attach a file here so I don't really know how to show you the data. I'll keep poking around with it and see what I can figure out. Thanks for your help!