Need help with macro stopping at empty cell when copy and pasting data from another worksh

I Have a workbook that has 4 worksheets. My first sheet has all of my information needed which is pasted from different companies so the data is never the same amount. First I want to copy and paste lets say: Column B & Columns d-i from sheet1 to columns d-j on sheet2. the columns are always the same but the row amounts change. how can I have my macro copy the data and stop when the cell or range is empty?

Maybe:

Please Login or Register  to view this content.

I am new to vb so I hope you don't mind if I ask a few questions. I would use this macro exactly as you have it? and replace "Sheet1,2,3" with my sheet names? what does (3) (2) mean?

thanks sooo much.

The (3) is a shorter version of (xlUp). It will select the last row with data in a Column. The (2) is an offset command it offsets (1) row. When used together (3)(2) it will select the first empty cell after the last cell with data in a Column.