LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default combining information from several sheets into one sheet

Right now what I am doing is copying information each time into the
different sheets, I'm sure there is a formula to make this process
easier. I want columns A - E from sheet 1, 2, 3, 5, 6 to go into
sheet 10. So Column A from Sheets 1,2,3,5,6 go into column A of Sheet
10 and so on and whenever I add to sheets 1, 2, 3, 5 and 6 the
information will automatically go into sheet 10. Is there a formula
that will work for this?

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
add information from multiple sheets into one box on another sheet create button to unhide rows Excel Discussion (Misc queries) 0 January 21st 07 10:01 PM
Auto link rows of information from multiple sheets to single sheet Steve R Excel Discussion (Misc queries) 3 November 8th 06 06:13 AM
Combining data from cells from several excel sheets to a new sheet Rik Excel Discussion (Misc queries) 4 February 22nd 06 09:16 AM
Help with combining information abaco1 Excel Discussion (Misc queries) 1 November 30th 05 09:09 PM
combining row information tgoosed Excel Discussion (Misc queries) 2 October 13th 05 09:37 PM


All times are GMT +1. The time now is 02:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"