row

Okay so I've been struggling with this for a while and I can't seem to formulate my question that great either, bear with me please. So, I have created an excel sheet that collects exercise data into columns extending for several weeks. In my data sheet I am trying to collect these data points...

Hello, I have a Data-Validation Drop Down on Cell A1 that contains Board Game Categories and whenever I click them, I need excel to pull all the Board Games associated with that category and list them down in COLUMN A. So far, my code is only pulling Board Games that has that specific category...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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