Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check if the same data on another sheet allready exists
Hi, I have a worksheet(1) with a lot of data in column B (rows 12 to 242, text as well as numbers) and the user can insert data in column P. When they are finished they press a button and a copy of worksheet(1) will be made. On the copy of worksheet(1), worksheet(2), the user can add rows with new data in column B (the existing data won't change) and also insert data in column P. After finalizing worksheet(2) and by pressing a button a résumé will be made. This is a new worksheet, worksheet(3). All data from worksheet(1) column B and column P are copied to this new worksheet(3). But now the tricky part. When the user has added a new row in worksheet(2) it has not changed in worksheet(1). So there should be a check if all the data in worksheet(2) column B also exists in worksheet(3) column B. When the data doesn't exist it should be inserted in the same place as it is in worksheet(2) column B. The only problem is I don't know how to do this. Can someone help me with this problem? Thanks in advance! -- leonidas ------------------------------------------------------------------------ leonidas's Profile: http://www.excelforum.com/member.php...o&userid=35375 View this thread: http://www.excelforum.com/showthread...hreadid=567483 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check if the same data on another sheet allready exists
leonidas,
Simple. Cut out the step where you use a copy of worksheet(1). Don't use Worksheet(2) - then any changes to worksheet(1) are incorporated automatically into Worksheet(3) when that macro is run. HTH, Bernie MS Excel MVP "leonidas" wrote in message ... Hi, I have a worksheet(1) with a lot of data in column B (rows 12 to 242, text as well as numbers) and the user can insert data in column P. When they are finished they press a button and a copy of worksheet(1) will be made. On the copy of worksheet(1), worksheet(2), the user can add rows with new data in column B (the existing data won't change) and also insert data in column P. After finalizing worksheet(2) and by pressing a button a résumé will be made. This is a new worksheet, worksheet(3). All data from worksheet(1) column B and column P are copied to this new worksheet(3). But now the tricky part. When the user has added a new row in worksheet(2) it has not changed in worksheet(1). So there should be a check if all the data in worksheet(2) column B also exists in worksheet(3) column B. When the data doesn't exist it should be inserted in the same place as it is in worksheet(2) column B. The only problem is I don't know how to do this. Can someone help me with this problem? Thanks in advance! -- leonidas ------------------------------------------------------------------------ leonidas's Profile: http://www.excelforum.com/member.php...o&userid=35375 View this thread: http://www.excelforum.com/showthread...hreadid=567483 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check if the same data on another sheet allready exists
Hi Bernie, Sorry, but I think my explanation was to simple. The copy o worksheet(1), worksheet(2), is a necessary step in the proces, becaus both worksheets are used by another user. Also the difference betwee both worksheets should be visible. I hope you of someone else can still help me. Thanks in advance -- leonida ----------------------------------------------------------------------- leonidas's Profile: http://www.excelforum.com/member.php...fo&userid=3537 View this thread: http://www.excelforum.com/showthread.php?threadid=56748 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
check if the sheet/tag exists | Excel Worksheet Functions | |||
How to check from VBA if sheet exists? | Excel Programming | |||
check to see if sheet exists | Excel Programming | |||
Check whether data exists in Sheet.. | Excel Programming | |||
check if sheet exists | Excel Programming |