logo elektroda
logo elektroda
X
logo elektroda

Find Specific Company Name in Excel 2007 Tables Across Multiple Sheets: Address, Kg, Prices

lukasqqq 61886 2
ADVERTISEMENT
Treść została przetłumaczona polish » english Zobacz oryginalną wersję tematu
  • #1 7934182
    lukasqqq
    Level 14  
    I have a file made in office EXCEL 2007 I have as many sheets as the month has days and in each of these sheets there is a table with information about the address, kg, prices, everything is added up etc ... this is what I need to do after opening such a file without browsing each sheet and using the so-called find option for all clients in it,

    I will enter, for example, the name of the company that is located in an unknown position in a given sheet and that the program should indicate where this word is ...
  • ADVERTISEMENT
  • #2 7934210
    Jasiek690
    Moderator on vacation ...
    I don't understand what the problem is. You press "Find" or [ctrl + F] a window opens for you, enter what you want to find and search for you. There you will have an options button and you can change whether to search inside the workbook or sheet.
  • #3 7934250
    lukasqqq
    Level 14  
    Well, I meant I would find it if this version had a menu and she does not have it and there is not too much up there thanks to the problem solved
ADVERTISEMENT