adding rows

Never encountered this problem before. Have a file, tried to add new rows but it moves the Pivot Table down (like I expect it to) but leaves the data that was in the Pivot Table in the original rows... Thought something was amiss with the file itself so I created a new file and tried to...

Hello Excel Warriors I am working and trying but failed to achieve the goal. I want to create an VBA program to create Excel sheet to calculate arrear of pay. I just want to create list of months automatically between start and end dates in which if the starting date or the end date have only...

I am having problems adding data validation to an existing transaction table (some 200+ rows), as the custom formula validation does not get replicated when a new line is added. In this case it is to give a warning if the transaction date is not +/-30 days from the current date...

Hello, I am using a macro that imports data from a third party source via a txt file. The data is then split into new worksheets based on an ID number. (The number of spreadsheets created will vary per run). This part of the macro runs perfectly. The issue I am having is when the macro tries...

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

Hi all! I'm relatively new to more advanced Excel functions, so this question may be relatively easy to answer. I have a spreadsheet with a list of employees that is copy and pasted for every month of the year. As of now, the spreadsheet only goes through June. There are four columns, employee...

I have a data entry area that is a defined range ("Data_Entry_Defined_Range") on a sheet called Data Entry Sheet that allows users to input data which then feeds over to a separate sheet (Report Sheet) with a defined range called ("Report_Defined_Range"). The report sheet is used to provide a...

My original Post was apparently confusing those trying to help me figure out this dilemma, so I am reposting a more broken down version of the post I'm new to registering to this site but have used the related posts on the forums before but I can't seem to find something more specific to my...

Hi all, Being new to VBA I have spent the last few days trying to name 43 columns of my spreadsheet as ranges then adding data to the lastrow. I nearly posted yesterday looking for the entire code, but with a fresh head today I decided to have another stab, utilising a "Teach VBA App" on the...

Hi, My macro inserts a row but I am finding that not all of the formulas are on the new row. The line above and below the inserted line have the formulas in the cells. The data validation cells in the new row work fine with the current macro, it is only my sumif formulas that do not appear to...

I need help with a macro that adds a row under the following condition: From N5:N80, if any of those cells contains a 5 or higher, then add a row below that cell where you have the 5 or higher? Ex: N26 has a value of 6. Therefore I would want a row below N26. Then N55 has a 7. I want a row...

Note: The original document is in Word all cell are tables except titles, which are listed two rows above the table (just so you know where everything is place). User Case ID is always the same size (cols and rows) and the Basic Flow varies in size - same cols, but it can have less or more rows...

Note: The original document is in Word all cell are tables except titles, which are listed two rows above the table (just so you know where everything is place). User Case ID is always the same size (cols and rows) and the Basic Flow varies in size - same cols, but it can have less or more rows...

Hi there, I have created a table in excel but want a macro to be able to add another row to the table, and also one to add another column. Could anyone assist me with this, or point me to a resource that can? Im quite a newby with using VBA and havent got much experience using tables. Regards K

I have a need similar to the one in this post: http://www.mrexcel.com/forum/showthread.php?t=483690&highlight=adding+rows+VBA VoG's code was: Sub InsRows() Dim LR As Long, i As Long LR = Range("A" & Rows.Count).End(xlUp).Row For i = LR - 1 To 3 Step -2 Rows(i).Resize(2).Insert Next i End...

I really don't know what to make of this... I have a list of thousands of dates and times in chronological order. Here is a short example: 9/14/09 15:08:00 9/14/09 15:09:00 9/14/09 15:12:00 9/14/09 15:13:00 9/14/09 15:15:00 9/15/09 9:09:00 9/15/09 9:10:00 9/15/09 9:11:00 9/15/09 9:13:00...

Please see the below image of a spreadsheet i'm working on. There's roughly 4000 rows of data and if there's not a quick fix with VBA then i'm going to be spending hours manually adding rows. Column B houses the Group Code, what I need to do is add 2 blank rows between each group code making...