VBA to move only selected columns and Auto assign names to task

**nr6281** · 09-24-2019, 01:16 AM

HI All,

Good evening,

I have seen a lot of auto task allocators online few I tried tweaking the macro but I am not able to get what I am looking for exactly.

In the attached File there are 6 sheets.

Tasklist (This has the attendance and what client the agent works on)
Raw Data (My raw dump file which calculates TAT based on time)
ABC, Moon and Other (these three are clients for us)

What I am looking for is

Step 1: FROM raw data sheet I want the data to split based on Column "S" with client Names to its sheets but only the Columns Marked in Green to Move to those sheets.
Once the data is moved to the individual sheets.

Step 2: I want Names to be allocated based on if an agent is present "Yes" to those particular clients
Step 3: Collate all client sheet ABC, Moon and other to Master sheet.

Is this possible?

**nr6281** · 09-25-2019, 12:21 AM

Anybody? Or is the explanation not right?

**JeteMc** · 09-28-2019, 12:26 PM

Please note that I am not suggesting that I can solve, rather that the following is hindering others from solving.
The file attached to post #1 seems to be password protected which, I assume, is why it has no views.
Please either upload another nonprotected version or publish the password.
Let us know if you have any questions.

**nr6281** · 10-01-2019, 04:33 AM

password is 3091 sorry for the delayed response

**jindon** · 10-01-2019, 05:15 AM

Please Login or Register  to view this content.

**nr6281** · 10-01-2019, 06:08 AM

@jindon,

This works perfect however one small change in this is, the code above assigns names to task on the master sheet but would it be possible to assign task on the individual sheets where they are split to.

**jindon** · 10-01-2019, 06:41 AM

Please Login or Register  to view this content.

**nr6281** · 10-02-2019, 04:44 AM

perfect thank you so much @ Jindon

**nr6281** · 10-02-2019, 06:13 AM

Hi Jindon,

I wanted to add one more column so I edited the code but for some reason I am not able to get the names assigned, Should I be tweaking something else too?

Please Login or Register  to view this content.

L is the column I added but I am not sure if i did it right, I am sorry I am being a trouble.

Also could you explain or break down the code in case i have to tweak something I know where to go than disturbing you my bad

**jindon** · 10-02-2019, 07:56 AM

change i to j

Please Login or Register  to view this content.

**nr6281** · 10-08-2019, 03:01 AM

Hi Jindon,

Thank you, I was able to get it.

However one small change I removed Columns U:V from the split data so now it is

Please Login or Register  to view this content.

So now how to have the names assigned right after this i:e (Column L) and not Column N as per the previous ones?

**nr6281** · 10-08-2019, 03:23 AM

And is there a possibility that you can add comments within the macro to tell me what line does what.

I am not quite able to figure out which line assigns the names and which line collates the data so forth and so on

SO if for example if you can help me with something like this.

Please Login or Register  to view this content.

That would be helpful thank you in advance

**nr6281** · 10-11-2019, 02:49 AM

@ Jindon,

Any help on this to have the name assigned in Column L?

**jindon** · 10-11-2019, 03:13 AM

1) add one more variable

Please Login or Register  to view this content.

2) insert one line in bold

Please Login or Register  to view this content.

3) change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

**nr6281** · 10-11-2019, 05:46 AM

Thank you Jindon

VBA to move only selected columns and Auto assign names to task

LinkBack

Thread Tools

Rate This Thread

Display

VBA to move only selected columns and Auto assign names to task

Re: VBA to move only selected columns and Auto assign names to task

Re: VBA to move only selected columns and Auto assign names to task

Re: VBA to move only selected columns and Auto assign names to task

Re: VBA to move only selected columns and Auto assign names to task

Re: VBA to move only selected columns and Auto assign names to task

Re: VBA to move only selected columns and Auto assign names to task

Re: VBA to move only selected columns and Auto assign names to task

Re: VBA to move only selected columns and Auto assign names to task

Re: VBA to move only selected columns and Auto assign names to task

Re: VBA to move only selected columns and Auto assign names to task

Re: VBA to move only selected columns and Auto assign names to task

Re: VBA to move only selected columns and Auto assign names to task

Re: VBA to move only selected columns and Auto assign names to task

Re: VBA to move only selected columns and Auto assign names to task

Thread Information

Users Browsing this Thread

Similar Threads

Macro needed to auto assign task

Excel to record tasks done and assign a task to someone else

[SOLVED] VBA code to assign names based on some variables

Auto assign position code on each row on my spreadsheet?

Auto Update Data excel Task Schedule

Adapt code to move files whose names include the final word of a subfolder name

[SOLVED] code to add a name to the names collection and assign a reference

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions