love your vids, straight to solving the problem, no bullshit, simply top 💖
@mikefleming4717
2 жыл бұрын
Ajay always with the good excel videos
@shaheerqazi3654
2 жыл бұрын
your videos are too good but there is one suggestion kindly try to explain the formula instead of their application by this we'll able to use them by ourselves
@louisvathan7171
2 жыл бұрын
Is there anyway we can do that in reverse? Value of a cell should be the sheet name. Even if I change that cell the sheet name should change. Love your videos btw.
@edwinmiranda4005
2 жыл бұрын
I don’t think a formula can do this but you can do this with VBA
@phpvbacoder9000
2 жыл бұрын
You can update a cell with the table name everytime you change to another sheet.. other events are possible see: Private Sub Workbook_SheetActivate(ByVal Sh As Object) ActiveSheet.Range("A1") = ActiveSheet.Name End Sub
@manojsrikanth8663
2 жыл бұрын
To get the answer, you must save the file first.
@pavankumar-ih2hg
2 жыл бұрын
You are amazing
@kajalprajapati7657
2 жыл бұрын
How to compile all file name data in one file name ...
@hamedalizadeh8782
2 жыл бұрын
Yea, my question too.
@Musical_Sweetness
2 жыл бұрын
What? This looks like a very well hidden. Secret of excel. I fin get it.
@theescanor8985
2 жыл бұрын
Too complications... But interesting
@phpvbacoder9000
2 жыл бұрын
Or vba Application .Active Sheet .Name
@HarpreetSingh1991
2 жыл бұрын
I be like ok..ok..ok..ok and you sir keeps adding function upon function.. 😔 just kd lolz thanks for short
@riush112
2 жыл бұрын
Can't you just type it. It seems like a lot of effort even if you had to change the name
Пікірлер: 16