Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
don't allow row to be copied twice
Hi All,
Is there a way for me to not allow the same row to be copy over to another sheet twice? any suggestion is much appreciated! thanks, tracktraining -- Learning |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
don't allow row to be copied twice
Can you pick out a key value that appears exactly once if the row was copied to
the other sheet. If yes, you can use application.match() to look to see if it's already there. Dim myCell as range dim LookUpRng as range dim res as variant 'could be an error set mycell = worksheets("sheet999").range("x932") with worksheets("sheetthat'scopiedto") set lookuprng = .range("X:x") end with res = application.match(mycell.value, lookuprng, 0) if iserror(res) then 'not there, do the copy|paste else 'already there, skip it or merge the data nicely???? end if tracktraining wrote: Hi All, Is there a way for me to not allow the same row to be copy over to another sheet twice? any suggestion is much appreciated! thanks, tracktraining -- Learning -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
don't allow row to be copied twice
THANKS SO MUCH Again. I will give that a try tomorrow.
- tracktraining -- Learning "Dave Peterson" wrote: Can you pick out a key value that appears exactly once if the row was copied to the other sheet. If yes, you can use application.match() to look to see if it's already there. Dim myCell as range dim LookUpRng as range dim res as variant 'could be an error set mycell = worksheets("sheet999").range("x932") with worksheets("sheetthat'scopiedto") set lookuprng = .range("X:x") end with res = application.match(mycell.value, lookuprng, 0) if iserror(res) then 'not there, do the copy|paste else 'already there, skip it or merge the data nicely???? end if tracktraining wrote: Hi All, Is there a way for me to not allow the same row to be copy over to another sheet twice? any suggestion is much appreciated! thanks, tracktraining -- Learning -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copied formula produces unexpected copied results | New Users to Excel | |||
Forum copied | Excel Worksheet Functions | |||
In a copied file, | Excel Discussion (Misc queries) | |||
Copied workbooks | Excel Discussion (Misc queries) | |||
Why my cell format is not copied when I copied workbook? | Excel Programming |