urgent helped needed!

  1. B

    VBA - How do I cut and paste a row to another worksheet when 2 cells both say Yes

    Hello, I am very new to using VBA and don't really understand much at the minute. I am trying to get it where when the word "Yes" is selected in both drop down boxes in columns V & W, that row is then cut and pasted into the worksheet "Delivered". I then obviously want it to paste to the next...
  2. A

    Help!!!!!!!!

    I have data in excel as mentioned below Input 1a 1b 1c 4a 4b 4c 7a 7b 7c 2a 2b 2c 5a 5b 5c 8a 8b 8c 3a 3b 3c 6a 6b 6c 9a 9b 9c Output 1a 1b 1c 2a 2b 2c 3a 3b 3c 4a 4b 4c...
  3. R

    Import files into the excel with same prefix

    Hi Everyone, I am struggling to create a macro which will import all files from predefined folder having same prefilx. Kindly refer below for more details: C2 = ShareDrive link in which i have files Files Name = Sample 1.pdf, Sample 2.pdf, Sample 3.pdf I have below code by which i can upload...
  4. N

    Sumproduct issue

    Hello, Can someone help me with same... I am using Sumproduct funtion which is as follows: =SUMPRODUCT((F5:F19)*(E5:E19))/SUM(E5:E19) It uses values from two colums (one is the weight and the other the values 0 and 1) the formula work fine except if the Values column is BLANK. How can I...
  5. B

    Merge multiple workbooks

    Need help with vba code that should merge multiple workbooks into one workbook from a folder that the user chooses, but it should only merge the 1st sheet of each workbook. I found this code only it does half of what I need but I'm clueless about the rest. Scheme for macro working: 1st - Ask...
  6. M

    How to add rows to a new custom table based on values in other table? Options

    Hello, I'm stuck in one of the business use case where we need to add duplicate entries in a new custom table from the inputs given in other table. e.q. consider i have a table with Subscriber Effective_date Expiriation_date Service_Code Now i want to dynamically create a custom table...
  7. H

    Urgent Excel Help Needed Again!

    Hi Guys, I am trying to determine whether a combination of values contained in cells within one sheet exist in any row contained within another sheet i.e. are ALL of the values contained between cells A2-BB2 in 'Sheet 1' equal to ALL of the values in ANY row contained between cells AZ-BB2 in...
  8. A

    Move data to new sheet

    I am wanting to move select data to another existing sheet in my spreadsheet. Any that say "Yes" will need the first column data and the reason (last column) to be brought across to the other sheet. In this case the "Sad" and "Angry" data is not needed on the new sheet for the report. Example...
  9. W

    VBA Macro to Select range and copy paste to another sheet continuously

    Hi, I have a large data set over 200,000 rows but I would like to select a range i.e. A1-J2000 copy to another sheet then A1001-J2000 copy to another sheet? I was doing this manually but it will take forever does anyone have a simple code for my macro do this automatically without inputing...
  10. L

    How to extract numbers from text with specified and unique conditions

    <quote> I was curious if someone could tell me how to change this formula and add some properties. Such as: To ignore number strings lead by zeros, if an x is directly behind a + = - its counted as a 1 is extrated (or in the case of the - a -1), and if a - is directly in front of a number...
  11. H

    Creating a chart in excel

    Hi, i'm a very new user at excel and forums, so please be patient with me. I do reading tests, and would like to graph the results, I have a sheet with the name of the student on top with what text being tested on, which i guess will be the title of the chart, i then have the the date tested...
  12. E

    Returning Solver fail msg via VBA

    Hi All Could somebody tell me how to return solver err msgs like" no feasable solution found" via vba msgbox?
  13. L

    macro required

    Hi there, I have values in two columns A and C. I need to write a macro to copy the values in every 11th cell in both columns to a new worksheet. The first value in column A that I would like to copy is in row 32. So the subsequent values are in rows 43,54,65 etc. In column c, the first value...

Watch MrExcel Video

This Week's Hot Topics

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
Top