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
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