1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. J

    Hide rows in range when value in COL A = 0

    Hi All, Need some code to do the following. For a range of rows from Row 10 to 50000 Hide any row where COL A has a value = 0 Many thanks....sorry for such a numpty question. James
  8. P

    Find last used cell within For Each Loop

    Hello! I am yet to figure out how the following works, but use it all of the time to find the last used cell in a column and offset 1 row: .Range("B" & Rows.Count).End(xlUp).Offset(1, 0) = Cel.Value I am trying to apply the same logic to the following: Cel2.Offset(0, 5).Value =...
  9. S

    Formula to copy row A down?

    Hi I need a formula that will copy the data is the first row of AFGIJKLMNOPQR down the sheet, as far down as long as there is data in column C? Can you help?
  10. E

    Prevent deletion of last row of excel table

    Hi folks I have an Excel Table with names and abbreviations of names (two columns only). I would like to prevent users from deleting the header row and last row in the table. <tbody> Abbreviation Surname and Initial PM Masters, P JL Leonard, J JM Matsau, J TOTAL 3 [given by...
  11. N

    Copy only part of last row that has data

    I have this code: Range("A" & Rows.Count).End(xlUp).EntireRow.Copy Range("A" & Rows.Count).End(xlUp).Offset(1).EntireRow.PasteSpecial It copies the entire last row that contains data and pastes it one row below. I only want it to copy part of the row, columns A to I to be exact. How do I edit...
  12. C

    Conditionally insert rows

    Dear MrExcel, I need to insert rows based on certain numbers and I need your kind help and assistant to help me out. I have 2 columns, A & B A is containing value (string) B is containing value (number) If the value in column B = 1 then no inserting rows But if the value in column B <> 1...
  13. M

    Nested If in VBA Macro

    Hi Could you please help me to fix the below formula in column and its drop down (by increase cell count) till the last row in the VBA Macro =IF(C2<2,"0-1 Days",IF(C2<3,"1-2 Days",IF(C2<4,"2-3 Days",IF(C2<6,"3-5 Days",">5 Days")))) at the drop downing Column C has to increase...
  14. D

    Copy Cell contents to previous row.

    Hello I'm looking for a macro that will copy cell contents of column E into Previous Row as it shows in this excel sheet in my google drive sheet. " From bottom Up check for column E if it find blank cell then copy that row into above row. E.g in this sheet in column E cell e15 is blank so the...
  15. K

    Random Highlight only 1 in the each row

    Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> I need a VBA, which can highlight 1 character out of 1X2 in the each row so far each time 14 total are selected within the 14</SPAN></SPAN> Example.. <b></b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px...
  16. 5

    Splitting Row Data

    Hey, Currently this pulls the data in one row Ary = Application.Index(wb2.Sheets(4).Range("A8:U17").Value, Evaluate("row(1:10)"), Array(1, 3, 4, 7, 13, 14, 15, 16, 17, 18, 19, 20, 21)) Ws.Range("A" & L).Resize(10).Value = wb2.Sheets(4).Range("D3").Value Ws.Range("B" & L).Resize(10).Value =...
  17. B

    excel vba sheet name

    Hi i would like a vba that does the flowing if my seventh character from my sheet name begins with a "4" then delete row 12 from the sheet if not continue to the rest of the code Thanks
  18. D

    Conditional copy and paste, then delete row

    Hello all, Bit of an amateur trying to learn more on the use of Macros. Hoping for some assistance with this issue: I want to be able to search through my data to find rows where Column D displays "Negative".If it doesn't display "Negative", just move on to the next row. If it does display...
  19. T

    Macro to change amount of next bill and carry it forward

    Hi Everyone, Ok so a bit of a strange one i'm doing a Billing cycle that shows how much is owed but i need to be able to adjust the amounts and could do with a macro to help. So I have three ranges we take to take into account. AC10:AC26 is my indicator for what we are goig to change. Z10:Z26...
  20. H

    VBA Selection

    Hello Friends, Is there a way to move the selection to the second column of that same row. Like if the selection (target cell) is lets say column H32 then I would want the code to make the selection to B32 or if the selection (target cell) in on A15 then i would want the code to make the...

Some videos you may like

This Week's Hot Topics