inserting

Posting for my co-worker....she has a fairly large excel workbook, main tab feeds 3 other tabs. The main tab has 5,000+ rows. She tried to insert a new row by highlighting the entire row and also tried just highlighting the cells and inserting, both times she got this error message...

Hi, I am not sure if this is simple or not but I have a table that looks something like this cells A7:F7 contain formulas. the table need to be updated once in a while by inserting a new column, but when I do this, the formula disappears from the corresponding cell in row 7. [/IMG]

I have 2 lists of data 1 with 1 minute data and with 5 minute data. ordered like this : |29-12-2017 18:00:00| I would like to turn my 5 minute data into 1 minute data. Basicly inserting the same row 4 extra times beneath the first adding for each row 1 minute |29-12-2017 18:01:00| Or...

Morning all I have a database full of dwell times (for drivers on site) that are in the below format. Is it possible to insert a slicer that can be changed to have options to select all entries over 4, 5 & 6hrs? When I am inserting the slicer it is listing all entries and as you can imagine...

Morning all I have a database full of dwell times (for drivers on site) that are in the below format. Is it possible to insert a slicer that can be changed to have options to select all entries over 4, 5 & 6hrs? When I am inserting the slicer it is listing all entries and as you can imagine...

Hello, I am trying to prep a batch of files in a folder for use in a database, so my code (pasted in whole below) attempts to 1) create a number of columns with ID codes for each row, 2) clean up the existing files' field headings, 3) delete unnecessary rows, and 4) compile them all into one...

Howdy folks, So this is my dilemma....I have 2000+ rows of information and A-T columns. I am trying to simply insert information into column O line 176 without disturbing any of the columns/rows to the left...Is there a way to do this? I have tried inserting but it always creates a blank cell...

Hi friends A have a range of cells covering the column A to H I do not have to insert column beteween columns A to H because of some activities analysis. Is there a code VBA to lock inserting column beteween column A to H? Thanksss

Hi I started an quite similar thread earlier today but it was a little confusing so I have a better question this time around. im working on a code (still on test bench) but here is what I got: Sub shape2017() Dim LogoPath As String Dim j As Long Dim ws As Worksheet: Set ws =...

how would I change this formula to change from sum C13:L13 when inserting a column on schedule 11 and C13:M13 when inserting two, etc? =IF(SUM('Schedule 11'!C13:K13)<>'Schedule 12'!C13,"ERROR!","") Thanks

Hi people can any one help I am looking to have a few pictures show as a formula but I am unsure on how to get it to work. I need to do the following: what will show in column B will change each day as a I am creating a ordering picking list and want to show a pic in column A of the item to...

I am looking for a macro that, once a cell in the STAGE Column (Column “O”) is updated – for example, from 90% to 100% - will CUT the entire row of the cell that has been updated and INSERT it into the first row below the corresponding header row. Things to consider: 1. The header rows can’t...

I have 2 problems that I can not solve. I don't know if a solution to either of them is possible in excel. 1. From a large spreadsheet/database with time and price information I need to extract the data from every 15th row and insert it into a new spreadsheet in chronological order. 2. Is...