ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   end of worksheet question (https://www.excelbanter.com/excel-worksheet-functions/5318-end-worksheet-question.html)

olmedic

end of worksheet question
 

That did not seem to work. I tried it different ways, but it just didnt
seem to accomplish what I need.

Let me reword the question a different way.


Is there a way to get Excel to automatic format the next row for you?
If not, is there a way to get excel to automatic format the next page
for you?

The whole thing I am trying to accomplish is being able to have rows
formatted a certain way. Add data to a new row every day. Be able to
print whenever I need to.

The problem I am encountering is. Formatting many rows in advance
causes there to be "blank" pages. Excel seeing a formatted row as
containing data and wants to print it. If I dont format rows in
advance, then I have to instruct all of the users on how to copy cells,
which would become a problem with some.

Any ideas would be very helpful.


--
olmedic
------------------------------------------------------------------------
olmedic's Profile: http://www.excelforum.com/member.php...o&userid=15801
View this thread: http://www.excelforum.com/showthread...hreadid=273040


Dave Peterson

maybe:

http://groups.google.com/groups?thre...E636%40msn.com

olmedic wrote:

That did not seem to work. I tried it different ways, but it just didnt
seem to accomplish what I need.

Let me reword the question a different way.

Is there a way to get Excel to automatic format the next row for you?
If not, is there a way to get excel to automatic format the next page
for you?

The whole thing I am trying to accomplish is being able to have rows
formatted a certain way. Add data to a new row every day. Be able to
print whenever I need to.

The problem I am encountering is. Formatting many rows in advance
causes there to be "blank" pages. Excel seeing a formatted row as
containing data and wants to print it. If I dont format rows in
advance, then I have to instruct all of the users on how to copy cells,
which would become a problem with some.

Any ideas would be very helpful.

--
olmedic
------------------------------------------------------------------------
olmedic's Profile: http://www.excelforum.com/member.php...o&userid=15801
View this thread: http://www.excelforum.com/showthread...hreadid=273040


--

Dave Peterson



All times are GMT +1. The time now is 09:50 PM.

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