[VBA] Print template with different cell value

longcong01

New Member
Joined
Aug 10, 2020
Messages
1
Office Version
  1. 365
Platform
  1. Windows
Hi everyone,
I hope you're all safe and healthy during the outbreak.
Also more importantly, I hope you all can help me with this query.

In the photo #2, as you can see I have several equipment tabs looking similar to one another.
Photo #1 is the "Schedule" tab which is the list of name of equipment.
I need to print the equipment tabs with:
- Cell E6 (of each tab) to be automatically filled base on the "Schedule" tab A2 downwards; and
- Only print if column B of "Schedule" tab match the equipment tab name (because activity of each equipment tab are different to one another).

This is absolutely out of my league.
Please help whenever you have free time.

Much appreciate in advance,
Allan.
 

Attachments

  • 2.PNG
    2.PNG
    89.5 KB · Views: 13
  • 1.PNG
    1.PNG
    63.8 KB · Views: 13

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Forum statistics

Threads
1,215,226
Messages
6,123,734
Members
449,116
Latest member
alexlomt

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
Back
Top