bottom

I have a Spreadsheet with 13 Tabs. Each month and a YTD. On each month lets say I have columns.... Hours...Revenue...Average (there is actually about 35 Columns of Info) I enter the data each day. At the bottom there is a row for monthly totals. I want to Transfer the Monthly Total Row to...

Hello, I was hoping someone here could help me out. I have looked on the web, but do not seem to know what I should exactly be looking for. So here goes: I have a pricelist with part numbers that I receive an update to quarterly. sometimes price will be updated, and sometimes new products are...

Have a bottom in my workbook. I want to identify which macro has been assigned to the bottom. I right click it and say assign macro....however this is not the macro which is assigned to the buttom...

Hi I'm trying to select a range in VBA (from cell A2 to M2 down to the bottom of the range of data), but the Sub is going to the bottom of column A instead of selecting the range. Can someone please clarify why? I used this code: Sub R1() Range("A2:m2").End(xlDown).Select End Sub

I am running Excel 365 on Windows 10. I recently created a workbook that has a summary page for about 100 sheets. Each sheet has a link to this summary page. I hid all rows at the bottom of the summary page for aesthetic purposes, and noticed that it increased the size of my file by about 2mb...

Hi all Is it possible to create a macro to delete the last rows from the bottom of the worksheet with a different date? In the example below I would need it to select and delete from rows 1161 to the end. The data will always be in column A and there will be multiple dates (probably 7 or 14)...

Hi everyone, Below i have attached table , from which i need to search for a column through column name and when it finds that column it should perform some tasks like 1.It should divide by 12 from all the values which are found 2.Only that column should be copied and pasted in another new...

Hi, I want to sum n values in sheet 2, if the same rows in sheet1 it's the bottom n values. For example: <tbody> Sheet 1 Sheet 2 A 8 A 1 B 3 B 15 C 2 C 14 D 7 D 3 E 10 E 4 F 1 F 20 G 4 G 7 H 5 H 6 </tbody> So in this case, if n=3, the bottom 3 value are F, C, B. So...

<tbody> A B C D 2 1 19 2 7 3 12 4 1 5 16 6 Target 3 7 0 8 </tbody> Kinda backwards! How do I create a formula to paste down column D, which highlights the first value over 10 in column A - but coming up from the bottom of column C I'm trying to use LARGE...

Hi, I have below macro that create boxes and I need to show only the bottom borders of these boxes, can anyone help me with that? '''BUILD THE eCnt LABEL BOX''' ew = galaxyF.Width / 2.3 eh = galaxyF.Height / eCnt el = galaxyF.Left et = galaxyF.Top + (eh * (e - 1)) Set...

Hi, I need to start page numbering from say 41 and so on, which need to be displayed at the bottom of each sheet i.e at the footer. please guide me how to do this. Regards

Hi I put the following formula into a blank cell. =A5*-1 and it converts from a negative to positive figure. I always thought that if I was to click on the bottom right of the cell I put the formula in it copies the formula all the way down the worksheet but it dont? Any Ideas? Thanks

If I have a column where some cells are blue and some are white, I want to start at 1 and increment by 1 only when the color changes in the cell below it. If a cell changes colors again, I would like to increment by 1 again all the way to the bottom of the column. Could someone point me in the...

Hi Mrexcel I'd like to scale columns of number to be TOP=100 BOTTOM = 0 Is there an easy way? Thxs <tbody> 113 99 118 84 TOP 100 5 9 -8 16 BOTTOM 0 </tbody>

I have data that I add to daily. Where I added the new data I need to select the rows starting with the current cell and going to the bottom of the column (last row with data) There is a gap from the last row of data to a table about 10 rows below the last row of data so I only need to select...

here is a brief of what i'm trying to achieve: The rows in the source table highlighted in red are already present in the destination table, so i DONT want to copy them over to the destination table. However, if a single cell in any of those rows didn't match the corrosponing field in the...

Hi! New here and trying to learn some more complicated Excel tools. I have a spreadsheet where I want entire rows to drop down to the bottom when the value of a cell is greater than todays date. The cells of interest would be starting at G17 on. Any help would be amazing!

Hi, I have percentage values in certain cells on a sheet (E3 currently displays 84% for example). I would like a shape which takes the value of E3, and then applies that percentage to a gradient fill level of the shape, starting at the bottom. So if the shape (an Oval), was to take 50%, then...

Hello, I need help please. I have a list of random dates across multiple years in cells B3:B10. I am trying to create another list in column D that looks at the list in column B and pulls out only the unique Month and Year combinations represented in the column B list. I found this formula...

have sheets with 100k+ rows of data. values in some cells are calculated values. I need to incrementally subtract a value from an entire column, bottom up. example data <colgroup><col><col span="2"><col><col></colgroup><tbody> A B C D 1 370 19242 19192 18542 2 461 18872 18822 18222 3...