triplicate

  1. A

    Printing invoices in original, duplicate, triplicate in excel

    Dear All I use the following VBA code to print Invoices using a confirmation box on excel Sub Print1() Dim Answer As VbMsgBoxResult Answer = MsgBox("CONFIRM", vbYesNo, "Run Macro") If Answer = vbYes Then ActiveSheet.PrintOut Copies:=2, Collate:=True End If End Sub I want to print 3 copies i.e...
  2. Z

    Convert quarterly rows into monthly rows

    I have a table called master that has records stored at a quarterly level ie. each record has a fndng_dt=1Q2017, 2Q2017, 3Q2017 ect. I need to take each record and triplicate each record with the same data and stamp the appropriate fndng_mo_dt based on the fndng_dt field. For example, a row...
  3. A

    highlight triplicate and quadruplicate values (but not duplicates)

    Hi, I am trying to figure out how to format cells with triplicate or quadruplicate values my spreadsheet should always have duplicates, but never more than that. (the column I want to format is column "E") I am hoping to do this with conditional formatting as I dont want to add another...

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