Ask for code to copy and paste between worksheets on next available row

[impresxy]

Hello,

I need help, please.
I have 3 worksheets. 2 of them are templates and the other one is like a database. I would like to get information from the 2 templates to be sent to the database one which it has to be next available row.

I can have the code for copy and paste but if anyone has the code that can just have "Sheet1.value = Sheet3.value" or something like that would be very appreciated.

Please let me know if my explanation is not enough. I am very new.

 

[Trevor G]

What is the database sheet name and is it all data from both template sheets that has to be copied across, what do you want to do with the template sheets once the data has been copied across? Is the data in rows on the templates, which range of cells do you want copied across?

Please provide more information or even copy and paste some sample data into your thread from each template and also the database sheet, how it is laid out and which rows etc.

 

[impresxy]

What is the database sheet name and is it all data from both template sheets that has to be copied across, what do you want to do with the template sheets once the data has been copied across? Is the data in rows on the templates, which range of cells do you want copied across?

Please provide more information or even copy and paste some sample data into your thread from each template and also the database sheet, how it is laid out and which rows etc.

Database sheet name = "DB"
is it all data from both template sheets that has to be copied across = No, only some cells from both sheets
what do you want to do with the template sheets once the data has been copied across = I can leave the data like that, but when it's reopened, can it be cleared ?
Is the data in rows on the templates, which range of cells do you want copied across? = there are many cells, can you give example for "C56" to database "A14" please ?


How can I attach picture?

 

[Trevor G]

It is as easy as copying and pasting into your thread but to give a better picture how it is laid out, look to use either MrExcelHTML or Excel Jeanie Html

 

[impresxy]

Hi,

Im sorry I do not have permission to install as the link you suggest. Is there anyway I can do for explanation?

 

[Trevor G]

Either copy and paste as I have also mentioned or upload a sample of your workbook to a third party and then add the link into your thread to download it.

 

[impresxy]

Here. When I fill up sheet 1, I would like it to append to Database sheet. Sheet1!D3 to Database!A1

Sheet1

	A	B	C	D
1	Customer Name		Date
2	Company Name		Rev
3	Invoice no.		Index

<TBODY>
</TBODY>

Database Sheet

	A	B	C	D	E	F
1	Index	Customer Name	Company Name	Invoice no.	Date	Rev
2
3

<TBODY>
</TBODY>

 

[Trevor G]

Here is some code based on your example

Sub MoveMe1()
Sheets("Database").Select
Range("a65536").Select
Selection.End(xlUp).Select
ActiveCell.Offset(1, 0).Select
With ActiveCell
.Value = Sheets("sheet1").Range("d3")
.Offset(0, 1).Value = Sheets("sheet1").Range("b1")
.Offset(0, 2).Value = Sheets("sheet1").Range("b2")
.Offset(0, 3).Value = Sheets("sheet1").Range("b3")
.Offset(0, 4).Value = Sheets("sheet1").Range("D1")
.Offset(0, 5).Value = Sheets("sheet1").Range("D2")
End With
End Sub

 

[impresxy]

Here is some code based on your example

Hi,

It's really work great. THank you so much for your time and help