Get data from excel report into row of csv file

Posted to microsoft.public.excel.programming

Gareth[_2_] Gareth[_2_] is offline

external usenet poster

Posts: 27

Get data from excel report into row of csv file

I have a report form in excel, it has several sheets with hundreds of
questions. I need to be able to get the responses to the questions out of
the report and into a csv file (one sheet on one row and other sheets on the
next rows, etc).

What is the easiest way to go about doing this?

Thanks in advance.

Gareth

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Getting missing data from one report into another report...	vlookupabyss	Excel Discussion (Misc queries)	3	January 8th 08 03:26 PM
Automate Excel report to place certain data into existing report?	Craig Harrison	Excel Worksheet Functions	3	July 25th 06 01:54 PM
Tidy up of data within Excel Report	[email protected]	Excel Programming	0	October 24th 05 09:28 PM
"Unable to read file" error message when opening a Excel file that contains a PivotTable report.	Tim Marsden	Charts and Charting in Excel	2	October 15th 05 02:10 PM
=(IF(ISTEXT('Data Report'!$L2:$L4),'Data Report'!N3,J11)) Response	s2frost	Excel Discussion (Misc queries)	2	June 25th 05 06:07 PM

All times are GMT +1. The time now is 06:23 PM.

Menu

About Us