Gathering rows of data from multiple wrkbks to single column
 

I need to have multiple workbooks for entering data and then have a Summary
workbook that gathers all the data and lines it up in a single report placing
all the data in conjoined ascending columns so there are no gaps between the
data or multiple sheets.

Can anyone lend a guiding hand?

Thanks
--
SaipanRick

Gathering rows of data from multiple wrkbks to single column
 

Hi SaipanRick

Maybe
http://www.rondebruin.nl/merge.htm

Or create links
http://www.rondebruin.nl/summary2.htm


--

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


"SaipanRick" wrote in message ...
I need to have multiple workbooks for entering data and then have a Summary
workbook that gathers all the data and lines it up in a single report placing
all the data in conjoined ascending columns so there are no gaps between the
data or multiple sheets.

Can anyone lend a guiding hand?

Thanks
--
SaipanRick

Gathering rows of data from multiple wrkbks to single column
 

Thanks!
--
SaipanRick


"Ron de Bruin" wrote:

Hi SaipanRick

Maybe
http://www.rondebruin.nl/merge.htm

Or create links
http://www.rondebruin.nl/summary2.htm


--

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


"SaipanRick" wrote in message ...
I need to have multiple workbooks for entering data and then have a Summary
workbook that gathers all the data and lines it up in a single report placing
all the data in conjoined ascending columns so there are no gaps between the
data or multiple sheets.

Can anyone lend a guiding hand?

Thanks
--
SaipanRick