Transfer specific columns if a condition is met

**jakjo641** · 01-23-2023, 12:06 AM

Hello everyone
I have tried to write a macro to Transfer specific columns from DATA sheet to worksheets "first" & "second" but have had no success.
so I thank everyone who is able to give me some of your time to help me to create a macro that can do the following:
Step1
If sales exist in Column K and If "Worth" exist in Column L columns will be transferred E & D & F & BU & BV from DATA sheet to first sheet.
Step2
If sales does not exist in Column K and If Worth exist in Column L columns will be transferred E & D & F & BU & BV from DATA sheet to second sheet.
Step3
If Worth does not exist in Column L then to skip that row.
Step4
I need to insert one row without borders after each 25 names, this row would be as footer ... if the remaining items are less than 25
then to insert row directly after them, During that process I would like to add some strings in this insert line like "Signature" in column B
and "Signature1" in column D and "Signature2" in column G .... and finally if possible to adjust the page breaks automatically.
I have attached a sample workbook with the desired output in both worksheets first & second ...Thanks a lot in advance.