Transfer entered data from Sheet1(REQUISIÇÃO) to Sheet2

[segun1ng]

Hi,

REQUISIÇÃO is being used as the interface tool for something I'm building. It will contain entry fields a user may enter. I need a VBA macro that will copy data from REQUISIÇÃO (cell D5,6,7,8 and so on …) and paste it into Sheet2 (C2, D2 and so on). It must also be able to clear the data from REQUISIÇÃO and allow the user to re-enter new data. When the user re-enters new data, it will copy into Sheet2, C2. When entered a new data in REQUISIÇÃO, it will copy into sheet2 D2, when entered another data in REQUISIÇÃO it will copy into sheet2 E2 and so on with DATE on top SHEET2 C1, D1 and so on in which is data was entered and saved. Any help is great. Thanks!

Example:
- Data is entered into REQUISIÇÃO D5
- Command Button to run Macro
- Data in REQUISIÇÃO D5 is copied and pasted to Sheet2 C2
- Data in REQUISIÇÃO D5 is cleared after paste
- User can re-enter new data into REQUISIÇÃO D5, data is copied and pasted into Sheet2 D2.

NB: I HAVE ATTACHED SAMPLE FILE.

[JOHN H. DAVIS]

Not sure I understand, but does this help?

Please Login or Register  to view this content.

[segun1ng]

JOHN, thanks for your reply. I just want to say that the code did not do what I was expecting it to do. I have attached the file for your review.

Regards.

Not sure I understand, but does this help?

Please Login or Register  to view this content.

[JOHN H. DAVIS]

What is it not doing that you want it too do?

[segun1ng]

When Data is entered into REQUISIÇÃO D5

And the Command Button is click to run Macro

The Data in REQUISIÇÃO D5 is copied and pasted to Sheet2 C2

And Data in REQUISIÇÃO D5 is cleared after paste

User can re-enter new data into REQUISIÇÃO it will copy into sheet2 D2 and so on with DATE on top SHEET2 C1, D1 and so on

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[segun1ng]

Thanks for the good job. It works but it only copied cell D5, I want it to be able to copy cell in RANGE of D:D to sheet2

Maybe:

Please Login or Register  to view this content.

[JOHN H. DAVIS]

See if this does what you need.

Please Login or Register  to view this content.

[segun1ng]

wOW... Thanks very much. This work now.

I would like to ask for one more thing.

The Requisição sheet has a Vlook, when digit the code in cell A5 in Requisição sheet it will look for the item in Item sheet.
Is it possible to Vlook the items slected in Requisição sheet when pasting in sheet2.

Thanks for the help.

You are the best.

regards.

[JOHN H. DAVIS]

Can you provide a sample with a vlook-up in place?

[segun1ng]

The Requisição sheet has a Vlook, when digit the code in cell A5 in Requisição sheet and the Command Button is click to run Macro it will look for the item in Item sheet.
Is it possible to Vlook the items selected in Requisição sheet when pasting in sheet2.

Remember that sheet2 has complete list of all items.

When pasting the items selected from Requisição sheet. I would like the Vlookup to position the figures from Requisição sheet in cloum D:D to respective items in sheet2.

Is this possible.
Sem título.jpg

[JOHN H. DAVIS]

Try:

Please Login or Register  to view this content.

[segun1ng]

What I realy want is when submiting the selected items from REQUISIÇÃO SHEET, it should look for those on the sheet2 and enter the figures in the row which that item is located.

This code did not do that is it possible.

Regards,

[JOHN H. DAVIS]

What figures? Columns A-C from the REQUISIÇÃO SHEET? The row number from the REQUISIÇÃO SHEET? Where does it go on Sheet 2?

[segun1ng]

Requisição Sheet->>> Columns A has the codes ->>>> Columns D has the figures that will go into sheet2


I want the items code in column A and figures from Columns D selected from Requisição Sheet to Vlookup the code in sheet2 in Columns A:

AND DO THE FOLLOWING.

When Data is entered into REQUISIÇÃO D5

And the Command Button is click to run Macro

The Data in REQUISIÇÃO D5 is copied and pasted to Sheet2 C2

And Data in REQUISIÇÃO D5 is cleared after paste

User can re-enter new data into REQUISIÇÃO it will copy into sheet2 D2 and so on with DATE on top SHEET2 C1, D1 and so on