Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 10th 12, 03:38 PM
Junior Member
 
First recorded activity by ExcelBanter: Oct 2012
Posts: 2
Default Link row of data from one worksheet to another based on column criteria

I have excel sheet with 4 worksheets tabs(Master, Won, Lost, No Bid). All data entered on Master. I want each row to automatically link/appear on 2nd, 3rd or 4th worksheet tab based on info in column Q (Result) which would be either 'Pending' - in which case it would stay on Master, 'Won' - would stay and copy to Won worksheet, 'Lost' - would stay andcopy to Lost worksheet, 'No Bid' - would stay and copy to No Bid worksheet. All rows would always show up on Master worksheet.

  #2   Report Post  
Old October 11th 12, 07:05 AM
Senior Member
 
First recorded activity by ExcelBanter: Mar 2012
Posts: 663
Default

Quote:
Originally Posted by texas tina View Post
I have excel sheet with 4 worksheets tabs(Master, Won, Lost, No Bid). All data entered on Master. I want each row to automatically link/appear on 2nd, 3rd or 4th worksheet tab based on info in column Q (Result) which would be either 'Pending' - in which case it would stay on Master, 'Won' - would stay and copy to Won worksheet, 'Lost' - would stay andcopy to Lost worksheet, 'No Bid' - would stay and copy to No Bid worksheet. All rows would always show up on Master worksheet.
Could you post a sample workbook?
  #3   Report Post  
Old October 12th 12, 08:32 PM
Junior Member
 
First recorded activity by ExcelBanter: Oct 2012
Posts: 2
Default

I have attached a sample file

Quote:
Originally Posted by Spencer101 View Post
Could you post a sample workbook?
Attached Files
File Type: zip Sample.zip (9.1 KB, 115 views)
  #4   Report Post  
Old October 13th 12, 11:05 AM
Senior Member
 
First recorded activity by ExcelBanter: Mar 2012
Posts: 663
Default

Quote:
Originally Posted by texas tina View Post
I have attached a sample file

Here's one simple approach to this. Column A on each worksheet holds a simple reference that is used to look up the data from the Sheet1 into the others. I've left them visible for now but you can simply hide column A on each sheet.

The email address hyperlinks in sheets 2 - 4 don't work in this version, but that's easily fixed if you need it to be.

The other way around this is simply recording a macro that filters the data in sheet 1 then copying and pasting the data into the relevant sheets from there.

Let me know if you need more help / information.

S.
Attached Files
File Type: zip TexasTina Example.zip (16.7 KB, 125 views)


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
copying data from one worksheet to several based on criteria marcia2026 Excel Programming 1 July 31st 08 03:38 AM
Help getting first column data based on criteria? Tami Excel Worksheet Functions 5 August 22nd 06 11:17 PM
Transferring data from one worksheet to another based on criteria dread Excel Discussion (Misc queries) 5 July 28th 06 07:37 PM
Copying data from one worksheet to another based on criteria Caatt Excel Discussion (Misc queries) 1 June 15th 06 10:19 AM
How to add data to a column based on criteria from another Lynn Bales Excel Discussion (Misc queries) 4 July 14th 05 04:11 PM


All times are GMT +1. The time now is 11:33 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017