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

backyarder1

New Member
Joined
Aug 15, 2009
Messages
4
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!
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,633
Office Version
365
Platform
Windows
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

New Member
Joined
Aug 15, 2009
Messages
4
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

Well-known Member
Joined
Apr 28, 2004
Messages
75,633
Office Version
365
Platform
Windows
Why don't you create the HTML from the data rather than exporting it to separate text files?
 

backyarder1

New Member
Joined
Aug 15, 2009
Messages
4
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

Well-known Member
Joined
Apr 28, 2004
Messages
75,633
Office Version
365
Platform
Windows
I'm a little confused.:eek:

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

New Member
Joined
Aug 15, 2009
Messages
4
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!:)
 

Watch MrExcel Video

Forum statistics

Threads
1,101,871
Messages
5,483,440
Members
407,395
Latest member
Sakshine

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top