Hello,
This is an attempt to make a wok process more efficient.
I have attached a workbook, in which i have left notes, if my description is ambiguous.
I am trying to attach a macro (to an excel button) that will do multiple actions.
Upon clicking said button:
1. copy all new data (below a fixed reference point) on one sheet, into a second sheet below all existing data (from the first black row).
2. identify any order that is a duplicate (by checking each new row against all existing data, including new data)
3. copy all NEW data, after identifying duplicates (possibly a dynamic formula?), into a third sheet. each column needs to be pasted under its corresponding heading (fixed reference point). All duplicates need to be highlighted (entire row if possible), and pasted a second time (On the same sheet) under a second heading (fixed reference point) under their corresponding headings.
4. Based on selection tick-box values (true or false) on the first sheet, allocate EVENLY (under the "agent" heading in the allocation sheet) all new rows between the TURE selections. so if there are 5 true selections and 21 rows of new data, 4 true selections (agents) will get 4 new rows (orders) and the 5th true selection will get 5 new rows.
I have a partial workbook if anyone wants me to email it to them, may clarify what I have said above.
I realize this is a very complex request. It is an attempt to make a process automated to the point when someone with no knowledge can successfully complete the process with as little room for error as possible
This is an attempt to make a wok process more efficient.
I have attached a workbook, in which i have left notes, if my description is ambiguous.
I am trying to attach a macro (to an excel button) that will do multiple actions.
Upon clicking said button:
1. copy all new data (below a fixed reference point) on one sheet, into a second sheet below all existing data (from the first black row).
2. identify any order that is a duplicate (by checking each new row against all existing data, including new data)
3. copy all NEW data, after identifying duplicates (possibly a dynamic formula?), into a third sheet. each column needs to be pasted under its corresponding heading (fixed reference point). All duplicates need to be highlighted (entire row if possible), and pasted a second time (On the same sheet) under a second heading (fixed reference point) under their corresponding headings.
4. Based on selection tick-box values (true or false) on the first sheet, allocate EVENLY (under the "agent" heading in the allocation sheet) all new rows between the TURE selections. so if there are 5 true selections and 21 rows of new data, 4 true selections (agents) will get 4 new rows (orders) and the 5th true selection will get 5 new rows.
I have a partial workbook if anyone wants me to email it to them, may clarify what I have said above.
I realize this is a very complex request. It is an attempt to make a process automated to the point when someone with no knowledge can successfully complete the process with as little room for error as possible
