Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Column based on data in Row.
I was unable to find the answer to this question. I know it is out
there but for some reason my search results are not providing what I need lately. I have a spreadsheet that varies in the number of columns (A through Whatever). I want to use VBA to look at Row 2 and anywhere it says a word or phrase (let's say "happy summer") I want to be able to insert another column. For example if D2 says "happy summer" I want to insert a column on F and if, if B2 says "happy summer" I would want to insert a column on C. Any thoughts out there? You guys and gals are always very helpful. Thank you, Dow. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create a Macro to Insert a number into a column based on criteria | Excel Programming | |||
Based on a condition in one column, search for a year in another column, and display data from another column in the same row look | Excel Programming | |||
Insert Blank Row Based on Value in Column A | Excel Programming | |||
copy and insert entire row based on integer in column A | Excel Programming | |||
Insert duplicate rows based on numeric value in column | Excel Discussion (Misc queries) |