autogenerate

  1. bobby786

    Auto assign number with +1 If meet the condition given

    Hi all experts , i have workbook in which i need to maintain the orders and producer of the product. My Goal: COL C Producer ( if its new product and not enter before in the above COL , then it should auto assign Invoice number in D6,D7,D8 as "ORD#1" , if its 2nd time then "ORD#2" , 3rd time...
  2. C

    Autopopulation

    I manage projects. I have a Workbook with a master sheet i named details. I want excel to populate a sheet called savings every time i change the project status on the details sheet to Completed. is there anyway to do this?
    • Chaddyb
    • Thread
    • autogenerate details seperate sheets sheet time
    • Replies: 11
    • Forum: Excel Questions
  3. M

    =(HYPERLINK) to auto generate list of links to another worksheet and display friendly names

    I am not conversant with VBA so I want to use the =(HYPERLINK) feature to generate a list of links in Column A of my 'JOBLIST' worksheet with each row in Column A linking to Row 3 of every third column in a range of successive worksheets named 'Jobs_000_050'. 'Jobs_051_100', 'Jobs_101_151' etc...

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