Welcome Guest ( Log In | Register )

Outline · [ Standard ] · Linear+

 Excel sort by date

views
     
TSdjzone111
post Mar 25 2016, 07:06 PM, updated 8y ago

Getting Started
**
Junior Member
71 posts

Joined: Feb 2010


I have a problem here. In excel, how can I retrieve data from multiple tabs (15 tabs) into on sheet ?

Attached Image

Is there a function that I can use eg: if, sumif, vlookup etc ? I need to search the date (day by day) in 15 tabs and place the data into one sheet.

Attached Image


Please help, thanks.

This post has been edited by djzone111: Mar 25 2016, 07:26 PM
perfectgrowwell
post Mar 25 2016, 09:22 PM

Getting Started
**
Junior Member
178 posts

Joined: Nov 2015
From: Muar
Hi!
I try answer your question.

For example, sheet1, sheet2 and sheet3 display on your excel.

Let say, sheet1 I key in data in A2 and sheet2 key in data in A3, then I need sheet3 to get data from A1 and A2 in sheet3, formula=Sheet1!A2 in particular column and row.

Maybe I'm wrong is not the one you want.



TSdjzone111
post Mar 26 2016, 12:58 PM

Getting Started
**
Junior Member
71 posts

Joined: Feb 2010


QUOTE(perfectgrowwell @ Mar 25 2016, 10:22 PM)
Hi!
I try answer your question.

For example, sheet1, sheet2 and sheet3 display on your excel.

Let say, sheet1 I key in data in A2 and sheet2 key in data in A3, then I need sheet3 to get data from A1 and A2 in sheet3, formula=Sheet1!A2 in particular column  and row.

Maybe I'm wrong is not the one you want.
*
Hi, I need to search tabs (sheet1, sheet2, sheet3 etc) for the day by day date.

Thanks.

This post has been edited by djzone111: Mar 26 2016, 12:59 PM
SUSAmeiN
post Mar 26 2016, 01:23 PM

★★★★★★★
*******
Senior Member
4,735 posts

Joined: Feb 2010
From: ★~Starlight~★

try this

http://www.mrexcel.com/forum/excel-questio...worksheets.html
TSdjzone111
post Mar 29 2016, 06:37 PM

Getting Started
**
Junior Member
71 posts

Joined: Feb 2010


QUOTE(AmeiN @ Mar 26 2016, 02:23 PM)
Thanks...
fever003
post Apr 1 2016, 04:04 PM

Getting Started
**
Junior Member
81 posts

Joined: Dec 2007
QUOTE(djzone111 @ Mar 25 2016, 07:06 PM)
I have a problem here. In excel, how can I retrieve data from multiple tabs (15 tabs) into on sheet ?

Attached Image

Is there a function that I can use eg: if, sumif, vlookup etc ? I need to search the date (day by day) in 15 tabs and place the data into one sheet.

Attached Image
Please help, thanks.
*
Hi,

Can you elaborate more on what you require?

Most importantly, I would liek to have a look at the layout so I can suggest a solution.
wkphang
post Apr 17 2016, 06:20 PM

Getting Started
**
Junior Member
264 posts

Joined: Jan 2003
Can use macros.....else u can use mixture of vlookup and formulas (but it will get messy)
TSdjzone111
post Apr 23 2016, 05:53 PM

Getting Started
**
Junior Member
71 posts

Joined: Feb 2010


QUOTE(wkphang @ Apr 17 2016, 07:20 PM)
Can use macros.....else u can use mixture of vlookup and formulas (but it will get messy)
*
Thanks for ur help.

I found a link that maybe useful : http://superuser.com/questions/219201/exce...multiple-sheets

=sum(Jan:END!A1)
This formula will add up all the values in A1 from each sheet between Jan and End.

This post has been edited by djzone111: Apr 23 2016, 06:02 PM

 

Change to:
| Lo-Fi Version
0.0184sec    0.58    6 queries    GZIP Disabled
Time is now: 29th March 2024 - 03:49 PM