+ Reply to Thread
Results 1 to 2 of 2

Vincular uma referencia de planilha em uma célula

  1. #1
    Registered User
    Join Date
    06-30-2021
    Location
    jundiai
    MS-Off Ver
    2016
    Posts
    1

    Vincular uma referencia de planilha em uma célula

    Bom dia, gostaria de uma ajuda com as referencias em uma planilha: Tenho a seguinte situação.

    Nas celulas da coluna A tenho uma lista com o nome de meus computadores

    PC A
    PC B
    PC C

    e cada célula possui uma aba da planilha com o mesmo nome, gostaria de fazer uma fórmula de referencia com o nome da célula para abrir a planilha ex:

    =IF(HLOOKUP(C$4;PC A!$C$3:$N$14;12;0)=7;"REALIZADO";"PENDENTE") >> no lugar da referencia de planilha "PC A" tem como eu indiciar a célula e ele navegar até a aba?

    Não sei se fui claro, mas gostaria de alterar a estrutura da formula para que ao inves de escrever o nome da planilha, eu colocasse a célula e ele entendesse que deveria abrir a planilha.

    No lugar de "PC A!" >> colocar algo tipo "A2" & ! >> para que ele executasse a fórmula nessa planilha de referencia, tem como fazer algo do tipo?

    Isso facilitaria no sentido de, tenho uma lista gigantesca de "PC" e para não criar planilha por planilha, se eu fizesse essa referencia diretamente com a célula, me ajudaria muito.

    Obrigado.

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    14,084

    Re: Vincular uma referencia de planilha em uma célula

    This is how the site translates the request:
    Good morning‎, ‎would like a help with the references in a spreadsheet: I have the following situation. ‎
    ‎ In the cells in column A I have a list with the name of my computers PC A PC B PC C and each cell has a tab of the worksheet with the same name, I would like to make a reference formula with the cell name to open the spreadsheet ex: =IF(HLOOKUP(C$4; ‎
    ‎ PC A!$C$3:$N$14;12;0)=7;" REALIZED";" PENDING") >> in place of the spreadsheet reference "PC A" has how i indict the cell and it navigate to the tab? ‎
    ‎ I don't know if I was clear, but I would like to change the structure of the formula so that when I want to write the name of the worksheet, I put the cell and he understood that i should open the ‎
    ‎ worksheet. ‎
    ‎ Instead of "PC A!" >> put something like "A2" & ‎
    ‎ ! >> for him to run the formula in this reference worksheet, is there any way to do something like that? ‎
    ‎ This would make it easier to, I have a gigantic list of "PC" and not to create spreadsheet by spreadsheet, if I did this reference directly with the cell, would help me a ‎
    ‎ lot. ‎
    ‎ Thank you, i'm ‎
    ‎ sorry.‎
    If I understand correctly then the following may work: =IF(HLOOKUP(C$4; ‎INDIRECT(A2&"!$C$3:$N$14");12;0)=7;"REALIZADO";"PENDENTE")
    If this doesn't work then please upload a small sample of the workbook using the instructions in the yellow banner at the top of the page.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Sending e-mail content Celula
    By anacleto in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-19-2015, 09:32 PM
  2. #Nome? em célula com a fórmula correta
    By Alambique in forum Non English Excel
    Replies: 2
    Last Post: 08-20-2013, 12:47 AM
  3. #Nome? em célula com a fórmula correta
    By Alambique in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-19-2013, 03:09 PM
  4. Referencia de las que estan a los lados de una celda
    By Megadoro in forum Non English Excel
    Replies: 1
    Last Post: 06-03-2013, 09:18 AM
  5. Planilha de Impostos Federais e Estaduais
    By Jemelly Rustom in forum Excel General
    Replies: 0
    Last Post: 01-28-2006, 10:10 AM
  6. [SOLVED] planilha excel
    By Othon Moraes in forum Excel General
    Replies: 0
    Last Post: 05-02-2005, 05:06 PM
  7. sou novato no excel estou tentando montar uma planilha para geren.
    By dino in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-29-2005, 02:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1