generate

This one has me stumped so I thought I'd reach out for some help. I have three columns of data like this: <colgroup><col style="width:93pt" width="125" span="3"> </colgroup><tbody> X 0 0 X 0 0 X 0 0 0 0 0 X 0 0...

Hello! I'm using Excel 2016. I have a large worksheet with weeks and days spanning a year. Each week is divided into days and and each day has initials to plan which person goes where at each day. What I want to do is build a second worksheet where I choose the person (initials) and hit a...

I am trying to use a Random Number Generator to test a worksheet I am developing. I have been using the expression shown below with success to generate a number between 1 and 63 to put in a cell. =TRUNC(RAND()*(64-1)+1) However, I would like to test this cell with a random number between 0...

Hello I have downloaded a General ledger and I am trying to form a manual trial balance of the chart codes within it using a couple of criteria. My quick solution to creating a trial balance is to generate a pivot table and utilise the chart code column and amount column and then report filter...

Sorry for the confusing title, but not sure how else to word it. What I'm looking to accomplish is the following.... At my work, we have to audit an employee's cash drawer on a monthly basis. To prevent each employee from knowing when each audit will occur, the selected dates have to be...

Hi, I want to make 50 tables (matrices) with 150 numbers each. The numbers should be randomized either a 0 or 1. I first thought i would create a 10 by 15 matrix: - Generate a random number between 1 and 150. (for the amount of 1s in the table) - Generate a random number between 1 and 10...

So im currently using 0\:00 so I can just type 706 and it changes it to 7:06. How can I make it add 12 (military time basically) so that when I type 706 it will generate 19:06.

Hi, I would like help with coming up with a formula which will help me generate 5 two digit number groups.. yes, this is lottery related... lol..... anyway, say I have a number list, which could vary in length, starting in A1 and could go down as many as 40 numbers. the numbers in the list...

Hi, I have created a stock inventory sheet for ten product in MrExcel podcast 1505 auto next invoice.I want to reduce stock automatically when generate invoice. Just like auto postregister podcast 1808. Thanks in advance

I have a sheet with 8 columns and 5 unique words in each column - 1 word per cell. How can I generate all of the possible combinations by taking only 1 word from each column to generate a lost of 8 words. Is this even possible? I am above average with basic excel but have not used macros or...

Hello, for something I am doing for my work it would be very efficient to be able to use control down to the next 2000th cell instead of scrolling down to it. If anyone knows how to generate a value in those cells please consider replying, I would really appreciate the help. I would like to...

I am trying to generate a product of multiple cells (each cell is 2 cells merged into 1 larger cell) but only if the cell is greater than zero. I cannot seem to generate a table to show what I am trying to accomplish and I cannot seem to insert a picture either. Here is the formula that I...

Hi, can someone help me with the following : let's say I have a variable and let's make it =4 for this example I need to have a formula that will generate the following rows : 1 2 3 4 3 2 1 2 3 4 3 2 1 .... and so on... Any ideas ?

I am trying to create a very simple Excel macro in Office 2013. The macro should create a line chart with titles on the x and y axes. I go to the "Developer" tab and select "Record Macro". I create my chart and everything looks fine. When I view my auto-generated VBA code it looks like the...

I need to generate sequential numbers to serve as individual customer ID numbers, and these numbers must first reference a three digit number derived from the customer's zip code. Example; there are two 3 digit codes, 503 and 504. These are derived from zip codes. I need the formula to...

Hi, I have created an input page for report cards including drop-down menus for A,B,C and D grades. I'd now like to create three buttons which allow me to: 1. generate reports onto new sheets with a) all the common information on every sheet, including the school logo, and b) all the...

I am trying to make a spreadsheet that generates all possible player combinations that meet the requirements. The criteria are a 6 player lineup, each player has it's own individual salary, and a $50,000 lineup salary cap. I narrowed down the player pool to 20 players and each lineup must...

Hello, I am trying to create a spreadsheet for financial analysis. Please see document link below for the example document. https://1drv.ms/x/s!AgcnhTO-WExMgWFKuV2TGVFPNUxD End result, I want a Macro template to generate formulas based on various criteria. I want to be able to tweak this...

hi i wolud like to know if anybody can helpme to create a formula that shows the row number of the repetition os a number or word or somwething on a column like in "find and replace" when you click on "find all" there appears a sheet with the cell name,info, etc there is one part that is like...