Scrollable Section for Data Input

[gumbles]

Hi there, apologies if this is the incorrect topic but I couldnt see any better matches.


I am trying to create a section in excel (lets say A7:K10 with headings on the row above) that is scrollable (up to say 100 lines) and the information is entered directly into this scrollable section. The idea is that I can have several of these on one page containing long lists and they wont take up much space on the screen.


This is opposed to having a large list of information then displaying a section of the list using the offset function and scroll bar.


Im not sure if this is possible but thought I might ask as there may be somekind of workaround.


Thanks,


Gumbles

 

[Faseeh]

Hi gumbles,


You want to say that A7:K7 will be showing a part of a table that will be scrollable and as you enter the data and scroll, the data will move to respective column?? This is just of interest, i am terrible at writing macros


Regards,

 

[gumbles]

Hi Faseeh,


So A7:K10 will show 3 lines of the list/table and the headings are fixed above, (not sure if a table is more beneficial) but when you want to add to the list, you scroll to the bottom and enter information into the new row. But you can only ever see 3 lines of the list at a time and you dont have to scroll down the worksheet.


Hope this is clearer


Gumbles

 

[Luke M]

Being able to write back to the scrolled data is going to be tricky to do. Can we just fake it? We could create a 2nd window of the same workbook (View - New Window). Reduce the size of 2nd window, adjust size as desired, and "place" it where you want to see it? =P

(Suggestion given in half jest, probably won't work)


On a more serious note, I generally try to have a raw_data page where all the inputs go, and then a formula produced output page that is all nice and pretty (correct size). Trying to input raw data into a tiny "window" seems like a lot of work, especially if someone wants to copy/paste a large amount of data from/to the window.

 

[gumbles]

Ha brilliant! to be honest what my colleagues are asking me to do should really be done in access but what can you do...


I would agree that having a raw_data page and ouput_page would be the ideal approach and is how I normally operate my projects but ive been asked for this kind of input.


This is for a set of issue lists that are divided into 5 groups and all displayed on one worksheet but if the lists arent compacted somehow the worksheet will become very unfriendly. I also have to pull KPI's from these lists but I have several tricks up my sleve to get them so shouldnt be a problem.


Could you recommend any solutions that might fit these demanding demands?


Gumbles.

 

[NARAYANK991]

Hi Gumbles ,


I am not clear on your exact requirement ; can you explain in more detail ?


Let us say your data entry section is from G7 through Z100 ( I have deliberately chosen such addresses , so that the solution can be generalized ) ; your header row is G6.


When you first start up for data entry , you wish the section G7 through Z9 to be visible and scrollable ; when data entry is completed in this section , you wish the section G10 through Z12 to be visible and scrollable ; this process should continue till the user reaches Z100 , when no further data entry will be possible until the limits are extended.


Is this correct ?


If so , can you explain how we can decide that the user has completed data entry in the visible and scrollable section ? Suppose the user has completed data entry in Z9 ; what key will be pressed so that the visible and scrollable section now changes to G10:Z12 ?


Narayan

 

[gumbles]

Hi Narayan,


Yes, I realise its a rather odd request, hope i can make it clear.


Your assumption is partly correct but when you complete the data entry in the first section (G7:Z9) it makes one more line available so now G8:Z10 is visible but G7:Z10 is scrollable (but only 3 lines are visible at any one time). Giving you the option to see previous entries with the scroll bar.


I guess there could be a button macro to add another line to the list when the visible section is full.


The problem im having is how to put 100 rows into 3 rows as I want to use the space underneath for another data entry box. Sort of like the box you type your posts into on this forum.


As I explain this it seems more and more impossible ha, but thankyou for your help.


Gumbles

 

[NARAYANK991]

Hi Gumbles ,


I think it is impossible ; however , I still do not understand the purpose of this ; if it is only data entry , you will do better to create a userform , where all entered data can be validated before it is stored in the worksheet.


Narayan

 

[gumbles]

Im looking for different approaches and will look at creating a user form. I think it was abit ambitious as well as ambiguos!


Thankyou for you help.


Gumles