row

  1. T

    Macro to pull all amounts into a message box or userform and ask me which ones to edit etc

    Hi Everyone, I have a list of direct debits, sometimes I need to edit or adjust the amount i'm paying for one or more of them for that month I need a macro that can ask me which ones I want to change and by how much and then add reduce the following months amount by that amount? So here in...
  2. M

    How to make a row auto populate

    Hello, Thank you in advance for your help! So I would like to have a separate sheet for certain data that is entered in another sheet, but all located in the same book. Is there a way to do this? For instance, if the text in cell D2 matches a certain criteria, then excel will auto-populate...
  3. R

    Want conditional formatting to reset after column filters are used

    Using the formula=MOD(ROW(),2)=1 to have every other row have color to make it easier to use a large spreadsheet I have. When I change the column filters the rows are no longer colored every other row obviously. Can I alter the formula at all to have it reset when filters are added? somehow use...
  4. D

    formula for count unique?

    Is there a formula that counts unique values in a column. I'm creating the data in col a and col b with vba Existing output ColA ColB ColC User1 10.10.10.10 10.10.10.10 10.1.1.1 10.1.1.1...
  5. U

    Inserted row above total is not included in total. Any solution would be welcomed!

    I have a worksheet with a list of properties. Every time an expense is added to the list it goes on the last row for the property, just above the total. I welcome any kind of solution either a worksheet formula or a VBA solution that would insert the new row and update the =SUBTOTAL( and =Sum(...
  6. D

    Formula being deleted

    I have a spreadsheet that has a table in it with a formula in a hidden column for the table. I have a button to delete the records but if the row is highlighted and delete button pressed on the keyboard, the formula in the hidden column will be deleted. Is there a way I can add some vba code to...
  7. K

    Bowler Chart for KPI using sorted merged cell

    Hi. I know this is possible bc my intern was able to do it but now that I'm trying to replicate it....I can't seem to figure out how he did it. Before everyone asks about changing the format, etc. it is not an option. We use a "bowler" chart which tracks the plan vs actual for key metrics...
  8. Trevor3007

    find many based on a certain criteria

    good evening, I hope someone can help me? I have a workbook sheet 2 contains lots of data.... I would like to be able to find anything on sheet 2 that contains a specific word ( ie Adobe) This would than display the data on sheet 1. A bit like vlookup, but vlookup as you are aware only picks...
  9. D

    How to copy multiple rows using If

    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need to replicate this for the 19 rows beneath this. Do I need to Keep writing the same code for each row or can I write a code to cover all the rows...
  10. T

    User Function returning #Value

    Hi All I am currently using the below function to show if a row is hidden or not, when i first use the function it works perfectly but as soon as i unhide/hide a row all the values change to #VALUE . What am i doing wrong? Public Function isvisible(rng As Range) isvisible = Not...
  11. O

    Conditional Formatting based on Multiple Conditions.(With vba)

    Hi. All i am using excel 2016 i have a worksheet with 100 columns and 5000 rows.. in my data a column heading "Balance in repeating after 4 columns .like Column e, column J........ i want to create a rule for conditional formatting which applies only in column which having Balance, Means...
  12. K

    Select range from active cell to copy to other sheet.

    Hello, I have a code that will activate in a set range where the words "complete" are changed. I would like the active cell to select that row, however only from columns B:AB. All i have found is how to select the entire row. Private Sub Worksheet_Change(ByVal Target As Range)If...
  13. D

    VBA delete last row help

    Hello everyone. I am trying to piece meal my VBA where I need it to select all sheets in the workbook and delete the last row in each sheet. Each sheet has the same headers but varies in row so as long as it is the last row being deleted it will work. Any pointers would be greatly...
  14. I

    Code to work to specific row and not whole row

    Afternoon, Working code in use shown below. Currently this code operates the whole of column B where i would like it to stop at the last row. So currently my last row with data in is row 19 BUT then i also see the message if i type in row 369 where at present its empty. Basically find last row...
  15. T

    Help copying data and transpose from one sheet to new sheet

    I have an issue. I told my wife I could write a script for this. Well its a bit out of my range. I thought it was easy but its not for me because I dont do this enough. I have a spreadsheet and lets say I need to copy A2, D2, and E2 to another sheet 20 times but I also need to transpose the...
  16. A

    Workbook_SheetChange event

    I need pivot tables to refresh automatically once a user enters new source data. I have my workbook set up on monthly tabs and the users can enter data below row 12 on each of these tabs. I have set up the workbook with dashboard/display tabs at the front and the monthly data sheets at the...
  17. C

    Grouping Rows

    Hi all, I want to group rows in blocks of 2 rows at a time. For example...row 1 & 2 would be a group. row 3 & 4 would be a group. so on and so forth. I want to use the 1 & 2 button to open and collapse the groups. I had it before but can't for the life of me remember how to do it again. I have...
  18. P

    Moving a Row with a negative value to another sheet

    Hi! Hoping someone can give me some help here. I have a spreadsheet for tracking jobs and work hours. I have a sheet to archive projects to have a running track of all of them. I'm looking for a way to move a whole row from my working sheet to the archive sheet when the days from job reaches a...
  19. H

    Pull results from a defined column region and list one instance of each in another cell

    Hi. I've got a list of names in Col G from row 14 down. Users add the name or names of the owner/s of the associated task described on that row. VBA allows the user to enter more than one name in the cell as sometimes two people are involved on a single task. What I'd like is to have a...
  20. A

    CopyPaste copying headers

    I have the below code copying data from multiple worksheets on to a master worksheet without the header row. It works fine if data is entered however if no data is entered on a sheet it copies the header row. How can I change it so that the header row is always ignored even if it is the only...

Some videos you may like

This Week's Hot Topics

Top