pick

  1. C

    Inserting text from another tab

    Good Morning, I have an events spreadsheet and would like to do the following. The tab with the information is called Events Notices as follows: <tbody> SUBJECT LINE FULL NOTICE 50's Sock Hop Toss on your bobbi socks & poodle skirts then head down to where DJ (this needs to pick up the...
  2. L

    I need help with a pick them worksheet

    HERE IS FILE https://1drv.ms/x/s!AnJwxxiz0Ezpg8d44doit5nmxCco9A?e=eQrtdJ HERE PICTURES https://1drv.ms/u/s!AnJwxxiz0Ezpg8oVBr3hJUzW5V6eeQ?e=Scigt5
  3. B

    Looking up data in other worbooks

    I have a table where I have to draw data from a number of workbooks While the table is across multiple columns, it is between rows 2 and 201 So in cell AB2 I have this formula =VLOOKUP($A3,[Trap12.xlsm]Squadding!$K$3:$P$202,2,FALSE) This is the formula I tried to pick up the variable which is...
  4. L

    can excel help pick out top choice?

    let say i have a group of kids that get to pick out their three favorite toys. Because the number of toy available is limited, only the kids with he highest grade get their #1 choice 1. the rest get their 2nd or 3rd choice depend on their grade and availability. <tbody> kids grade # 1...
  5. S

    How to pick 1st word

    Hi I want a formula to pick 1st word from the sentence , please help Jack & Jill = Jack Please come = Please Gross Margin = Gross
  6. O

    Help: Raffle Name Picker 250 Prizes, 0 Duplicates with Multiple Entries per Person

    So I am looking to pick 250 unique winners for a contest. The contest will have 10k-20k unique users. Each user is able to enter multiple times. How do i Pick 10 unique users for 1 prize How do i Pick 240 unqiue users for 2nd prize If your name was picked for any of these prizes it needs to...
  7. S

    Return maths anser whereby numbers in A and C and symbol in B

    Is it possible to have Excel do an equation whereby, in Column A you have a number, Column B you have a +, -, *, / etc and in Column C you have another number. I have tried a simple =A1&B1&C1 etc but this only pastes as texts and does not pick it up as if you entered that into a cell So I have ...
  8. S

    Pick detail of specific GL account with details

    I want to bring transactions of specific account 10001 from GL dump need help please. I have 25 columns which all I needed, given below 5 as sample GL dump Date | account| Description | amount | remarks 01/01/19 | 10001 | expense | 100 | ABC 02/01/19 | 10002 | income | 200 | CDE 03/02/19 |...
  9. A

    How to split text string in

    Hi Awesome people, I need help please. What the formulato use if I wanted to split text. For example <colgroup><col></colgroup><tbody> 19,BMW,G02-X4,G02 - BMW X4 xDrive20i I wanted to use formula just to pick up G02-X4? Thanks AA </tbody>
  10. L

    Help with data validation question

    Get file below is link https://1drv.ms/u/s!AnJwxxiz0Ezpg8YaJybiTFXDUaN6tQ I have sheet call BYE WEEKS I have data validation with no repeat name after you pick team will not be there on rest data validation list. when you pick a team list start at end of list how i fix this that drop list...
  11. D

    e-mail macro

    hi i have set a distribution list on a sheet... garg, dwight maloney, tony when i run the macro my PC...its fine...but when my colleague runs it, it doesn't pick up the names correctly even if he manually clicks "check names." any idea why?
  12. H

    Hide Rows based on Cell Value

    Hi - I have a drop down in A3 on sheet1 that lets you pick 1-3. if you pick 1: rows 10-30 hidden, 2: rows 20-30 are hidden, 3: no rows hidden. Thanks!
  13. J

    Excel - using Index and Match - adjusting the Match function's array input

    This is a complicated question to ask and I am not sure exactly how to ask it. I am attempting to make a pipe sizing tool to speed up one of my work processes. The procedure is pretty straight forward. Do some math to figure out GPM going to drain (done elsewhere) and then look up the pipe...
  14. S

    Automatically change hyperlink

    Hi, I have a hyperlink I use and there is a cell I manually enter to put a client's names. As a result the hyperlink concatenates this to form the hyperlink. However, the directory is going to be split from A-L and M - Z. Is there a formula that can pick up the first letter of the client...
  15. P

    Looking to expand a VBA Macro / Pick random cell from column

    Hey All, So, I have a list of items in a column, that I'd like to randomly pick from. I have a very basic routine, that picks on, and highlights the column a based on what it picks. But, I'd like to be able to randomly pick, but if it's already been picked before to not pick it again, I'm...
  16. K

    Macro code, cell Data to pick from TAB name

    hi, I need a macro code where specific column has to pick from TAB name. For Ex: excel sheet tab name "PRIME J654". Data in Column M in same sheet as " J654- GOODS INTAKE" 1.Now, if I change the name of TAB to "PRIME J655", Then data in column M has to pick the last four characters...
  17. Q

    How to make Vlookup formula only a specific numbers in a range of data

    Hi, Below are the numbers from which I want my vlookup formula to pick only the first 3 digits. However, if there is a "0" in the beginning of the formula, I'd like it to only pick the next 2 digits after 0. Could you please help me in this formula assessment. Currently, I've used the...
  18. C

    Help editing VBA code to pick 3 names randomly from a list of names

    Hi all, I'm trying to write/adapt some VBA code that can pick 3 randomly pick names from a list. The must not pick the same name more than once. I have a master list of names in column A. I have used another piece of code to pick a subset from this column (based on a separate criteria). This...
  19. D

    If Cell A1 is blank move to A2 and Perform multiplications

    I have googles and test share amount of formulas but going nowhere. I have some blank or non Blank cells in same Column. I am looking for formula if A1 is blank, it can move to A2, pick the amount and multiply it what is in C2, but if there is value in A1, ignore A2 and multiply A1 to C1. I...
  20. A

    Urgent help needed! Create list from data of length entered into UserForm

    I'm still very new at vba and I'm learning by doing, but this is way over my head. I've attached a link to my mock data. It is a item request list. One group of people adds to detail of the item in the first section (green in the workbook). The second group of people then pick up the item in...

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