Transferring Data/Auto Sort

[SilkyJohnson]

I am trying to combine rows of data, each 4 cells long from multiple worksheets into one master sheet. I need to know if there is an easy way to do this and also I would like to setup an Auto Sort if possible to automatically sort the rows by date.

The data that will be transferred is: Date, Amount, Description, and Company Billed. I have my workbook organized by a Vendor per worksheet and would like to have the data I enter inside the vendor worksheet to automatically transfer to the master sheet and sort by date. Does that make sense?

[Flintstone]

Hello SilkyJohnson:

It sounds simple enough, if you could post a sample .zip file I'm sure you would get a better response.

Matt

[SilkyJohnson]

Here you go, this is an example of what I have...I have more worksheets in the original. I want to be able to enter info in the Bulbs.com worksheet and have it automatically update the master sheet with that entry and then sort all the data by date.

I would like for it to transfer all entries from each of my worksheets into the master sheet and then sort by date. Can anyone help with this?

Thanks.

[SilkyJohnson]

Here is a better example, with more data to work with.

[VBA Noob]

This might get you started

The main code is from this website

http://www.rondebruin.nl/copy2.htm

VBA Noob

[SilkyJohnson]

Thanks!! That's exactly what I was looking for, plus a cool button! Now I just need to modify the code for my original and I should be good.

Thanks again.