generate

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...

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...

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...

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...

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...

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...

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

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...

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

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...

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...

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...

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?

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...

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...

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...

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...

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...

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...

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...