ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Extract line and copy (https://www.excelbanter.com/excel-programming/336193-extract-line-copy.html)

sal21[_66_]

Extract line and copy
 

Assumnig i have this wbook with many sheets (into offical wbook the
sheets are 52 and all are named with a number with 4 digit, exclude
from the request macro the L0747 and MENU not are important for the
project)

My problem:

Into column P of each sheets are present a value.

I would want to extract all line from all sheets (without delete the
source lines and maintain into sheets) where is present a value into
column P and put all lines with condition into a template sheet named
RICHIESTE (is similar the sheet l0747)


+-------------------------------------------------------------------+
|Filename: 5-505254-L0747_DEF.zip |
|Download: http://www.excelforum.com/attachment.php?postid=3667 |
+-------------------------------------------------------------------+

--
sal21


------------------------------------------------------------------------
sal21's Profile: http://www.excelforum.com/member.php...fo&userid=2040
View this thread: http://www.excelforum.com/showthread...hreadid=392326



All times are GMT +1. The time now is 06:02 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com