I have a workbook with several sheets.
From each sheet except Sheet1 I need to copy all the value in column H , J , K using as index a value entered in A1. Append from the first empty row in an another workbook named sales in the sheet data in colum A B C D.
Before append the macro has to delate all the rows in data which have A1 as prefix. So if A1=12 has to delete all the row with 12 in A
Thanks for any help
Example
Sheet OB
A1=12
H_____ J_____K
8141___45____24
8154___35____22
Sheet OP
A1:12
H_____ J_____K
6141___15__11
6654___38__42
In the desitination file sales in sheet data I will have
A____B____C_____D
12__8141___45____24
12__8154___35____22
12__6141___15__11
12__6654___38__42
It will be good if you attach a sample workbook also so that we can better understand your problem.
Cheers,
Arlette
If I helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks