Automatically Update One Excel Worksheet from Another Sheet

[@blenkomulti-services8790]

First method worked perfectly for me. Thank You so much for the info ❤❤❤

[@exceldemy2006]

Hello @blenkomulti-services8790, You are most welcome. Glad to hear that the first method worked perfectly for you. Your appreciation means a lot to us. Keep learning Excel with ExcelDemy! Regards ExcelDemy

[@314Tesla]

hello good sir. I am wondering is there a way to change the format (like colour or font) of a cell and then u can see that to the linked cell? or the paste link command is only to update the value ? Thank you !

[@exceldemy2006]

Hello @314Tesla, You are most welcome. The 'paste link' command in Excel only updates values between linked cells and doesn’t transfer formatting such as font, color, or borders. If you want to reflect formatting changes in linked cells, you'll need to apply the same formatting manually or use conditional formatting to automate some styling based on the values. Unfortunately, Excel doesn't natively support automatic formatting updates via links. You can use this VBA code to copy the formatting from one cell to another whenever the source cell changes. Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Me.Range("A1")) Is Nothing Then Dim wsSource As Worksheet Dim wsTarget As Worksheet Set wsSource = ThisWorkbook.Sheets("Sheet1") 'Source sheet Set wsTarget = ThisWorkbook.Sheets("Sheet2") 'Target sheet wsSource.Range("A1").Copy wsTarget.Range("A1").PasteSpecial Paste:=xlPasteFormats Application.CutCopyMode = False End If End Sub 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

[@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

[@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

[@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

[@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

[@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/

[@pronobkumar2807]

Exclamation function is not working

[@exceldemy2006]

Hello @pronobkumar2807, It seems like the issue might be related to the sheet name rather than the function itself. Please double-check if the sheet name is correctly set to "Exclamation" in your workbook. If the sheet name is different, you may need to update the sheet name accordingly. =Exclamation!D5 =Your Sheet Name!Cell Reference Let me know if that resolves the issue or if you need further assistance! Regards ExcelDemy