sample

This VBA formula is working perfectly, but I would like to be able control, the amount of numbers (in the case of bellow VBA formula is 28) to be random, from designated worksheet cell, for sample A1. The same refers to choosing the Range (which in this sample is 6) to be able to control from...

Hello, We have a form that our buyers use to fill in data that we then save a .csv and import it into indesign and create a sign based off the entered criteria, everything goes to where it should yada yada. I want to know if its possible based on the entered criteria to show a sample sign to...

Scenario - I have 10 employees, who complete 10 sales per day. My data refreshes each day, so it's just prior day information. I would like to randomly pull 1 transaction per employee to perform an audit. I am comfortable creating a random sample, but not applying a one per user idea.

Hi! I'm not sure if I can attach a file but here is my sample data: <colgroup><col span="2"><col span="2"><col span="2"><col><col><col><col></colgroup><tbody> Early For Class On Time Late For Class Grand Total % on time Person A 2438 535 546 3519 84% Person B 127 41 17...

Good afternoon, I am trying to create a Macro to add a blank cell in-between line. Every month when we do this there is no way to know how many lines we will have. Manually doing these I do the following: Number the cells next to the date and auto fill all the way down. Copy the numbers. Paste...

Hi, How do I write a code to replace cells that contains "0" in column A with the word at the top row of each 0 group? <tbody> AD 0 XX 0 XX 0 XX 0 XX AC 0 XX 0 XX DE 0 XX </tbody> Above is sample table and below is the output that i wish to obtain. <tbody> AD XX...

Hi, May I know how to write a code to delete the entire row when there is "{" only in column A? <tbody> Column A Column B Row 1 { XX Row 2 {AB} XX Row 3 { XX Row 4 {CD} XX </tbody> From the sample table above, i would like to delete row 1 and 3. I would be so grateful for your help.

Hello, I am trying to implement within a macro blow how to identify the position of the first alphabetic letter a string and take all values before that letter. This is a part the macro below: If xsplit Like "*,*" Then For I = 1 to 100 'line below where I want to do that Sheets("x").Cells(I,1) =...

Hai, still study on this. Is it possible to send multiple email to same user based on cell value in excel through looping process. Pleasure if anyone can share your knowledge with me about it. In one sheets(combination all department listing that need to loop to send email as per department...

How can I find the sum of the values in columns 1-3 if column A equals Yes, column B equals FC, column C equals LE? This is just a sample set, the dataset I'm using has many more columns. Thanks. <colgroup><col width="64" style="width:48pt" span="10"> </colgroup><tbody> A B C D E...

<tbody> 5 5 2 10608 2 2 2 3 4 5 10607 1 1 1 3 4 5 10606 4 2 4 5 5 2 10605 4 5 3 4 4 3 10604 2 3 5 1 2 1 10603 4 5 4 4 1 2 10602 5 5 3 3 4 5 10601 5 4 2 5 3 4 10600 4 3 4 1 5 5 10599 5 4 1 2 2 5 10598 2 4 5 4 3 2 10597 3 1 3 2 3 1 10596 2 5 1 5 5 1 10595 2 1 5 2 5 2...

Hi, I am very new to writing macros and am hoping someone with more knowledge and experience can help me! I want to write something that will essentially replace the find and select function between two worksheets. I have a pivot table with sample numbers in column A on a tab called "Test on...

Hi, For now, I am cleaning all list manually and taking long hours to . Here are the sample list and sample results Blackledgedblackledge@riverhillsbank.com Vanderhoffmvanderhoff@franklinloans.com Stanwixastanwix@greenwaldindustries.com Smithjacques.smith@greatwesternbank.com...

Hello everyone, I am very new to VBA so excuse me if my problem appears to be trivial for some of you. Let me explain the situation : I have a table consisting of 96 columns and 160 lines. I have been measuring things in triplicate, so each three columns are concerning the same sample (A B C...

I'm having trouble adding a column to my pivot table that indicates what % of sub-items are not blank. For example: I would like to get the value in D2 (10%). It's calculated by taking 1-90% (C3). This value indicates that "Sample Item" sold with another item 10% of the time. Data...

Hi there, I am trying to find the number of non-repeated (unique/frequency) family names in each grade. I have prepared a sample and uploaded to one drive. I would appreciate it if someone could help? https://1drv.ms/x/s!AgQdYsSdg735fXy_R4rJuVlmcuw

<tbody> Base FINAL STATUS DATA 1 DATA 2 DATA 3 Apple ok Orange no Mango sample Banana no </tbody> Based on the table above. I would like to know how can I merge the data from columns DATA 1 to DATA 3 into the FINAL STATUS column. Like the TABLE below. <tbody> Base FINAL...

Hi, I have a scoring system that I would like to display text in a cell base don the score. For example, should the score be between 0 and 1.5 in A1 then this text will display in B1. "This is a sample text". Should the score be between 1.6 and 3 then different text will display in B1. Hope...

HI I have a table that looks as follows <tbody> customer # and invoice number note 1 note 2 AA~123 SAMPLE 1 SAMPLE 2 AA~456 SAMPLE 3 SAMPLE 4 AA TOTAL SAMPLE 5 SAMPLE 6 BB~789 SAMPLE 7 SAMPLE 8 BB~111 SAMPLE 9 SAMPLE 10 BB TOTAL SAMPLE 11 SAMPLE 12 </tbody> my goal is to put in...

Please help, Skus are in column A, Color is column B, All I need is if column B =Satin Bronze remove 10 from the end of the sku of column A There are about 15 finishes so I will need to edit for each one but thus is the best wat to get to the base sku's. In the sample row 1 is Satin Bronze and...