generated

I am hoping someone can help. It seems like such an easy thing to do and I just can't find the answer anywhere. So, I would like to search a range of cells F2:F6 (APPLICATION) for the word "Yes" The word will be returned in multiple cells and I would like to copy the B2:B6 corresponding cell...

Hi We're looking at a basic licensing tool - it's going to be straight forward where someone inputs a licence code (generated from website) which auto populates a single line confirmation. I'm trying to see how I'd add this single line into a excel cell somehow, and then work with the string...

<colgroup><col><col><col span="3"><col><col><col></colgroup><tbody> Maximum Length 20 Product Information- User Input Generated SKU Code & Product Explanation Product Category Product Name Attribute1 Attribute2 Attribute3 Product Explanation Generated SKU Code Modified SKU Code SAS...

Hello Team! I am new to the forum though i use to regularly get help from the posts as a guest. I am hoping a question of mine would be solved:) I have a table with lot of data of opportunities in Pipeline from different departments in the organization, i want to get the Top 10 values based on...

I have generated thousands of lines of software using macro 4.2 in Excel V5. This is business and accounting software and was produced on a G3 Mac. I have transferred it to G4, G5, Power Mac and (the latest) iMac. I have also generated other software in macro 4 which runs successfully on all...

Hi everyone! Could anyone tell me how it is possible to sort random numbers (without repetition) between a range of 1 to 20 million? Basically I need to enter the drawn range into two cells (minimum value and maximum value) and display the number generated in another cell. Would there also...

Hi everyone Hope you can help. I am using a button to run the below code which prints specific data to a PDF, though first it checks to see if cell M21 is blank. If it is then it prompts the user to warn them if they want to proceed or cancel. If they proceed or if cell M21 is NOT blank then...

I am trying to generate a random Date and Time in excel but I need to remove the volatility out of the Randbetween function. The formula I an currently using is as follows: =RANDBETWEEN(--"2019-03-17",--"2019-04-29")+RAND()*("0:59"-"17:00")+"1:00" But by using this function the generated Date...

Hi, I have a VBA program to mark the application no which is generated sequentially. There are multiple worksheets for different types of application. The workbook is shared to be updated by a group of people. The sequential no is a counter stored in one of the worksheet, counting no of...

I run a window cleaning company and use Excel for accounting. I have a page that has all my customers. There is a column that has the month which shows the month their windows are due to be cleaned again. On my dashboard, I want to show all the customers due to have their windows cleaned for...

Dear Friends and Respected Seniors, I have a chart containing a Line Chart Series and an XY Scatter Chart Series. Data for Line Chart is from A1-B9 and data for XY Scatter Chart is from A11-B19. Data from A1-B19 is <tbody> Line Data 1 #N/A 2 84 3 55.7 4 67.5 5...

Hello I generated a macro through the recorder and it generated the following code: ActiveCell.FormulaR1C1 = _ "§ 4,795.............. What does the =_ mean? Also, is it possible to use multiline text/code for the ActiveCell.FormulaR1C1 ? Thanks!

Hi, I have this If a = 56 Then b = session.findById("wnd[0]/usr/ctxtAEDAT-HIGH").Text How do I get the session.findById("wnd[0]/usr/ctxtAEDAT-HIGH").Text part of the sting to run as normal code, since it comes now out of a sting?

Hi, I'm using Excel 2013 and maintaining a table which logs changes to one or more fields. The table below illustrates an example of bonus/salary/rating that could be adjusted during the project. The "O-" prefixed fields are a lookup to the original load-up data in another table. The values...

Hi All, I'm not sure how to do this so hoping you can help I have a button on an excel form and when you click it, it send an automated email to someone to say they approve the document. What I would also like is for it to put the date they clicked the button and their user name into...

#VALUE! Error I have an Excel spreadsheet in which a random number and a blank is generated for a Numerator for a Fraction in Column F and a Denominator is generated in Column G using a formula based on the number which is generated in Column F. When I attempt to generate the resulting value...

Hi I am compiling a slicer based dashboard on working days lost due to sickness. I have generated a pivot table with all the necessary data I need from one single source. However, when I have generated my slicers, I have one for AWDL (days lost) and this only shows individual totals. Is there a...

Hi, I've been struggling with a formula all afternoon, and am in desperate need of help for my own sanity. I have a workflow system which automatically generates references. The system will generate a reference which is always prefixed "GOC-" and then will be followed by 6 numbers. The...

Hi All! I used VBA to create conditional formatting rules for a range of cells, but when I ran the macro there was no change to cells that should have been formatted. I checked to see if the code generated the rule and it did so it should have worked. What's really strange is that after...

Hello, I just need your help regarding my concerns too. I have a macro code that works in my laptop but not work in others laptop. I've instructed them to check these settings in their Trust Center.... Macro Settings - check-mark the "Enable All Macros" Macro Settings - check-mark the "Trust...