hi all
I attached file the expected result is put in sheet report FROM A: F & H :K so what I want when change any cell from range (a:f) in any sheet except the sheet report then copy the last entering data or any change in the values have already existed
If there is no clear please inform me
I hope somebody help
Did you also post your question at this link?
https://www.mrexcel.com/board/thread...event.1157184/
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
hi Mumps this is not mine and this is different please read good my post and see my file inside I ask the last filling data added not all data also the addresses sheets and cells by the way I was searching in the internet to find like my post accidentally I found the file as in you attach link and copy my data that's why you think this is my post
thanks
Last edited by ABDELFATTA; 01-11-2021 at 11:29 AM.
I don't quite understand what you want to do. For example, in the Report sheet you have IN1001 in D7. I assume that D7 was populated with that value when you entered IN1001 in cell D3 of Sheet2. If this is correct, what would happen if you next entered 580000 in cell E3 of sheet2? Where on the Report sheet would you copy 580000?
then 580000 should be in e7 this is relating the same row
One problem I can see is how the address is entered in column I. For example, if you enter IN1001 in cell D3 of Sheet2, then "D3" would be pasted in column I. If you next entered "omar" in cell B3 of sheet2, then "B3" would be added in column I so that now cell I7 would contain "D3,B3". In other words, each time you enter a value in the same row in one of the sheets, the cell address would be added to column I so you could possibly have something like "D3,B3,A3,C3,F3,E3" if all the cells in row 3 of sheet2 were filled in non-consecutively. It would not be practical to return "A3:F3" in column I. Would this be OK.
I accept what you suggest but keep in your mind should do that for all sheets except sheet report
Place this macro in the code module for ThisWorkbook.
Please Login or Register to view this content.
fantastic code ! many thanks for your assistance
You are very welcome.
hi, Mumps could you mod your code ? I want when I enter data clear any data are existed in sheet report before copy to it another meaning a new data should replace old data not copy to the bottom
Last edited by ABDELFATTA; 01-18-2021 at 07:06 AM.
I'm not sure what you mean. Currently, the macro copies data to the bottom only when data is entered in a new, blank row in any sheet. If you change any existing data in any sheet, that new data replaces the old data in the "report" sheet. If you "clear any data are existed in sheet report before copy" the report sheet would be empty.
I know about the macro how works when the first time fill data in blank row automatically copy to sheet report and if I change in other sheets automatically change in sheet report but what I want when I write a new data then clear any data have already existed in sheet report
every time write or change in data before copy to sheet report then clear any data are existed another meaning any fill a new data or change ,it supposes beginning from row2 in sheet report
just I agree with ABDELFATTA and the same problem and I would sharing this idea
Last edited by abdo meghari; 01-18-2021 at 12:30 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks