Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-23-2014, 02:04 PM
zizao zizao is offline carry values of various sheets ​​to another sheet Windows Vista carry values of various sheets ​​to another sheet Office 2007
Novice
carry values of various sheets ​​to another sheet
 
Join Date: Mar 2014
Posts: 4
zizao is on a distinguished road
Default carry values of various sheets ​​to another sheet

I have some values ​​in 1st sheet and 2nd sheet and I needed to carry the values ​​to another worksheet making a list

Like this:

In 1st worksheet I have

A B


a 353125
b 643643
c 532

In 2st worksheet I have

A B
x 754
y 64363
z 23626

I want in the 3rd worksheet to return all values ​​of the other worksheets

Like this:

A B
a 353125
b 643643
c 532
x 754
y 64363
z 23626

how do I do this?
Reply With Quote
  #2  
Old 05-24-2014, 05:05 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline carry values of various sheets ​​to another sheet Windows 7 64bit carry values of various sheets ​​to another sheet Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,780
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Ron de Bruin has a neat add-in at this page which will do the job
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 06-20-2014, 12:47 PM
Mjpunj Mjpunj is offline carry values of various sheets ​​to another sheet Windows 7 32bit carry values of various sheets ​​to another sheet Office 2010 32bit
Novice
 
Join Date: Jun 2014
Posts: 7
Mjpunj is on a distinguished road
Default

Maybe I'm misunderstanding what it is that you're trying to do, but it seems like it would be easiest to Copy, Paste and Sort by column.
Reply With Quote
Reply

Tags
carry values



Similar Threads
Thread Thread Starter Forum Replies Last Post
Combine Data From 2 Sheets into a new sheet bremen22 Excel 1 09-11-2013 12:59 PM
Formulas in many Sheets referring to corresponding column in one sheet ue418 Excel 0 07-11-2012 02:04 AM
carry values of various sheets ​​to another sheet Reporting Values Between Sheets/Tabs jjbNana Excel 3 10-06-2011 10:28 PM
If two geographical data match in two sheets, copy unique id/code found in one sheet alliage Excel 1 09-01-2011 05:23 AM
carry values of various sheets ​​to another sheet How do I merge data from one sheet in a workbook out into multiple sheets nolesca Excel 4 06-07-2010 08:13 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:52 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft