HELP pls..urgent

Bilaal xaka

New Member
Joined
Mar 7, 2021
Messages
10
Office Version
  1. 2013
Platform
  1. Windows
Hello everyone,
I need your help pls.
I have a workbook where there are 5 sheets, each sheet with 3tables, and every sheet has the same table size and column with same header at the exact cell number, but different data within each table.(pls find attached)
Is it possible than I sort all the 3 tables of all the 5 sheets (15 tables) in ascending order in cells C1, B16& I16 at one go?
 

Bilaal xaka

New Member
Joined
Mar 7, 2021
Messages
10
Office Version
  1. 2013
Platform
  1. Windows
Hey Zot,
Thanks. you are the best.
Hey Zot, suppose there are 30 sheets in my workbook, namely:
Sheet 1, Sheet 2,... to Sheet 30.
Sheet 1 to Sheet 25 is visible.
Sheet 26 to Sheet 30 is hidden.
And that I had to apply this VBA only on Sheet 1 to Sheet 20.
How can I modify this VBA? And do VBA affect hidden sheets?

Pls help. Thanks Zot.
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Zot

Well-known Member
Joined
Nov 26, 2020
Messages
1,174
Office Version
  1. 2016
Platform
  1. Windows
Hey Zot, suppose there are 30 sheets in my workbook, namely:
Sheet 1, Sheet 2,... to Sheet 30.
Sheet 1 to Sheet 25 is visible.
Sheet 26 to Sheet 30 is hidden.
And that I had to apply this VBA only on Sheet 1 to Sheet 20.
How can I modify this VBA? And do VBA affect hidden sheets?

Pls help. Thanks Zot.
The VBA code is placed in normal module, not under any sheet. You can call the macro program after you open workbook by pressing Alt+F8 and run the program you desired. It has nothing to do with whichever sheet is visible or hidden. The program will loop through all sheets and skip the hidden one.
 
Solution

Bilaal xaka

New Member
Joined
Mar 7, 2021
Messages
10
Office Version
  1. 2013
Platform
  1. Windows
The VBA code is placed in normal module, not under any sheet. You can call the macro program after you open workbook by pressing Alt+F8 and run the program you desired. It has nothing to do with whichever sheet is visible or hidden. The program will loop through all sheets and skip the hidden one.
ZOT,
Huge huge thanks.
Sorry for the lateness.
Got caught with a deadline at work
 

Watch MrExcel Video

Forum statistics

Threads
1,130,117
Messages
5,640,206
Members
417,131
Latest member
Seanr19871

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top