FILTERS

R

rammohanJ

New Member
Joined
May 25, 2006
Messages
7
I have a main Database with Index Column in Sheet1. Also I have transactions with distinct Transaction ID in Sheet2 which includes Index column of Sheet1.
Now what I need is the report in Sheet3.
On selection of any Index Column (restricted through Data Validation) in Sheet3, I need the transaction IDs listed below. Should I use filter commands (as in Foxpro). Please guide.
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
Sort by date Sort by votes
Sounds like a case for Advanced Filter.

Though if there are a few records, I'd favour a query table (with SQL).

Does the advanced filter achieve what you want? Excel help refers.

Maybe you could have some code to do the filtering from your inputs and paste the result set where you want it?

HTH
Fazza
 
Upvote 0
I have a list of experiments that can be performed with an instrument as well list of instruments.

If I select a particular instrument, only relevant experiments to that should be in validation list.

Please guide me.

Similar eg is name of the states in a country on selection of a country name.
 
Upvote 0
I have a list of experiments that can be performed with an instrument as well list of instruments.

If I select a particular instrument, only relevant experiments to that should be in validation list.

Please guide me.

Similar eg is name of the states in a country on selection of a country name.
Click to expand...

There is some difference between your first post and this one, although they share a common core...

The following might help:

http://www.mrexcel.com/board2/viewtopic.php?t=283305

http://www.mrexcel.com/board2/viewtopic.php?t=8659
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question Question
HYPERLINK() function Seems Unable to Jump to Another Sheets Table and Filter
Replies
6
Views
447
Skyybot
Skyybot
N
  • Question Question
Automating VB-Tax form reports
Replies
1
Views
80
Ndk
N
S
  • Question Question
Help with Pivot Table Macro
Replies
0
Views
85
SCPbrito
S
E
  • Solved
Json Excel Square Brackets within Square Brackets Run-Time Error '1004'
Replies
3
Views
887
Domenic
D
K
  • Question Question
Time and date stamp with drop down menu
Replies
0
Views
453
kmsprague
K

Forum statistics

Threads
1,225,071
Messages
6,182,686
Members
453,132
Latest member
nsnodgrass73

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top