Code to Insert Column causes Macro to not function correctly...

Trying to create a macro to delete rows based on contents of a column, complete a few sorts, add a column and then combine contents of 3 columns into 1 for each row respectively and then subtotal based on the new combined column.

Here is what I have that works but once I try to add column, macro does not complete the sorts at all or incorrectly depending on where the code for the insertion is placed and the code is edited based on placement of the code to insert the column.

Please Login or Register  to view this content.

Insertion Code...

Please Login or Register  to view this content.

Also can not get the concatenate or =D1&" "&E1&" "&F1 to fill the new C column...the formula works for the first cell and looks correct, meaning row number within formula changes, for the next cells but the outcome is the value of the first cell C1...

Help???

Welcome to the forum, numbersbuff.

Please take a few minutes to read the forum rules, and then edit your post to add CODE tags.

Thanks

Hi
Click on the forum rules button it's all explained there

Thanks for the tip on deleting columns, after I get the afore mentioned portions to work that is the next step.

Will post an example Monday but here is an over view:

Inventory Sheet has Columns A:J, and a variable number of rows up too 1000. Each row can have items in each column cell or only some.

First portion of Macro deletes any rows that lack data in F (quantity of item), the macro then sorts by first C (name of item), then D (size of item) and then E (color of item).

The macro works to here. I need to then insert a column at C and then combine info from now D,E and F in to C, then delete or hide D,E and F and create subtotals by the new C.

I will post a before and after on Monday...gotta run have a wonderful weekend!