Copy column B and column E from all sheets into new worksheet
 

How can I copy column B and column E from all sheets to a new sheet
while offsetting the paste ie the 2 column being pasted next to the
other

thxs

Copy column B and column E from all sheets into new worksheet
 

1. Use a do..while loop to cycle through all the sheet names using the
Sheets object.

2. Increment the paste column number by one every loop.
3. Use paste values.

scooper

"al007" wrote in message
oups.com...
How can I copy column B and column E from all sheets to a new sheet
while offsetting the paste ie the 2 column being pasted next to the
other

thxs

Copy column B and column E from all sheets into new worksheet
 

scooper
can i have the code as am new to excel vba


scooper wrote:
1. Use a do..while loop to cycle through all the sheet names using the
Sheets object.

2. Increment the paste column number by one every loop.
3. Use paste values.

scooper

"al007" wrote in message
oups.com...
How can I copy column B and column E from all sheets to a new sheet
while offsetting the paste ie the 2 column being pasted next to the
other

thxs