This is a cool shortcut. When using macros, keep in mind the rest of tables have to be the same size and placement otherwise you'll error out and if you don't know how to edit the code then...yeah.
If you click into the table and then ctrl+a it will highlight the table no matter the size. Use ctrl+arrows vor navigation and ctrl+space / shift+space for highlighting whole column / row These are relative navigations and they will work also if the size differs…
You could also just select all sheets and make your changes. I love macros, but I think it would yield the same result without having to create a macro. Love your content. Keep it up! 😃
Recording a macro this way will result in a hard coded macro. Every he did will now repeat when he runs the macro no matter what workbook he’s in or worksheet. He didn’t change any text, only formatting. So as long as the next table he gets are all in the same cells it will work.
Does that work for data filtering too? For example at work we pull the work orders from a site for the whole group, then i want to filter out orders that are in "historical" state, and want to filter just my jobs. I'm assuming yes. Hopefully I remember to try it since it's a long weekend
When record a macro, after you name it, choose to store macro in "my personal macros" (not "this workbook"). When you finish recording the macro, save the excel file in order to save the macro. That's it! When you open a new excel file, will find the recorded macro under the tab developer - macros.
This is a cool shortcut. When using macros, keep in mind the rest of tables have to be the same size and placement otherwise you'll error out and if you don't know how to edit the code then...yeah.
You can use relative reference if the table didn’t start/end at the same position or had a different size
that's what i was wondering. what if a new worksheet has new added rows will this still work or is there a work around
@@hassanboussi8909how is that done..
If you click into the table and then ctrl+a it will highlight the table no matter the size.
Use ctrl+arrows vor navigation and ctrl+space / shift+space for highlighting whole column / row
These are relative navigations and they will work also if the size differs…
This is literally the best shortcut I have ever crated. Took 2hrs of work down to 10 minutes. And I have to do that every 2 weeks.
I used to work in corporate, knowing how to use macro, write code in excel, building auto tool in excel will “excel” you in your job
You can you format painter and just copy the sheet and paste it other. It will work fast for this scenario
Did I just see the data for THE OFFICE! Michael's gonna get mad😂😂
Or you can select all sheets and this formatting once. This is a great tutorial for creating a basic macro. Thank you.
add application.ScreenUpdating = False
and apply it to all sheets with additional code in VBA
I love to use this method as a base for my scripts
You could also just select all sheets and make your changes. I love macros, but I think it would yield the same result without having to create a macro.
Love your content. Keep it up! 😃
You're the best!!!
Invalid for different size -> Copy & Paste as Format should work.
How about selecting the sheets at once?...pressing control then select each sheet then edit one sheet automatically the rest copies the edits
Or by grouping sheets together and format one of them then all will same.
love yr contant 😍 keep going dude❤
Excellent
You’re going to have to edit the macro to accommodate changes in the table name, at the very least.
Recording a macro this way will result in a hard coded macro. Every he did will now repeat when he runs the macro no matter what workbook he’s in or worksheet. He didn’t change any text, only formatting. So as long as the next table he gets are all in the same cells it will work.
Disagree. This works if you’re exclusively changing formatting which he is
@easy_sheets- If we filter in macros base file sheet & do the changes, the same will not reflect in rest of the sheets?
You can make select and format , without macro
Will the shortcut work in the another workbook?
Love your videos 🫡 thank you
If any additional information to be add in that working sheet still the Recording Macro work correctly?
Cool
I love this. Genius stuff. Thank u!!
This guy took characters from office
Name it whatever you like, as long as you don’t like spaces!
😮👌
Does that work for data filtering too? For example at work we pull the work orders from a site for the whole group, then i want to filter out orders that are in "historical" state, and want to filter just my jobs. I'm assuming yes. Hopefully I remember to try it since it's a long weekend
Yes. Works for pretty much everything. you can add columns, make calculations, format, add filters, etc.
How do you unlock developer mode? Or is it always there I can't remember
How to do it in different workbook
How about format painter
I can save it right? So it won't be lost when I restart my pc
Will this work in google sheets
Isn't it better to do it in Power Query... Don't you have to save the file as xlsxm format? Which end up being untrusted doc...
👏🏽👏🏽👏🏽👏🏽👏🏽
Is the macro only saved to this one file, or is it retrievable from my 365 account?
When record a macro, after you name it, choose to store macro in "my personal macros" (not "this workbook"). When you finish recording the macro, save the excel file in order to save the macro. That's it! When you open a new excel file, will find the recorded macro under the tab developer - macros.
Brush solves it in a better way.
Dunder Mifflin :) :) :)
alg
Who saw Ohio?
Ohio