ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   HOW DO I MOVE ONE ROW TO ANOTHER PAGE USING A FORMULA. (https://www.excelbanter.com/excel-worksheet-functions/49898-how-do-i-move-one-row-another-page-using-formula.html)

nancyk4544

HOW DO I MOVE ONE ROW TO ANOTHER PAGE USING A FORMULA.
 
I'm working on a worksheet with 2 pages. The first worksheet has rows that
move to the other worksheet daily. Instead of copying them and pasting them
and deleting them is there a formula that will move that row to the next page?

I am using excel office 2003.

Max

Not very sure .. but perhaps you might want to quick browse this recent
thread (similar angle query) with responses for 2 approaches:
http://tinyurl.com/ddo6m
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"nancyk4544" wrote in message
...
I'm working on a worksheet with 2 pages. The first worksheet has rows that
move to the other worksheet daily. Instead of copying them and pasting

them
and deleting them is there a formula that will move that row to the next

page?

I am using excel office 2003.





All times are GMT +1. The time now is 10:20 AM.

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