ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Moving data between sheets using buttons (https://www.excelbanter.com/excel-worksheet-functions/85533-moving-data-between-sheets-using-buttons.html)

Garekko

Moving data between sheets using buttons
 

Hi,

At work I have found an old file that allows me to click a button in
worksheet 1 and type in a week number (1-52) which then takes
information from worksheet 2 (with 52 days worth of data stored) and
places it into worksheet 1 - then I can click it again, choose another
week and it will then update worksheet 1 with week 2's info... and so
on...

Unfortunetly the original file is password protected so I cant see some
of the formula that I need (such as the buttons code)- All I need is the
skeleton so I can enter my own data and use its functions.

Any advice would be greatly appreciated.


--
Garekko
------------------------------------------------------------------------
Garekko's Profile: http://www.excelforum.com/member.php...o&userid=33894
View this thread: http://www.excelforum.com/showthread...hreadid=536702



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

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