| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy column from different sheets and plot a graph | Excel Discussion (Misc queries) | |||
| Copy rows of one sheet into mutiple sheets based on column value | Excel Discussion (Misc queries) | |||
| Copy worksheet with row & column references | Excel Discussion (Misc queries) | |||
| how to copy contents of one column to another column in another worksheet | Excel Discussion (Misc queries) | |||
| how to copy sheets keeping defined column widths | Excel Worksheet Functions | |||
Linear Mode
