generate

  1. T

    vLookup Generation

    Hello, I am trying to create a macro to copy/paste a generated vLookup formula using a user selected range ("Reference Data") and with the following criteria: - The table array starting column needs to increment by 1 until it reaches the 2nd to last column of the user selected range, but the...
  2. C

    Number generator - custom without duplicating within different sub categories of master

    This might be a bit of reach but our ERP software will not allow us to define multiple numbering conventions in order to use intelligent data modifiers. These are crucial to help control product flow without having to constantly reference the text descriptor. The most we can currently do is...
  3. H

    Sendkeys methods to work for range

    Hi! This is my first thread on this forum, hope you understand me and help :) I am working with excel for my personal project. I would to make a macro_button which changes formulas/text for hyperlink. I have tried many options with sendkeys in macro but still have same problem. There are my...
  4. P

    Generate Unique Number

    Hello To All, Need Formula to generate and apply unique number for "Import" or "Purchase" to create a sequence series. For export i want to apply original unique number which i can find by index & match. Attaching Table for the reference. Thank you in advance...
  5. C

    Generate related lists of products that have similar attributes

    We have a list of products in column A. Each product has its set of attributes in column B. The task is to generate a product with its 6 related products (in column C), which have similar attributes to that product, sorted by similarity. Similar attributes mean that the products share a...
  6. M

    Need to make multiple copies of shift report with different dates in the name of the xlsx file.

    I am a lead maintenance mechanic and trying to figure out how to create dated shift reports. Our naming system is (Master file is named "Shift Report.xlsx") Shift Report 7-16-2021 D1 Shift Report 7-16-2021 N1 Shift Report 7-17-2021 D1 Shift Report 7-17-2021 N1 etc... I have to generate these...
  7. H

    Date / time conversion to dd/mm/yy

    I have a column of dates and times downloaded from a CSV file formatted as text as: 2019-10-10T08:30:47+00:00 Please could you generate a formula that converts the first part into: 10/10/19? Many thanks HT
  8. T

    Generate next requisition number in sequence

    Hey Excel Guru's -Looking for a little help with VBA code. I'm generating a requisition number on a form and each time I save the file I need excel to generate the next number in line. The below code partially works, but when I get to a certain number it keeps increasing the number of...
  9. J

    Histogram graph

    Hello We use a product that generates an histogram on a PDF I would like to generate a mirror image of the report but I also need help to generate an histogram graph. How can I show you how the reports looks as I can't post images
  10. kelly mort

    generate 4 - digits pin of same characters or digits

    I want a way to generate any of these numbers at a time: 1234 0000 1111 2222 3333 4444 5555 6666 7777 8888 9999 I have this line below here which can check for the availability of those pins . I have been staring at it for a while now hoping to find a way around it but no success yet. I need...
  11. B

    Generate Weekending date

    Hi All, I am doing Visual Basic and would like to know how i can convert this statement to return the weekending date. The result will only give me a count of days from sunday to the date on transdate.value but not the weekending. WE.Value = Weekday(transdate.Value, vbSunday) Please help me...
  12. H

    Auto-generate sequential numbers

    I am working on a project where I need to have item numbers auto generate into a table, once the user fills in a specifc cell in the title with a number (eg. Site Review No. 2) and the item list would auto generate 2.1, 2.2, 2.3 in the below table. Is this possible? I have searched online and...
  13. E

    Tracking

    Will Excel keep track of invoices? Example; I generate and invoice and the next day i generate another, will excel store the info and add them up to track income?
  14. C

    VBA to Export data into Word and generate PDF report

    Greetings my fellow Excel enthusiasts, I am hoping someone here can help me develop a code that will export data from excel to a word template, generate a report/proposal and attach it to an email in a pdf format. I already have the code to generate the proposal but can't seem to figure out the...
  15. J

    MS access - generate query visually

    Hi all, Has anyone, or does anyone know of a access db, whereby the users through the guid can select the tables that they want, and a query can be built accordingly. I am trying to create an interface whereby some of the tables are know (so for example give me all the customers that have...
  16. R

    How to generate random numbers by a given mean and standard deviaton

    Hello, Im looking for a way to generate random numbers when my standard deviation and mean are fix. So i used google and YouTube and there are many tutorials. (Like this: https://www.extendoffice.com/documents/excel/2472-excel-random-number-mean-standard-deviation.html ) The problem is: every...
  17. A

    Create Printer Error for testing purposes

    I have written an error handler for a "print" command button. The button prints several reports based upon the form with the "print" button. My code is to generate a VbRetryCancel message box if there is an error at the printer. I need to be able to generate something at the printer that...
  18. D

    Excel Solver Question

    Hello- I am stuck on Excel Solver question. I have 4 decision variables used to determine thresholds for items to stock in warehouse. From a list of of all items, by changing these variables in any combination, I can identify new opportunities to generate incremental revenue. I have a binary...
  19. L

    Distribute known numbers into columns using VBA

    I have 2 set of numbers that I would like to mix them. My first set contains 15 numbers that I would like to combine with a set of 10 numbers and distribute them into colunms. From the set of 15 numbers, the code will choose 9 numbers (randomly) and combine with 5 numbers from the set of 10...
  20. N

    Auto generate sales ledger from invoices

    Ok So this is the first time I've used a forum so please be patient. I want to generate an invoice in Excel which will update to the next Invoice number when I save it. Also what I need is each time I use a new Invoice I'd like it to be transferred into a Sales Ledger but only using certain...

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