Spreadsheet functionality question.
Page 1 of 1
paxsali
Banned



Posts: 18352

PostPosted: Fri, 25th Dec 2015 17:02    Post subject: Spreadsheet functionality question.
Hi all,

not sure whether this functionality already exists or what the keywords are for googling, but do you know about this:

- I want to have a textfield / form on a fixed position / cell high up in the first few rows
- whatever I type into that textfield / form is being appended in one specified column, starting at one specified row


Example:

Say you have a textfield "Customer Names".
You enter "Barak Obama"... the value "Barak Obama" is now appended at the end of say Column B, starting at row 10.

Now you enter "Donal Trump". The value "Donal Trump" is appended at Column B, row 11, right beneath "Barak Obama".

And so on and so forth...

Is there such a thing? And if yes, how is it called in MS Excell / Open Office+clones?

Thanks in advance.


"There will be no end to the troubles of humanity, until philosophers become kings, or kings become philosophers.", Plato.
"Hyperbole will destroy us all.", Matt Dillahunty.
"The hyperbole, the demonization of the other opinion and the unwillingness to even read the opposing opinion destroys the so important political discussions necessary for the well functioning of society.", Couleur
Back to top
paxsali
Banned



Posts: 18352

PostPosted: Sat, 2nd Jan 2016 21:13    Post subject:
⁢⁢


Last edited by paxsali on Thu, 4th Jul 2024 21:40; edited 1 time in total
Back to top
Bob Barnsen




Posts: 31974
Location: Germoney
PostPosted: Sat, 2nd Jan 2016 22:48    Post subject:
I can not help you friend.
But i know what you want.
You probably need a little Visual Basic Code.
Back to top
paxsali
Banned



Posts: 18352

PostPosted: Sat, 2nd Jan 2016 23:35    Post subject:
⁢⁢


Last edited by paxsali on Thu, 4th Jul 2024 21:40; edited 1 time in total
Back to top
PumpAction
[Schmadmin]



Posts: 26759

PostPosted: Sun, 3rd Jan 2016 00:52    Post subject:
Well you could always work on https://spreadsheets.google.com and write custom JavaScript code... Which I know you love Cool Face

Apart from that you HAVE to have a script which runs upon an event, because what you describe is an event -> Entering text and THEN something has to happen to clear that field and store that information somewhere.


=> NFOrce GIF plugin <= - Ryzen 3800X, 16GB DDR4-3200, Sapphire 5700XT Pulse
Back to top
paxsali
Banned



Posts: 18352

PostPosted: Sun, 3rd Jan 2016 01:12    Post subject:
⁢⁢


Last edited by paxsali on Thu, 4th Jul 2024 21:40; edited 1 time in total
Back to top
PumpAction
[Schmadmin]



Posts: 26759

PostPosted: Sun, 3rd Jan 2016 01:46    Post subject:
yes


=> NFOrce GIF plugin <= - Ryzen 3800X, 16GB DDR4-3200, Sapphire 5700XT Pulse
Back to top
ManMountain




Posts: 793

PostPosted: Sun, 3rd Jan 2016 02:55    Post subject:
Unless I've misunderstood, you could simply copy the desired source cells range and either choose to paste link on B10 or use formula =A3 in B10, =A4 in B11 etc.

Back to top
Page 1 of 1 All times are GMT + 1 Hour
NFOHump.com Forum Index - Applications
Signature/Avatar nuking: none (can be changed in your profile)  


Display posts from previous:   

Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB 2.0.8 © 2001, 2002 phpBB Group