Loop that Copys from one sheet and pastes to another

Posted to microsoft.public.excel.programming

JI[_2_]

external usenet poster

Posts: 11

Loop that Copys from one sheet and pastes to another

Im trying to find a vba loop sample of something that would look at all
the values in
column A:A of "sheet1" if they equaled "Sheet2, Cell A5" then copy
columns
B:F on that row and paste it to "sheet2" starting in row 7 column A:A.
Keep cycling through the data until the last row. Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
updateing a orginal sheet after two or more have updated copys	Configure spreadsheet mulit-users	Excel Discussion (Misc queries)	1	May 19th 10 08:02 PM
How to keep custom menu from being killed until all wkbk copys clo	Hapless	Excel Discussion (Misc queries)	5	September 5th 08 05:32 PM
I cut and paste a pic & it pastes somewhere else in the doc, why?	cut and paste and lost my picture	Excel Discussion (Misc queries)	1	June 14th 07 01:09 AM
How do I set up a querry that copies and pastes	SAR_Dave	Excel Programming	1	January 30th 06 09:44 PM
Macro that cut and pastes	Shannon	Excel Programming	8	August 14th 04 09:51 PM

All times are GMT +1. The time now is 03:58 PM.

Menu

About Us