Copy filtered worksheet to new workbook - sort data - insert new row after group of data add a title to each group

HEYSHUNT

New Member
Joined
Apr 26, 2017
Messages
2
Hi All

i have a filtered workbook, I need to be able to create a new worksheet off this.

Now this is simple, but where I’m struggling is I then need in the new worksheet to sort the data by 2 columns, then insert a new row after a group of sorted data.

Then in the newly created rows, I want a set of text to be inserted based on a criteria.

can any body help?

I can upload the current workbook for anybody to help, or mail it to them.

Thanks all,


Chris
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.
Please upload workbook and I'll take a look. Also can you define the criteria and text you want?
 
Upvote 0

Forum statistics

Threads
1,215,835
Messages
6,127,167
Members
449,368
Latest member
JayHo

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top