insert cells

Basically, I have a formula that checks to see if the text of one column is within the text of another. Pretty simple. However, when I insert cells then the formula does not automatically update even though I have it set to Auto Update. Here's a short video of the problem: Screen Recording...

After commenting on this thread, I was advised to post a new question. I am writing a macro to insert rows in a sheet based on whether the first part of the value in colA corresponds to a certain value in an array. Initially, I had the array fill into G3:G15 as text, then the sub compared the...

highlighting 4 cells/in columns AA6-AD6 to insert cells/shift down and entire row from far left keeps getting inserted. nothing merged. unfreezed everything. no hidden columns. Lots of data - shared document - Excel 10. any ideas? Thanks! Holly:confused:

Hello all, I use Excel for Mac 2011 on a 3 year old MacBook Pro 17". A few months ago, I had open two Excel worksheets that were a tab-delimited text (.txt) file and a regular file (.xlsx) (a Word document file [.docx] was open in the background). I copied around 850 cells from the .xlsx...

I need help writing VBA code to add a cell within a column based on a value in another column. Basically, if cell "K2" is greater than 0, I want to run a code that would insert a blank cell into that same row (cell "O2"), which would shift the current contents in O2 downward. I would like this...

Hello, I am new to macros and VBA so I apologize for my poor explanations. The issue is that the spread sheet I'm working with has dates which are incorrectly read and filtered improperly. When I go to filter the dates, it lists every single date in the column instead of by year, month, and...

I put the default toolbar button to insert a cell on a worksheet. However, I want to insert it horizontally and not vertically. If I use the menu, it gives me the option to change it to horizontally for that instant. But if I use the toolbar button, then it does it vertically automatically. Is...