PDA

View Full Version : Cut and paste the challenge



JAmanow
02-09-2011, 01:36 PM
Issue:
I have a file that is created through the import function in a maintenance program.
The file consists of the Excel file with approx. 15 pages of names from the Sheet1 to blad15.
All sheets have an identical set of (same column names) with different amounts of data rows.
Column has the following names:
Task, Labor, Name, Approved, Start Date, Start Time, End Time, Regular Hours, Rate, Memo.

Desired outcome:
The contents of all pages to be cut and pasted into the newly created sheet with names shared position.
In a newly created page with name "shared position" All rows (except the header row at the top) consisting of cells with only text to be deleted.
Any tampering with blades to delete.

Thanks in advance.
JAManow

mancubus
02-10-2011, 12:01 AM
here you go:

http://www.vbaexpress.com/kb/getarticle.php?kb_id=151

mancubus
02-10-2011, 12:02 AM
and this article is for combining all wbs in the same folder.

http://vbaexpress.com/kb/getarticle.php?kb_id=829