|
excell workbook and search function
|
[ New Topic]
|
|
|
| Regular Member |
  |
| 2759 Posts |
| a nice and warm kitc |
| in |
| Hong Kong |
|
| posted by Killer Tomato 130 days ago |
   |
Hi am using some very large excell workbooks now for inventory etc, is there a way to search in excell, it would make my life a lot easier instead of scrollling through 100's of pages to find one product.
and if there is where do i find this se4arch function?
Cheers
Marco
|
|
|
|
|
| Junior Member |
 |
| 1495 Posts |
|
| posted by Nasdaq_Index 130 days ago |
 |
There are few options Chef:
- Ctrl F - Use Data Fliter (under "Data" in your toolbar) - Vlook up (Function)
make sure you select all the tabs if you searching multiple sheets.
Remember! Respect is Earned not Given =)
|
|
|
|
|
|
| Regular Member |
  |
| 2759 Posts |
| a nice and warm kitc |
| in |
| Hong Kong |
|
| posted by Killer Tomato 130 days ago |
 |
wohoo ctrl F does it for me, awesome, thanks a lot!
|
|
|
|
|
|
| Regular Member |
  |
| 5834 Posts |
| movin along |
| in |
| Hong Kong |
|
| posted by The Crone 130 days ago |
 |
Nasdaq is one of the nicest guys I know
I dream again
|
|
|
|
|
|
| Junior Member |
 |
| 1495 Posts |
|
| posted by Nasdaq_Index 130 days ago |
 |
Thanks C. And you are the sweetest lady in town 
Remember! Respect is Earned not Given =)
|
|
|
|
|
|
| Regular Member |
  |
| 5834 Posts |
| movin along |
| in |
| Hong Kong |
|
| posted by The Crone 130 days ago |
 |
Aiya....thank You NI! I am grateful and it has certainly made my day
One of the reasons I constantly show my appreciation and gratitude is because I certainly feel it.
Yesterday I was reminded again how short life can be. My friend's 33 year-old body building, handsome young cousin, died unexpectedly. He'd always had asthma(spelling?), and never bothered with it much and it apparently got real bad.
I dream again
|
|
|
|
|
|
| Regular Member |
  |
| 4643 Posts |
|
| posted by geraldo 130 days ago |
 |
Crone, some actor back home once said:
life is a party, and I got a free ticket
There are 10 kinds of people. Those who can read binary and those who don't
|
|
|
|
|
|
| Regular Member |
  |
| 2674 Posts |
|
| posted by tiger lily 130 days ago (edited 130 days ago) |
 |
The ticket wasn't free ...............
When the power of love overcomes the love of power the world will know peace. -Jimi Hendrix
|
|
|
|
|
|
| Regular Member |
  |
| 2674 Posts |
|
| posted by tiger lily 130 days ago (edited 129 days ago) |
 |
If you didn't have to pay......that's because someone else paid it for you...
When the power of love overcomes the love of power the world will know peace. -Jimi Hendrix
|
|
|
|
|
|
| Senior Member |
   |
| 8971 Posts |
| in Bhutan |
|
| posted by Juno Watt 130 days ago |
 |
quote: Originally posted by Killer Tomato My arse is itchy. What cn I do abot it? If I scrathch it with my figners, which fingers shoud I use? Thnaks.
FFS chef!
|
|
|
|
|
|
| Regular Member |
  |
| 2759 Posts |
| a nice and warm kitc |
| in |
| Hong Kong |
|
| posted by Killer Tomato 130 days ago |
 |
Juno stop being a woman, dont twist my words! ;)
|
|
|
|
|
|
| Junior Member |
 |
| 1201 Posts |
| in |
| Hong Kong |
|
| posted by Britney 130 days ago |
 |
Tomato, you should hire a secretary. I am very good in data entry!!!
|
|
|
|
|
|
| Regular Member |
  |
| 2759 Posts |
| a nice and warm kitc |
| in |
| Hong Kong |
|
| posted by Killer Tomato 130 days ago |
 |
quote: Originally posted by Britney Tomato, you should hire a secretary. I am very good in data entry!!!
am i lucky i dont have ANY need for data entry
|
|
|
|
|
|
| Senior Member |
   |
| 8971 Posts |
| in Bhutan |
|
| posted by Juno Watt 130 days ago |
 |
Do you like double entry?
|
|
|
|
|
|
| Regular Member |
  |
| 2674 Posts |
|
| posted by tiger lily 129 days ago |
 |
tsk tsk....boy
When the power of love overcomes the love of power the world will know peace. -Jimi Hendrix
|
|
|
|
|
| Newbie |
|
| 39 Posts |
| Swingin Low |
| in |
| Hong Kong |
|
| posted by The Dogs Bollocks 129 days ago |
 |
quote: Originally posted by Juno Watt
quote: Originally posted by Killer Tomato My arse is itchy. What cn I do abot it? If I scrathch it with my figners, which fingers shoud I use? Thnaks.
FFS chef!

One country, no f*cking system.
|
|
|
|
|
|
| Senior Member |
   |
| 8971 Posts |
| in Bhutan |
|
| posted by Juno Watt 36 days ago |
 |
quote: Originally posted by Juno Watt Do you like double entry?
One for Beautyqueen maybe...
|
|
|
|
|
|
| Regular Member |
  |
| 2674 Posts |
|
| posted by tiger lily 36 days ago |
 |

When the power of love overcomes the love of power the world will know peace. -Jimi Hendrix
|
|
|
|
|
|