ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Conditional Copy From One Sheet To Another (https://www.excelbanter.com/excel-programming/288041-conditional-copy-one-sheet-another.html)

Kevin ..

Conditional Copy From One Sheet To Another
 
Hi

I am trying to automatically populate a worksheet from data contained
in another based on the dates today and today + 1.

There will be multiple rows with elegible data. The date will be in
column A.

In simple terms it would look something like this.

In Spreadsheet A, Column A
Where Date = Today and Date = Today + 1
Copy all those rows to Spreadsheet B.

I am wondering if anybody can help with this.

Many thanks all.

Cecilkumara

Conditional Copy From One Sheet To Another
 
Kevin,
Advance filter can do it.
visit
http://www.contextures.com/xladvfilter01.html
for details.
Cecil

"Kevin .." wrote in message
om...
Hi

I am trying to automatically populate a worksheet from data contained
in another based on the dates today and today + 1.

There will be multiple rows with elegible data. The date will be in
column A.

In simple terms it would look something like this.

In Spreadsheet A, Column A
Where Date = Today and Date = Today + 1
Copy all those rows to Spreadsheet B.

I am wondering if anybody can help with this.

Many thanks all.





All times are GMT +1. The time now is 07:29 AM.

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