LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Garekko
 
Posts: n/a
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
From several workbooks onto one excel worksheet steve Excel Discussion (Misc queries) 6 December 1st 05 08:03 AM
In 3 active sheets in wkbk, determine& display the # of sheets that have data wrpalmer Excel Discussion (Misc queries) 1 November 4th 05 02:01 PM
hide sheets use data j2thea Excel Worksheet Functions 3 November 3rd 05 09:23 PM
Keeping data updated between 2 sheets... novice needs help. FatMagic Excel Discussion (Misc queries) 5 October 14th 05 09:38 PM
transfer data in excel between sheets Data Transfer betwen Excel Sheets Excel Discussion (Misc queries) 1 June 20th 05 05:20 PM


All times are GMT +1. The time now is 05:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"