Day operations with 1st line always blank

[zoora khan]

I wanted to something that adds a row at the top when i enter data in a table's top row so that the first row always remains blank for entering data.

So basically when i finish entering the data in top row it automatically shifts to 2nd row (while the data in 2nd row automagically shifts to 3rd row and so on)

I m sure there is a simple way to do this but since i don't know what to search for i m drawing a blank in google.

Can anybody help out

 

[GS]

I wanted to something that adds a row at the top when i enter data in

a table's top row so that the first row always remains blank for
entering data.

So basically when i finish entering the data in top row it
automatically shifts to 2nd row (while the data in 2nd row
automagically shifts to 3rd row and so on)

I m sure there is a simple way to do this but since i don't know what
to search for i m drawing a blank in google.

Can anybody help out

Right-click the row header and choose 'Insert' from the popup menu. You
can do this before or after entering data (just depends on your
preference as to having the blank row there, or inserting a new row for
each entry).

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[zoora khan]

oh well, I thought there would be a easier way to do this. I recently learned of drop down list in excel which lead me to think there is always much easier substitute for things i do in excel.

 

[GS]

oh well, I thought there would be a easier way to do this. I recently

learned of drop down list in excel which lead me to think there is
always much easier substitute for things i do in excel

What I suggested IS the easiest way! Otherwise, you'll have to use a
macro and assign a button, menuitem, or keyboard shortcut to it if you
want to auto-insert the row. Right-click>>Insert is way much easier,
IMO!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[Claus Busch]

Hi Garry,

Am Thu, 04 Apr 2013 15:28:32 -0400 schrieb GS:

What I suggested IS the easiest way! Otherwise, you'll have to use a
macro and assign a button, menuitem, or keyboard shortcut to it if you
want to auto-insert the row. Right-click>>Insert is way much easier,
IMO!

what about Worksheet_Change event?


Regards
Claus Busch

 

[GS]

Hi Garry,

Am Thu, 04 Apr 2013 15:28:32 -0400 schrieb GS:


what about Worksheet_Change event?


Regards
Claus Busch

Hi Claus,
Yeah, that's a great idea but that requires coding too! I agree that
it's easier for users than using controls or keyboard shortcut, though!
I'd go with that if the wkb had code for other things anyway, but I
don't feel this scenario justifies making it a macro-enabled wkb. I
mean, really.., how much time/effort does it take to
right-click>>insert. I have Lou Gehrig's and I'm not even that lazy!<g>

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[zoora khan]

you may be right and i don't doubt it. But as i said recently i learned drop down lists in excel very recently and was under the impression that something easier must exist for this. But looking at terms discussed here (Worksheet_Change event, macro etc.) looks like right click + insert is the simplest way. oh well. thanks for trying guys.

the only problem is dense as I m the data operator is even more inexperienced than me so I was looking was a easier way so he just enters the data in first row, hits some combination of keys (like shift+alt+n or something) and the data he just entered shifts to next row and the cursor goes back to the 1st cell of the just emptied row.

you can't win them all.

 

[zoora khan]

you may be right and i don't doubt it. But as i said recently i learned drop down lists in excel very recently and was under the impression that something easier must exist for this. But looking at terms discussed here (Worksheet_Change event, macro etc.) looks like right click + insert is the simplest way. oh well. thanks for trying guys.



the only problem is dense as I m the data operator is even more inexperienced than me so I was looking was a easier way so he just enters the data in first row, hits some combination of keys (like shift+alt+n or something) and the data he just entered shifts to next row and the cursor goes back tothe 1st cell of the just emptied row.



you can't win them all.


PS. I wasn't aware what Lou Gehrig's was. I googled it and the first result was the wiki page of baseball player and I thought it was some kinda crazy american expression. looking further, after i learnt what it did was i was pretty ashamed at my earlier assumption. thanks dude for taking he timeout. if i were in your shoes i wouldn't know what excel was, much less become so proficient that i felt comfortable enough to answer stupid queries from random internet punks.