automate adding rows

Hello, I'm new to VBA scripting, and have tried a few versions posted here, but none seem to work for my layout. I'm trying to make a sorted grocery list that calculates the lowest price. I've sorted out all the formulas to get the information, what I can't do is add lines, so the list is cut...

Hi, I am trying to create a 3 sheet document where 'Sheet 1' is a table where columns A to G are filled in then you would click a submit button (or something along those lines) and this would create a new row on 'Sheet 2' 'Sheet 2' is where Columns I-P will be filled in with information and...

Hi all, Hoping someone can answer this question for me. I have a dashboard on one tab and a raw data sheet on the other. The dashboard has COUNTIFS() formulas pulling data from the raw data sheet, but my issue arises from when I add rows to raw data sheet and the COUNTIFS() do not include these...

Every week a new report comes out that I save as a text file and refresh in my Excel workbook, this is in sheet 1. As each week comes out, I start a new row and I copy and paste certain data from that report on sheet 1 to sheet 2. I was thinking that there must be a way to link the cells that...

Hi To Everyone, I am trying to achieve the following Task.. Assume I have 2 different google spreadsheets. Spreadsheet A having 300 entries & it will update daily basis, having Range of A1:O300. In SpreadSheet B, I have two <gs id="55e0d86b-3755-427b-b8db-ebeda470bba6"...

I don't know if this is possible, but I would like to be able to highlight a row by using ctrl+F and by typing in what is in column A, be able to highlight the row in blue. When I type in what is in column A while it is highlighted in blue, I want it to turn green. When I type in what is...

Hi All, I'm in real need of some help with creating a macro which will automatically insert a formatted (bold, centered) row in B20- I20 sheet 1, when the value in Sheet 2 Column N row 26 becomes greater than 0. Please let me know if you require any further details in order to be...

Hi, I have found some answers to somewhat similar questions but none that fits my need and unfortunately I am not experienced enough with VBA to piece together a functioning macro from what I've found searching online so far. What I need to do is to create a macro that runs automatically once...

Good Morning I have a large worksheet with revenues/expenses of organizations. Each organization is represented by an identifying number and 5 or 6 rows of data. I need all organizations to be represented by 6 rows even if one row contains 0s. I have been using =COUNTIF(B:B,B2)=6 to screen...