LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 24
Default Scrolling columns display

Hello:
I would appreciate help with the following:
I am using two worksheets, WorksheetA & WorksheetB

On WorksheetA, I have data in 100 columns by 10 rows.
Each column, thus has 10 rows of data, each representing data from one
day
eg. Cell A1 shows the value Day1, while Cells A2 to A10 has other data
&
Cell B1 shows the value Day 2, with other data in cells B2 to B10
& so on

On a separate WorksheetB, I would like to display the data from
WorksheetA, in ONLY 3 columns at a time (Range A1to C10) with a
horizontal scroll bar control.
eg Initially, Columns A, B, C on WorksheetB would display data from
Day1, Day2, Day3 (ie. from WorksheetA, RangeA1to C10)

On using the horizontal scroll button, I would like the data to be able
to shift leftward or rightward, for example on WorksheetB I would like
to see data from Day7, Day8, Day9

I would appreciate help with the VBA code for this.

TIA
Vinay

 
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
scrolling columns behind previous columns gfw Excel Worksheet Functions 4 October 23rd 09 10:54 PM
How to keep title of columns in view when scrolling RobG2007 Excel Discussion (Misc queries) 2 July 26th 07 01:50 PM
keep a group of row/columns scrolling up or down? LyndaV Excel Discussion (Misc queries) 1 March 3rd 07 02:23 PM
Live Scrolling/Real-Time /Smooth Scrolling doesn't work for me in Excel, even 2007 beta [email protected] Excel Discussion (Misc queries) 2 July 21st 06 01:21 AM
Live Scrolling/Real-Time /Smooth Scrolling doesn't work for me in Excel 2003 [email protected] Excel Discussion (Misc queries) 0 May 12th 06 03:15 AM


All times are GMT +1. The time now is 10:36 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"