• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Copy and save as Values in another Sheet

fareedexcel

fareedexcel

Member
Dear Experts,

I have 8 Columns with Headers (Sr.No, ERP No, Name, BU, Dept, Company, Documents, Date) in Sheet 1.

In Sheet 1 from row 2, I will enter details in the respective columns. For eg : from row 2 to row 5. When I click a button, data from row 2 to row 5 should be copied to sheet 3 (Only as Values)

In Sheet 3, there will be only 7 columns (Sr.No is excluded).

Then again after data is copied, I need to clear sheet 1, then type another new entries from row 2 to row 6 and when I click the button,

In Sheet 3, the data should not overwrite and needs to be copied in the new blank row.

Please help.
 
Dear Belleke,

Thanks for the code. It's working perfectly. I need two more requirements for the same topic,

1. Duplicate entries should not be copied to Sheet 3. In this case, 8 columns of each row in sheet 1 to be unique. If any data changes in anyone of the columns then it's fine to be captured in sheet 3. An error Message to be pop up saying " Data already saved in Sheet 3. Duplication is not allowed"

1a. If I click sheet 3 button twice, the same entries are copied 2 times in sheet 3, If we put the duplicate control check in place then duplication can be avoided.

2. Data should not be copied to sheet 3, if ERP No column in sheet 1 is blank. For Eg:- I have entries in column G and H in Sheet 1. When I click Sheet 3 button, data should not be copied from Sheet 1 unless ERP No column has value.
An error Message to be pop up saying " Please enter the ERP No"

Thanks for your support.


▬▬▬▬▬▬▬▬▬ Mod edit : thread moved again to appropriate forum !
​
 
You must log in or register to reply here.
Back
Top