bottom

  1. D

    Copy Paste two rows to two separate areas on another sheet

    I have Excel 2013. I need a macro that will do the following. I have two rows that need to be copied to another sheet, say "XXXYYY" at the bottom of different columns, in the first unoccupied row, depending on the name in cells C7 and C8 Row one occupies A7:J7 Row two occupies A8:J8 If the row...
  2. T

    VBA help with time results

    Hi Everyone, I am trying to create a spreadsheet to work with my timer. At the moment my timer is ok and i can lap it and send the data to the active cells. My issue is that the amount of rows is varying. I write a number in the first column from one to however many i have. Im a bit stuck...
  3. J

    VBA Code to Work down a list, calc a result, add result to bottom of new list

    Hi All, Any help here would be appreciated greatly. CODE SEQUENCE 1 Copy Item A from List A 2 Paste flat to B2 3 Recalculate the result to update C2 4 Copy range B2:C2 5 Paste flat to bottom of List B 6 Goto next cell on List A Repeat steps 1-6 Stop at bottom of List A...
  4. A

    Converting a formula to excel/google sheets

    Hey guys, I have something I need help with. I need to convert the following formula into an excel formula. Any help? I'll be honest, I don't fully understand this, it's from a website which converts football actions into meaningful statistics. The post is here...
  5. N

    Userform inputs to overwrite entries if they're duplicates

    I have a spreadsheet with a userform used to add entries to a mapping table of items. There are four fields which need to be input and once done the entries are appended to the bottom of a table. What I need to do is get the code that inputs the data to look for a duplicate entry for the first...
  6. 1

    Count streak of alternate 1 and 0

    Hi, I have ones & zeros in column C. Is there a formula that will show me a streak of alternate ones & zeros like at the bottom where there's six in a row? Thank you! <colgroup><col width="64" style="width:48pt"> </colgroup><tbody> C 1 0 2 0 3 0 4 1 5 0 6 0...
  7. D

    Measuring distances with vba

    Can you use vba to measure distances in excel, such as between any given row at the bottom of the current page?
  8. D

    where is properties window vba?

    hi, i cant find it? i pressed f4 and it's not showing. also, before it disappeared, it was "free flowing" and not locked as it usually is at the bottom left corner? how do i lock it? (first i need for it to show up, my first issue)
  9. J

    Average last 5 non-blank cells

    <tbody> 1 1 0 1 1 0 </tbody> Hello there, My goal is to get the 60.00% but what formula would I use to exclude blanks and only consider the bottom 5 values? Thanks!
  10. S

    vba help with vlookup

    Need some help with vba to handle vlookup from one sheet to another in same workbook. Standard formula in cell U2 to bottom of dart =VLOOKUP($E2,'Ampacet Pricing File'!$C:$F,4,FALSE) I need to lookup E2,E3,E4, etc. to bottom of data on sheet 'Upload' to sheet 'Ampacet Pricing File' columns...
  11. C

    VBA command button to insert row at bottom of table using active.cell

    Good evening, I have a table that sometimes i might need to add a row to. I need this row to insert at the bottom of the active cell and still hold the formatting and formulas from the row above it, without the contents of the cell. I did a record macro as i got fed up trying to figure it...
  12. danhendo888

    How to fix these dates?

    https://1drv.ms/x/s!AvjBsEPEq12ngTwwKMwIFJo5_Tk7?e=J87rl6 How best could I go about fixing this column so that it shows dates. The bottom half is in text format. Thanks all.
  13. D

    Variable in Ranges

    Among many inexplicable problems is this. I recorded a macro to sort a spreadsheet using Column A as the first key. The pertinent code that Excel generated is ActiveWorkbook.Worksheets("CurrentWines").Sort.SortFields.Add Key:=Range( _ "A2:A237"), SortOn:=xlSortOnValues...
  14. S

    Pivot Table problem

    Hi All I am having a problem with a pivot table which I need help with please. From the data table below I want to get the bootom 5 values but exclude the blank cells from the cvount in the pivot table. The pivot table below shows them as 0 and includes them in the bottom 5. Data Table...
  15. K

    Excel cursor

    This is the most ridiculous that I have to ask but do any of you know how to get the hovering cursors back? Meaning the plus icon at the bottom of a cell, or the width arrows between columns!?! They disappeared and I don’t know where they went!!
  16. B

    top 20% formula

    hello i have a range of data in column A, A2:A159, i am trying to find out the average for the top 10%, top 25% middle 50% and bottom 25%. is there a formula i can use for this, example below <tbody> Column A Column B % Growth Start Balance 32.78% $100,700 16.52% $122,245 </tbody>
  17. A

    Headings Row 1 Text alignment

    Width is set to 45 and col names are centered. Somehow I've managed another effect which I can't repeat. The names are vertically aligned so they're about 1/16 of an inch above the bottom of the cell. Not bottom, centered, or any other setting offered by the Alignment tab (Format Cells). Any...
  18. F

    without VBA Auto Name Tab based on cell

    Hello Everyone I would like the sheet tab name at the bottom of the sheet to Automactially name = to cell F2 So if Cell F2 = "date" The sheet tab name at the bottom of the sheet will be named "date" Macros is disabled at my working station. So, I was trying to see if this is possible. Thank...
  19. C

    Counting Values Backwards!

    Alright folks!! I have searched and searched for this and I have found no solution to my problem anywhere on the interwebs! So I have a list of data, simply just rows of numbers say, 2 3 7 4 4 0 1 2 0 3 42 1 I am trying to find a way for excel to start from the bottom of the data and count...
  20. M

    Formatting a Dynamic Bottom Row

    I have a range B5:R8, and there is command button that inserts a row where at the active cell. I've figured out how to preserve the formatting for the top row B5:R5 but I can't figure out how to format the bottom properly. Currently if you select the last row (R8) and Insert Row, a thick outline...

Some videos you may like

This Week's Hot Topics

Top