Formatting Macro

[Cardan]

Hello,

I posted this in Commercial Services but did not get a response.

I am somewhat new to macros and have one I thought would be simple. I tried recording the macro but quickly found myself out of my depth.

I have multiple sheets with data in table form. Each sheet has the same exact headers (headers are in the range A10:AE10) but the number of rows vary.

The formats for each column vary from General, Accounting, Number, Date etc, and may change in the future.

I am in need of a macro that can go into specific sheets and reformat the range of data in the columns based on the format of a specific range of cells in another sheet.

I have a master range, on a sheet I named “Master”. In cells A1:AE1, Here is where I have set my formats. (I figured it would be easier to change the formats here if things change)

The macro will apply only to the tabs that start with a "T" or "J" (The J sheets are the "Job ####" sheets of the attached)

It will then go to first sheet, find the range of data below the header (starting in A11 and going to AE?? since number of rows will vary), and format the data based on the formatting of the range from the Master tab (cell A1 format from the Master will equal the format for column A in the sheet)
It would then apply a thin, solid border around the whole range and “dotted” borders within the range. (I am not sure how to describe the varying levels of borders, but it is the one directly below “None” on border selection).

It would also have the ability to hide columns, say H, L, & P columns for this example.

Once complete, it would move to the next sheet until all sheets that start with a J or T are formatted.

There is another macro in the workbook called JobCodeOutput that the macro may be able to fit into. I kept my request as a separate macro not to confuse the issue.

Any suggestions?