Help !

[JessicaSam]

I don't know if anyone will be able to help me, but I'm kind of an idiot when it comes to excel. I'll try to explain this as well as I can.
I'm using Excel 2010, Windows 7 64 bit.
I have a Excel Book with different sheets (the tabs at the bottom).
On one sheet I have a bunch of data (3000 rows and 5 columns) I'll call this Sheet 1
I want to be able to go to a blank sheet (Sheet 2) go to A1 type in data from Sheet 1 (let's say G1) and have the whole 'A' row automatically filled in with the data from 'row G'

Sorry if this doesn't make sense! Thanks!

[roki4]

Will not be long before a mod requests you to change the title to something more descriptive in line with your question/problem. Maybe something along the lines of "auto-populate based on input". Cheers.

[JessicaSam]

ah excuse my ignorance, but how do I change the title?

[roki4]

To change the title of the thread, click EDIT on the original post, then click the Go Advanced button, then change the title. If two or more days have passed, the EDIT button will not appear, and you need to ask a moderator to change the title.