How Copy the Data from more cell in sheet1 to a row on sheet2 (others sheet)

[antoni]

Hello Bos ??
Sorry, anyone can help me, please..

I want entry the data with different row and different cells, so when I click the button, the data on sheet1 is clear and copy to empty row on sheet2 and automatic create a border and automatic insert new row, so we can entry again and next. And I attached my sample Excel File with the description too.

Thank's before

[antoka05]

See attached file... I hope it can help you.
Regards,
Antonio

[JBeaucaire]

Like this perhaps:

Please Login or Register  to view this content.

[protonLeah]

Does this help?
Examples.xls

[antoni]

Hello all my Friends, thank's for your help.
and I have a question again to this Thread.
How we can check if the No. Invoice is already on Sheet2 ?
So, to avoid double in No. Invoice here.

Thank's all

[JBeaucaire]

Here's the updated macro and updated sheet. This will no longer transfer items with duplicated Invoice numbers:

Please Login or Register  to view this content.

[antoni]

Hello Bos ?? Can u help me something again, please
I want use checkbox (Invoice Pending) and When I click the checkbox, the data copy from sheet1 to sheet2 begining from A16 and next row.
But when the checkbos is unchecked, the data copy form sheet1 to sheet2, begining from A6 and next row.

And I attached the file Examples.xls here.

Thank's before

[JBeaucaire]

First, get rid of the FORMS checkbox and replace it with a Controls CheckBox. Now it can be more easily evaluated.

Please Login or Register  to view this content.

Add the TODAY() formula into the cell on Sheet1 and your ready to go.

You didn't indicate this was "insertion" macro, so it just appends to the bottom of each section. There's not a lot of room there in the top section, but I guess you know that.

[JBeaucaire]

Went ahead and made a version that "inserts" rows on Sheet2 so the page will expand forever as needed. Use the version that works best for you.

Please Login or Register  to view this content.

[antoni]

Hello Bos, can u help me again, please..
I want copy the data from Sheet1 (Examples.xls) to Sheet1 (Examples (Results).xls) too after copy to Sheet2 (Examples.xls) when I click OK Button. And How can i Group by Customer Name and Auto Range No. Invoice like 111-115 if Invoice number is sequential when copy the data ??

And I have attached 2 (two) files for this thread.
1) Examples.xls
2) Examples (Results).xls

[antoni]

Hello.. anyone can help me, please..
I want copy the data from Sheet1 (Examples.xls) to Sheet1 (Examples (Results).xls) too after copy to Sheet2 (Examples.xls) when I click OK Button. And How can i Group by Customer Name and Auto Range No. Invoice like 111-115 if Invoice number is sequential when copy the data ??

And I have attached 2 (two) files for this thread.
1) Examples.xls
2) Examples (Results).xls

Thank's before