Hi in the sheet attached:
if the values in column E6:E change less than 11
paste the row into the ORDINARE sheet in progression
xam
Hi in the sheet attached:
if the values in column E6:E change less than 11
paste the row into the ORDINARE sheet in progression
xam
Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Make an entry in column E and press the RETURN key.
Please Login or Register to view this content.
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 munphs1 your macro works in workbook alone
Now I inserted your macro in my macro but it does not paste the data in the "AGGIORNA" sheet
must paste only the columns A / B / C / D / E / F of the sheet "articoli"Please Login or Register to view this content.
Change toPlease Login or Register to view this content.
Where is it
Range("A" & Target.Row).Resize(, 6).Copy
Please Login or Register to view this content.
Hi munphs1 your macro works in workbook alone
Now I inserted your macro in my macro but it does not paste the data in the "AGGIORNA" sheet
Please Login or Register to view this content.
This line of code:
checks to see if the target is in column F or column G. When you change a value in column E, it does not meet the requirements of the line of code above. Because of this, the code skips all the way down toPlease Login or Register to view this content.
which is the second last line in your code. This means that the code I suggested is skipped and will never run.Please Login or Register to view this content.
I have edit in my macro so:
now worksPlease Login or Register to view this content.
only need to change paste without formatting and formulae
Last edited by xam99; 02-09-2020 at 10:13 AM.
Try:
Please Login or Register to view this content.
Work well
is it possible to add just another column?Please Login or Register to view this content.
Range("A" & Target.Row).Resize(, 5) + only column 10
Try:
Please Login or Register to view this content.
Hi mumphs1 work well
in your macro little error
Range("J" & Target.Row).Copy
a greeting and many thanks.Please Login or Register to view this content.
xam
You are very welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks