Scrolling columns display

V

vvaidya

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top