Posted by: Pretty_Girl April 24, 2009
Login in to Rate this Post:
0
?
Copycat,
well you have couple of option for doing that.
1) you can use autofilter as suggested by dd_sh and paste the values in each and every sheet. But then again after you insert any record in sheet 1 , you have to repeat it. This way is good only if you wanna see the result in sheet 2 once a month lets say. Its pretty easy way.
2) if you are comfortable with access, you can import your existing record into Ms Acess: Actually its good idea even to store your data in access henceforth.Then all you have to do is make a simple query to display as you want. u can use GUI query or if you are comfortable with SQL, use sql. Choice is yours.
3) If you are adamant that want to do that in excel, there is a better way than doing in Excel than autofilter which will update list in sheet 2 as you enter values in sheet 1. The idea is to extract the Lunch fields from sheet 1 using functions like if, rows, vlookup etc. And then further using Vlookup base in date field. This way, you have to write formulas which might seem to a bit complicated, but once u grasp it , its easy and u may use it further for other stuff. Look at this link , it will greatly help you to see what i m taking abt..
http://www.youtube.com/watch?v=nz9LcymyjbY
Either way you can easily do what u wanted to do.
well you have couple of option for doing that.
1) you can use autofilter as suggested by dd_sh and paste the values in each and every sheet. But then again after you insert any record in sheet 1 , you have to repeat it. This way is good only if you wanna see the result in sheet 2 once a month lets say. Its pretty easy way.
2) if you are comfortable with access, you can import your existing record into Ms Acess: Actually its good idea even to store your data in access henceforth.Then all you have to do is make a simple query to display as you want. u can use GUI query or if you are comfortable with SQL, use sql. Choice is yours.
3) If you are adamant that want to do that in excel, there is a better way than doing in Excel than autofilter which will update list in sheet 2 as you enter values in sheet 1. The idea is to extract the Lunch fields from sheet 1 using functions like if, rows, vlookup etc. And then further using Vlookup base in date field. This way, you have to write formulas which might seem to a bit complicated, but once u grasp it , its easy and u may use it further for other stuff. Look at this link , it will greatly help you to see what i m taking abt..
http://www.youtube.com/watch?v=nz9LcymyjbY
Either way you can easily do what u wanted to do.