I'm sorry this is sending me insane, I will have to avoid macro as I am not
experienced enough to understand the different references throughout your
site. I was hoping there would be a direct formula so that if I update any
information, the main worksheet will update, which may not appear in the
macro without me running it again.

Will just try and link it all manually. Thanks for your help though.

"Ron de Bruin" wrote:

From my site:

Important:
The macro examples use the LastRow or LastCol function that you can find in the last section of this page.


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Michael" wrote in message ...
ok I'm sorry but I am really crap when it comes to VB. I tried copying it
over but I really really don't know what I am doing. I copied your example in
its entirety just to test before trying to manipulate and I got an error
message "Compile Error sub or function not defined" and it then highlights
"LastRow" within the following text - 'Find the last row with data on the
DestSh
Last = LastRow(DestSh)

"Ron de Bruin" wrote:

Hi Michael

See this page for a code solution
http://www.rondebruin.nl/copy2.htm

Download the example workbook
There is a column example

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Michael" wrote in message ...
Hi

Sorry I trawled through the questions and none really applied to my issue.

Here is the scenario - I have 80 seperate worksheets in one spreadsheet
file. Column A is the list of headings (questions in my case) on each row,
and Column B is the response (data).

Each worksheet is set out like a survey so there are some rows that contain
a "heading" but no corresponding data (ie the field in column B is blank for
asthetic purposes).

So that I can run pivot tables on the collected data, I want to combine all
of the information from the 80 odd worksheets into one. They are all based on
a template, so Column A will always be the same. So what I want is to bring
all of the data in Columb B from each worksheet. I want each column to be
identifed by the worksheet name.

Is this possible??

As a footnote, FYI I describe myself as an intermediate user (so if you can,
dumb it down for me), and I may have a need of adding additional worksheets
and therefore data in the future. Finally I really really do not want to have
to cut and paste each set of data...