USing VBA to copy rows based on condition - amendment to macro needed

[kidwispa]

Hi all,

Having trawled through a number of answers on here and other websites I was wondering if someone could help me with this. I have a spreadsheet that is sent over to me by a colleague every day containing 1000's of rows of data which I drop into a worksheet. Having ran a macro to clear out all irrelevant data, I now wish to copy specific rows to the worksheets within the workbook assigned to specific agents we have based on criteria in one column.

I've created a macro that uses autofilter to select the correct agent, then copy the data into the relevant sheet, however the rows in which the data for that agent will begin from will differ on a daily basis.

Is there a way to set the first row of data by agent? Or is there an easier way to achieve this?

If you need more info then please let me know

 

[hiker95]

kidwispa,

See if this does what you are looking for:

Norie
DistributeRows
http://www.mrexcel.com/forum/showthread.php?t=315083


If you need more help:

What version of Excel are you using?

You will generally get much more help (and faster) in this forum if you can post your small samples (what you have and what you expect to achieve) directly in the forum.

To attach screenshots, see below in my Signature block: Post a screen shot with one of these:

 

[kidwispa]

kidwispa,

See if this does what you are looking for:

Norie
DistributeRows
http://www.mrexcel.com/forum/showthread.php?t=315083


If you need more help:

What version of Excel are you using?

You will generally get much more help (and faster) in this forum if you can post your small samples (what you have and what you expect to achieve) directly in the forum.

To attach screenshots, see below in my Signature block: Post a screen shot with one of these:

Thanks for your reply Hiker - I do usually post my code but this particular macro is about 200 lines long (as there are 15 different agents).

As far as screen shots are concerned, I'm on my work pc and do not have sufficient access to download any software...

Will try the suggestion and come back to you...