Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 3rd 05, 10:12 AM
gsnivas
 
Posts: n/a
Default Updating excel sheet with selected data from another sheet in the same file


Hi,

I have a excel sheet, sheet1 having lot of information as shown below:

Alloc. Status----------Emp. Name
(in Column A)---------(in Column B)
_________________________

Domestic---------------Emp1
Overseas--------------Emp2
Internal----------------Emp3
Leave-------------------Emp4
Overseas---------------Emp5
Internal-----------------Emp6

I would like to update another sheet, sheet2 in the same file based on
the alloc.Status, eg.Domestic.

Sheet2 should get updated automatically whenever there is a change in
sheet1.

I found some formula at the URL below:

http://office.microsoft.com/en-us/as...260381033.aspx

But that formula is working only in the same sheet. It's not working
when I used it in Sheet2.

Thanks in advance
GSNIVAS


--
gsnivas
------------------------------------------------------------------------
gsnivas's Profile: http://www.excelforum.com/member.php...o&userid=25860
View this thread: http://www.excelforum.com/showthread...hreadid=392445


  #2   Report Post  
Old August 4th 05, 09:55 AM
gsnivas
 
Posts: n/a
Default


Hi all,

Following is the formula which is working:

=IF(ISERROR(INDEX(AllIDM!$A$1:AllIDM!$C$500,SMALL( IF(AllIDM!$A$1:AllIDM!$A$500="Branch",ROW(AllIDM!$ A$1:AllIDM!$A$500)),ROW(Sheet3!1:1)),3)),"",INDEX( AllIDM!$A$1:AllIDM!$C$500,SMALL(IF(AllIDM!$A$1:All IDM!$A$500="Branch",ROW(AllIDM!$A$1:AllIDM!$A$500) ),ROW(Sheet3!1:1)),3))

AllIDM is the main worksheet having complete data, Branch is test
condition.

Thanks
GSNIVAS


--
gsnivas
------------------------------------------------------------------------
gsnivas's Profile: http://www.excelforum.com/member.php...o&userid=25860
View this thread: http://www.excelforum.com/showthread...hreadid=392445



Reply
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
How do I import formmail data to a custom excel template? cxlough41 Excel Worksheet Functions 1 July 1st 05 12:59 AM
updating a column in existing excel sheet disgustipated Excel Worksheet Functions 0 June 29th 05 08:44 PM
Password protection of Excel Sheet linked to Bloomberg Data Rohit Excel Discussion (Misc queries) 0 June 28th 05 10:29 AM
Getting Excel Data from One Sheet to Another.... Robin Excel Discussion (Misc queries) 2 April 21st 05 01:15 PM
Analyzing non numerical data in an excel spread sheet luckyou_854 Excel Worksheet Functions 1 December 29th 04 10:21 AM


All times are GMT +1. The time now is 09:24 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017