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