add rolls automatically at top
I add information every day to my spread sheet. I alway add rolls at the top
to my excel spreadsheet. Is there any way to type in new rolls automatically without adding new rolls. I never know how many rolls I will need each day. Thank you. Caroline |
add rolls automatically at top
Most likely, you need macros to achieve what you want.
"Caroline Cook" <Caroline wrote in message ... I add information every day to my spread sheet. I alway add rolls at the top to my excel spreadsheet. Is there any way to type in new rolls automatically without adding new rolls. I never know how many rolls I will need each day. Thank you. Caroline |
add rolls automatically at top
Here is one way: On a new day, enter your data *below* your last row (roll?) using as many rows (rolls) as needed. Then EditCut these new rows, right click on cell A1 and 'insert cut cells'. Now today's info is at the top. Good luck. -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=477615 |
All times are GMT +1. The time now is 12:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com