link between sheet

Hello, I am having trouble with creating a hyperlink between two dynamic points. Sheet 2 is updated with new data every night. Sheet 1 is a smaller subset of the data, that also gets updated every night based on the data from sheet 2. The idea is to click on the project id on sheet 1 and it...

Hello Everyone, Need help to link data from one sheet to a different sheet. For example, i have following data in Sheet 1 and Sheet 2: Sheet1 Cell B1 Value = A Cell B2 Value = B Cell B3 Value = C Cell B4 Value = D Cell B5 Value = E Cell B6 Value = F Cell B7 Value = G Cell B8...

Hi , I have a excel workbook which has 60+ sheets. In that I have a common word in column A say name "SAM" in all 60 sheets but in different rows in different sheets. Example if Sam name is there in A4 in sheet 1 means in sheet 2 it might in A3 and in sheet 3 it might be in A2,etc.. Against...

I have a workbook that currently has information that will go to 2023 that I will be using for reporting purposes. I am trying to set up an automated workbook to have an automated tab that when information is inserted on the 2020, 2021, 2022 or 2023 tab (formatted as a table) that it inserts the...

Hi Everyone, Im trying to create a form on excel that will automatically update specific information onto a master spreadsheet. I am issuing multiple forms with the same format. Sheet 1 is the master sheet used to track all the forms that are being issued. When adding a new sheet I need a blank...

Hello guys, I have an issue. I have a Sheet 2 with formula references in another Sheet 1. The issue is related with deleting rows in sheet 1, because in sheet 2, in the other cells, on the right side of the formula references, there are written informations. Practically when I delete a row in...