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
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
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
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
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)
Hello @carlozabat5737, To contact with us you can mail us at: admin@exceldemy.com 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
can you do this from one tab to another? not another worksheet
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
What if I have more than one criteria, then what is the way
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
Is there a way to do this across multiple workbooks, rather than worksheets within just one workbook?
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
How to filter in one sheet and multiple sheet gets filter?
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
is this possible to change one sheet data automatically changed to another sheet using vlookup function?
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)
Thanks a lots for your reply... I will try it
Sir its bit work for me kindly guide me
Dear, Of course! It would be great if you could share your difficulties within the ExcelDemy Forum.
ExcelDemy Forum: exceldemy.com/forum/
How can i DM you? I want to ask something.
Hello @carlozabat5737,
To contact with us you can mail us at: admin@exceldemy.com
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