Posted to microsoft.public.excel.programming

buzz

external usenet poster

Posts: 15

Conditional copy

I have a range E5:H72 used as a data table. It is updated with a new column
of information weekly Next week it will be E5:I72 and so on. I want to take
the last 13 columns (weeks) and copy paste them to another worksheet for
reporting.

Can anyone help me with this, noting that:
when there are less than 13 columns I want them all
when there are greaterte than 13 I want the 13 rightmost (most recent)
columns

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional copy	Idaho Excel User	Excel Discussion (Misc queries)	0	August 22nd 06 05:32 PM
Conditional copy	ledzepe	Excel Discussion (Misc queries)	2	March 3rd 06 06:27 PM
Conditional Copy	jh	Excel Discussion (Misc queries)	9	December 8th 04 03:15 PM
Conditional Copy	pambear	Excel Programming	2	April 8th 04 12:56 AM
Conditional copy & paste	RonD	Excel Programming	1	January 3rd 04 06:10 AM

All times are GMT +1. The time now is 08:56 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us