Copy fixed data to next free row

[sungen99]

Silly really but I cant seem to make this work.

All in the same workbook-
Copy A1:BB16 and paste as values to the next available row after 4. (i have a few rows of titles and what not)

So the first set of data will fill in at A5, then A6 and so on.

Thanks for the help!

[AB33]

What is the name of the sheet you want to copy in to? Is it a single sheet or all sheets on the workbook?

[sungen99]

All on the same sheet. Easy as pie right? HA.

[GeneralDisarray]

see next post

[GeneralDisarray]

wait... the dimensions don't make sense.

A1:BB16 is 16 rows by 54 columns. So, you can't paste it into row 5, then row 6... etc... unless you flatten it to 1 row by 864 columns.

Is that what you want to do? Also, what sheet is this going to... can't be the same sheet because row 5,6,7... etc are WITHIN the copy range "A1:BB16"


Did you mean, A1:BB1??? If you did mean that, then use the following.

Please Login or Register  to view this content.

[AB33]

No, what are the names of the source sheet and destination sheets?

Please Login or Register  to view this content.

[sungen99]

Yes BB33 that is exactly what i meant. Thank you!

[GeneralDisarray]

Did I help?

[sungen99]

No actually.

I want to copy A1:bb1 to the next open row after 5

So a6:bb6.... if i ran it again then it would copy A1:bb1 to A7:bb7.... and so on...

[GeneralDisarray]

DO THIS:

Please Login or Register  to view this content.

[sungen99]

Perhaps it would be easier to just upload the file.Example.xlsm

[AB33]

Changed in to BB1

Please Login or Register  to view this content.

[GeneralDisarray]

SEE ATTACHED>


You are using 'tables' wrong. Instead of Tables. use Sheet2.

WHy? Because what I was using was the sheet-code-name, NOT the sheet-name. The sheet name is what you see in the user end of things (on the little tab row). You generally don't want to use that.

[GeneralDisarray]

Please Login or Register  to view this content.

THIS IS WHAT I MEAN

[sungen99]

woot!!!! thanks!!!!!!