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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

al007 - 21 Jan 2006 02:49 GMT

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

Reply to this Message

scooper - 21 Jan 2006 04:14 GMT

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

> 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

Reply to this Message

al007 - 21 Jan 2006 07:37 GMT

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

> 1. Use a do..while loop to cycle through all the sheet names using the
> Sheets object.
[quoted text clipped - 9 lines]
> >
> > thxs

Reply to this Message