Automatically Update One Excel Worksheet from Another Sheet

[@brandonyan8107]

can you do this from one tab to another? not another worksheet

[@exceldemy2006]

Hello @brandonyan8107,
Yes, we can update data from one tab to another within the same worksheet in Excel.
Follow the steps to do so:
1. Select the cell in the destination tab where you want the data to appear.
2. Enter the formula: =Sheet1!A1
If you want to pull data from cell A1 on "Sheet1"
3. Press Enter, and the destination tab will automatically update whenever the source cell changes.
This method works similarly to updating from another worksheet.
Regards
ExcelDemy

[@VarshithaK-xc5sf]

What if I have more than one criteria, then what is the way

[@exceldemy2006]

Hello @VarshithaK-xc5sf,
You can use the AND function within the IF statement if you have more than one criterion. For example, if you want to check if the value in Employees!D5 is greater than 4000 and if the value in Employees!E5 is greater than 1000, the formula would look like this:
=IF(AND(Employees!D5>4000, Employees!E5>1000), Employees!D5, "")
If you want an exact formula you can share your dataset and criteria.
Regards
ExcelDemy

[@donnapearson]

Is there a way to do this across multiple workbooks, rather than worksheets within just one workbook?

[@exceldemy2006]

Dear @donnapearson,
Thank you for your question. You asked an interesting question, if there is a way to automatically update multiple workbooks? In fact, there are several ways and the process is similar as shown in this video. You can follow the article linked below to update the workbooks automatically.
Article link: www.exceldemy.com/link-excel-workbooks-for-automatic-update/
Hopefully, this answers your query. Make sure to stay connected with Exceldemy! 🎉❤. Have a good day.
Regards,
Exceldemy

[@yuktabitla6363]

How to filter in one sheet and multiple sheet gets filter?

[@exceldemy2006]

Dear, Thanks for such an exciting question. In this case, you can use an Excel VBA Event Procedure.
Don't worry! We have demonstrated your situation in a workbook and developed a sub-procedure that will be triggered within the Worksheet_Deactive event.
Please check the following: www.exceldemy.com/wp-content/uploads/2024/05/Filter-in-one-sheet-and-multiple-sheet-gets-filter.gif
You can download the solution workbook: www.exceldemy.com/wp-content/uploads/2024/05/Yukta-Bitla-SOLVED.xlsm
Excel VBA Code:
Sub HideRowsOnOtherSheets()
Dim ws As Worksheet
Dim wsMST As Worksheet
Dim lastRow As Long
Dim i As Long
Dim rng As Range
Set wsMST = ThisWorkbook.Sheets("Sheet1")
lastRow = 11
For i = 2 To lastRow
If wsMST.Rows(i).Hidden Then
For Each ws In ThisWorkbook.Worksheets
If ws.Name wsMST.Name Then
ws.Rows(i).Hidden = True
End If
Next ws
Else
For Each ws In ThisWorkbook.Worksheets
If ws.Name wsMST.Name Then
ws.Rows(i).Hidden = False
End If
Next ws
End If
Next i
End Sub
Private Sub Worksheet_Deactivate()
Call HideRowsOnOtherSheets
End Sub

[@TOM_M18]

is this possible to change one sheet data automatically changed to another sheet using vlookup function?

[@exceldemy2006]

Dear, thanks for your questions. Yes, you can automatically update one datasheet to another using the VLOOKUP function.
Please check this: www.exceldemy.com/wp-content/uploads/2024/03/automatically-updating-one-to-another-using-the-VLOOKUP-function.gif
To achieve this, you can use the following formula: =VLOOKUP($B$3, 'Employee Records'!$B$5:$D$13, 3, FALSE)

[@TOM_M18]

Thanks a lots for your reply... I will try it

[@TOM_M18]

Sir its bit work for me kindly guide me

[@exceldemy2006]

Dear, Of course! It would be great if you could share your difficulties within the ExcelDemy Forum.
ExcelDemy Forum: exceldemy.com/forum/

[@carlozabat5737]

How can i DM you? I want to ask something.

[@exceldemy2006]

Hello @carlozabat5737,
To contact with us you can mail us at: [e-mail]
Or, you can use ExcelDemy Forum: exceldemy.com/forum/
Here, you can post and share your problem also you can start conversation too.
Regards
ExcelDemy