1. G

    Converting individual rows into individual files

    Hello everyone, I have an excel file that I would like to split in individual text files per row. I have found a similar function from the VUTOOLS package, however, I do have a mac and unfortunately, I cannot make use of this convenient extension. I am not very proficient in excel coding, so...
  2. R

    Format copying not working

    This is my full code Sub StripData() Call InsertData Call FormatData 'Call DragData End Sub Sub InsertData() Dim myWb As Workbook Dim myRowsToCopy As Range Set wbtemplate = Workbooks("Template.xlsm").Worksheets("Raw") Set formatrange = Range("B2:CE2") Set formularange = Range("AK2:CE2")...
  3. M

    Redesign excel format

    I have the following spreadsheet with about 2000 rows, ABCDEFGHIJKLMNO1Ref No(s)TitleEff DateATAComments2TEST 1B737 ADVERTISING PLACARD INSTALLATION25Referenced By: TEST3ParagraphMethod Of ComplianceRLifeLast ComplE/D O/RideLimit/ IntervalF/ LNext DueRemain4Initial Issue...
  4. A

    Copy multiple columns from one worksheet to another with different rows in each worksheet

    Hi, I'm new to the board and a newbie to VBA. I tried different approaches found online but seems none of mine works. So here is my questions: I need to copy 5 columns from Worksheet A to Worksheet B. The columns in worksheet A and B have different rows: let's assume wsA has 20 rows and wsB...
  5. M

    Formulas between work sheets

    Thank you in advance for any help provided. I am looking to produce a work book with numerous tabs, but for this example I will just focus on two work sheets. First work sheet I have columns A,B and C populated across serveral rows. Second work sheet I have the same columns however in each...
  6. G

    how to limit rows and columns with VBA?

    I have several sheets that have hidden rows and columns but on occasion I need to unhide them. This usually results in a freeze/crash of the sheet due to the volume of columns being unhidden. How can I limit the number of both rows and columns to something like 15 and 50, respectively?
  7. M

    Consolidate Rows Question

    Hello- Hopefully an easy question. Have a large dataset where there are two rows for each Group & Category. Is there's a way to consolidate as in the example below? ABCD1Current2GroupCategoryBaseline_CountFollow-up_Count3Age Group65 to 69 years254Age Group65 to 69 years275Age Group70 to 74...
  8. Jyggalag

    Please help me wrap up my IndexMatch formula (90% done)

    Dear all, I am currently having some issues with a mix of IFERROR, INDEX, MATCH and TRANSPOSE and ROWS formula in Excel: I have the current sheet of data: The formula and the data links to this test sheet of data: Now I have done about 90% of the work (I hope), seen as my...
  9. E

    Hide - Unhide

    Hello All: Looking for some VBA to do the following: I am routinely hiding and unhiding rows 5 through 15 on a number of worksheets in one workbook. Would like some code that when run would hide the rows if unhidden -THEN- unhide the rows if hidden. Will assign to a button thereafter. Thank...
  10. A

    Looping file range

    Hello all, I'm trying to figure out how to do this properly, but making functional loops seems to be my VBA Kryptonite. I have this code: Private Sub CommandButton2_Click() Sheets("Summary").Range("A1").Value = FEP.TextBox1.Value AllBanks End Sub that takes the number entered into the...
  11. K

    Combine rows, add values in spec. column

    Hello, I have just started with VBA and I need your help. I've attached a picture and I will try to explain my problem. In "lastat"-sheet, I will add stock/pallets that I will move to another warehouse. With "Move"-button i move numbers to "Lagersaldo"-sheet. This warehouse will use...
  12. M

    Copy/paste values if the cell next to it is empty every month

    Is there a way i can copy paste specific rows to the excel ark. The things i need: - copy paste e3, e4, e9, e13 and e15 from mappe2 (book) to mappe 1 (book) - has to copy the value in the given row if the cell next to it is empty - the macro has to be applied from mappe1 (book) - next month the...
  13. J

    Show information Issue

    Hi Guys, I hope I can explain myself clearly . I have a user form, what I want to do is: Type a name, (let's think that I have 3 people call Jessica but with different last names), when I click in search, I want to be able to see displayed the 3 names Jessica inside the list box The sheet name...
  14. G

    Command button to fill in cells in a column

    Hey good folk, I have a timesheet i get my engineering dept to fill in, we have a lot of customers who's name they have to input when working on a design. The "short" name our ERP system uses is noting like the actual customer name and my guys sometimes get confused. Anyway i have created an x...
  15. B

    Sum of vlookup in multiple rows with condition

    Hi, Let me try and explain what I need with a simplified example: I have a table (H3:I5) that gives me the value for each item (I have dozens of items in the reality). I need, for each month (in B9, C9, D9), to know the sum of the value of each item for the particular month... but only...
  16. E

    Adding rows moves Pivot Table without data

    Never encountered this problem before. Have a file, tried to add new rows but it moves the Pivot Table down (like I expect it to) but leaves the data that was in the Pivot Table in the original rows... Thought something was amiss with the file itself so I created a new file and tried to...
  17. L

    Power Query - Append Grouped Rows based on specific columns AND row values

    Hi! My data set has 117,000 rows and 14 columns. It is at an item and week level. There is a week column, an item description column, 11 columns of characteristics that describe/classify the item, and finally the value column (cost). Is it possible, via M code or otherwise, for me to group by...
  18. S

    Formula to return a sorted list, eliminating values already returned

    Hi all, I have a giant database of NBA players and their NBA 2k ratings, what I'm trying to do is automatically pull them into team lists: To get the starting 5 I use this formula in column C...
  19. S

    SQL Help - Duplicate IDs

    I have the 2 tables below: Table1 ID Start Date End Date ABC123 01/04/2020 13/09/2020 DEF456 03/01/2020 17/02/2020 ABC123 15/09/2020 30/09/2020 Table2 ID Start Date End Date ABC123 17/12/2019 12/07/2020 ABC123 13/07/2020 11/11/2020 DEF456 07/07/2020 09/09/2020 DEF456...
  20. M

    Extract and return a rows values and cells list which contains alphabetical texts

    Hi, Required a formula help to Extract and return a rows which contains alphabetical text, and return a list wise cells values which contains alphabetical text as based on data specified in column(B4:E8) desired results enclosed. Thanks for the help...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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
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 "".
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