First method worked perfectly for me. Thank You so much for the info ❤❤❤
@exceldemy20068 сағат бұрын
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
@314Tesla4 күн бұрын
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 !
@exceldemy20063 күн бұрын
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
@donnapearson10 ай бұрын
Is there a way to do this across multiple workbooks, rather than worksheets within just one workbook?
@exceldemy20068 ай бұрын
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
@brandonyan810729 күн бұрын
can you do this from one tab to another? not another worksheet
@exceldemy200628 күн бұрын
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
@yuktabitla63634 ай бұрын
How to filter in one sheet and multiple sheet gets filter?
@exceldemy20064 ай бұрын
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-xc5sf29 күн бұрын
What if I have more than one criteria, then what is the way
@exceldemy200629 күн бұрын
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
@carlozabat57372 ай бұрын
How can i DM you? I want to ask something.
@exceldemy20062 ай бұрын
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
@TOM_M186 ай бұрын
is this possible to change one sheet data automatically changed to another sheet using vlookup function?
@exceldemy20065 ай бұрын
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_M185 ай бұрын
Thanks a lots for your reply... I will try it
@TOM_M185 ай бұрын
Sir its bit work for me kindly guide me
@exceldemy20065 ай бұрын
Dear, Of course! It would be great if you could share your difficulties within the ExcelDemy Forum. ExcelDemy Forum: exceldemy.com/forum/
@pronobkumar280713 күн бұрын
Exclamation function is not working
@exceldemy200613 күн бұрын
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