Hi,
Can someone help with macro for copying data from one sheet to another sheet of same workbook.
The workbook sample attached herewith has four worksheet 1) screen 2) main 3) Entry 4) Error, The marco will run from screen sheet . when its run the macro should copy the data on “Entry” sheet find on the “Main” sheet then paste. If the data is not found on “Main” sheet then it should paste on “Error” sheet. This is the outline.
Program requirement steps
1) Macro run from Screen sheet
2) Go to entry sheet. Take data of F & G column ( As F and G has duplication data only combination search can find exact match) come to Main screen to find the match.
a.)If match is found then check Column I is empty
i)if empty then paste data of Sheet “Entry” H /I / J column on “Main” sheet I /J/K column
ii)If not empty then look for the next match and check Column I is empty
b.) if no match is found then go to “Error” Sheet paste “Entry” sheet Colume A to J on the empty row from top.
3) The program should check this for row till end row ( lets assume 1000 or 1500 till data is there) of “Entry” sheet.
Thx in advance for your support
Regards
Bookmarks