Collecting data from multiple sheets

G

Gareth

I have a spreadsheet with approx 15 sheets. The sheets are basically a list
of questions and the answers provided by users. What I need to do is
transfer the answers provided by users onto a single row on another sheet and
then save that sheet as a csv file so that it can be imported into our 'main'
database.

We use XL 2003.

I know that I haven't given much for you to go on but if you think you can
help, let me know and I will send you an example file.

Thanks in advance.

Gareth
 
J

Jacob Skaria

Hi Gareth

--If the sheetnames are named after the username.. user1, user2 etc; then
arrange the user names in ColA

Col A Col B Col C Col D
Name Ques 1 Ques 2 Ques 3
User1 =
User2 =

--In cell B2 apply the below formula which will look at User1!B1. Copy down
the formula as required which will pick up the values from each user sheet.
=INDIRECT("'" & A2 & "'!B1")

--If the answer cells are arranged in an order you can modify the above
formula so that you dont need to have a separate formula for Question 2..
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to Combine Data from Multiple Sheets with Cell References 4
Data collecting from different sheets 2
Importing and exporting sheets from spreadsheets 1
Macro to Compile Data from Different Sheets 2
password protect individual sheets 1
collect data from sheet and put into one row of csv file 2
copy sheets from many files into 1 1
Delete Multiple sheets 4

Top