EXCEL: copying 1 worksheet to another

[mattborn]

What I want to do is make a duplicate copy of the data in one worksheet into another worksheet minus the first 3 rows, but I have no idea how to do it.

THanks

 

[Dreamboat]

I would just copy the worksheet, and delete the first 3 rows.

If you need them to be linked (changing worksheet 1 changes worksheet 2 also), then select the cells you want. Copy.

Go to worksheet 2, click on the top-left most cell where you want the data to begin, and hit Edit-Paste special-Paste link.

Anne Troy

http://www.amazon.com/exec/obidos/tg/detail/-/0972425845/104-9778384-2391158?v=glance&s=books

 

[rdodge]

Couple of ways. You can do it the manual way of select all of the rows other than the first row (which can be rather tedious), or you can set VBA to do this:

Sub CopyWorksheet(ByRef FromWS as Worksheet, ToWS as Worksheet)
FromWS.Range("4:65536&quot.Copy ToWS.Range("A4&quot
End Sub

Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000
When the going gets tough, the tough gets going.

 

[rdodge]

Dreamboat, I thought about that way too, but if the user has something like a header within the first 3 rows on the copy to worksheet, that method could not work.

Ronald R. Dodge, Jr.
Production Statistician
Master MOUS 2000
When the going gets tough, the tough gets going.

 

[bluedragon2]

Also, Why not just make a copy of the actual file and delete the first three rows



Blue

If I wasn't Blue, I would just be a Dragon...

 

[mattborn]

Well the reason I am doing this is that I use Crystal Reports to generate a report off of this data. The worksheet I currently use has macros, autofilters, and data validation. I can't get Crystal Reports to work of the original data, I have to copy the data I want to another file to be able to use it. I just wanted it to be kind of automatic, because the data changes regularly.

 

[KenWright]

Not really automatic, but only a 2 second job. Right click the tab, choose 'Move or Copy', choose new workbook and delete the first 3 rows.

Regards
Ken.................

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------