multiple cells

  1. D

    Data transfer from one sheet to another multiple cells

    Good day, I am trying to create an auto-generated log on a new sheet that is based off of data entered from a previous sheet. What I am wanting is when a single cell on the master sheet is modified (in this case a choice is made from a drop down list), a copy of certain cells in that row would...
  2. D

    Data transfer from one sheet to another multiple cells

    Good day, I am trying to create an auto-generated log on a new sheet that is based off of data entered from a previous sheet. What I am wanting is when a single cell on the master sheet is modified (in this case a choice is made from a drop down list), a copy of certain cells in that row would...
  3. G

    scattered data import into on worksheet

    I have been researching the solution to this problem for several days with no results that match my problem. I am hoping it is possible and I have come here in hopes that someone will know. I am using Excel 2007 but have access to Excel 2010. My boss has been using an Excel sheet as a template...
  4. B

    Combining Cells in One Column Based on Another Column

    Hi - I am hoping someone might be able to help me with this problem. I currently have a spreadsheet that has 4 columns. I want to review the information in column A and if it matches, I want to combine the cells in column D into one cell for the matches in column A. Here is an example of the...
  5. P

    Running Event Handler Change with Multiple cells

    Hi Members After a couple of research I was able to make the code below, where basically I need the macro to run either the change happen in cell A5 or G23, but when I run it I got "Ambigous Name Deteted" error. Also in the same worksheet I have another Worksheet Change event, so I don't know...
  6. A

    Conditional Formatting for a row using data in multiple cells

    Hi there, I'm trying to color a row of data based on the data in multiple cells. To be specific, I want to color Row 2 red when J2 is blank AND when any of A2-I2 are not blank ( (so either A2, B2, C2, D2, E2, F2, G2, H2, or I2 are not blank) . Then I want to apply this to the whole document...
  7. C

    separate values from 1 cell to 2

    I've searched for the answer here and have come to the conclusion that I do not know the correct terminology to aptly search my question. Uploaded here is a sheet that shows our product line, UPC codes, description, etc. In row 2, 3, 4 I've edited to the correct format that I need the rest of...
  8. W

    Vlookup with multiple cells

    I have a sheet containing work tasks and associated hazards: <TBODY> Task1 Hazard 1 Control 1 Hazard 2 Control 2 Hazard 3 Control 3 Task 2 Hazard 4 Control 4 Hazard 5 Control 5 </TBODY> For each task there may be up to 6 separate hazards. In a new sheet i want to select the Task...
  9. O

    Conditional formatting, multiple cells

    Hi, I'm setting a rule in "Conditional formatting Rules Manager": Formula: =$D3="hello" Format: color change Applies to: =$A$3:$J$3 I'm trying to set "Applies to": =$A3:$J3, but its just changing to =$A$3:$J$3 when I apply. That means I cant copy/paste that cell. I want D4 to have...
  10. A

    Formula to incude multiple requirments in different cells

    Hi, I would like a cell to show either OK or No depending on the requirements of three other cells as below G4 is the cell to show a value. For OK a date in G6 must be more than todays date, a tick must be in F6 and a date in D6 must also be more than todays date. I can get G4 to do each...
  11. S

    Macro to name ranges based on the value of two other cells

    Hi, I know it should be simple enough, and I have seen many similar Q&As on this sort of topic. But I couldn't find one that solved it for me, and I couldn't work it out by myself. VBA is not my strength (yet). I want to name hundreds of ranges. I don't want to type the name myself. Ideally I...
  12. N

    Need to sort file so that cells that have a certain column blank come first

    I have an Excel file with about 30,000 cells in it. Here's an example of what the file looks like here. And I need it to be sorted like this. To explain further, If someone's name(B) or plan number (A) has blank cells AND additional names under the "Beneficiary Name" column (F), I want these...
  13. D

    Question about Tables ?

    Hi, I am creating a spreadsheet to track customers contact information and purchase history. A B C D 1 First Name Last Name Phone Number Etc. 2 Mike Jones 3 I wanted to know if theres a way to click on a customer (say Mike...
  14. L

    VBA to search Multiple Cells for Multiple Values in Multiple Rows to Compare and Add missing Values if Necessary

    The issue I am having has me perplexed and I can't seem to get it right. Maybe I have just been looking at it too long. I have a list of cells that are item numbered. These item numbers range from 1000 - 10000. Each item number contains data relevant to that item. What I am trying to do is...
  15. P

    help with multiple worksheet_calculate on same sheet_mail with outlook

    Hello, This is my first time using macros; and I gotta say, it is very interesting and fun I have found out, but I am stumped. I searched all over this forum for hours looking for a way to run multiple worksheet_calculates on the same sheet. The code below shows a specific cell triggering an...
  16. O

    Returning All Values that occur when a loookup should see multiple items in list

    Hi I'm trying to run what I might call a "multiple vlookup" so something like this happens: <tbody> A B 1 12 Green45 2 45 Green36 3 95 Green48 4 12 Green71 5 12 Blue10 6 12 Blue92 7 95 Red84 8 45 Red63 9 45 Red88 </tbody> [On another sheet] When I have a value "12" in a...
  17. A

    IF Multiple Cells to give a set response

    Hello long time reader, 1st time poster:I have a spreadsheet which uses =F to give set responses i.e. Cell H35= =IF((G7-G35)=0,"No Issue",IF((G7-G35)>=1,"System/Paperwork do not Match",IF((G7-G35)<0,"System/Paperwork do not Match",))) I want a cell that will display "Issue identified" when...
  18. G

    Sort out lists with VLOOKUP

    Hello everybody, I would like to let excel sort out two lists for me with item ID's, revisions and last saved date. i think it's possible with the VLOOKUP function but i don't know for sure. Please look at the example below and let me know if it's possible to do this by excel formula's...
  19. A

    Find text string Across Multiple Cells in a Row

    Hi, I want to see if a text string is contained in any the text in any cell in a row i tried : =FIND("gift",A3:U3,1) Did not work. I tried defining a name for the range and putting it where there range is in the formula, also did not work. Any ideas for doing this in a formula ? I feel like...
  20. P

    Insert values into multiple cells

    Hi Guys, Hope you can help me out with a problem I am having, still fairly new to VBA! I have a User form with a ComboBox "SKUNumberComboBox" which has a list of SKU Numbers and I have a Date Picker "DTPicker1" were I can pick a date and I also have a TextBox "ExtraDaysTextBox" were I enter...

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