LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Macro deleting rows based in main sheet on values in another sheet

Hey guys

I have a sheet REGISTER as main sheet.
In this sheet there is cellvalues in column C which i want to check.
If the value in celle Cx (sheet REGISTER) are to be fond as any value
in the sheet DELETE columnd C (except row 1:1 in both sheets=header)
this row in sheet REGISTER will be deleted.

I am capabel to delete rows with one particular value, but dont know
how to delete all rows checking a delete-reference table

Example of Register sheet:
Col A Col B Col C
Col D Col E
ÅrAns AnsHÅr ÅrUkePrd Uke-Prd Ansatt-År-Prd
2012-74 74-2012-2 2012-29-1 291 74-2012-291
2012-540 540-2012-2 2012-29-1 291 540-2012-291
2012-8029 8029-2012-2 2012-41-2 412 8029-2012-412
2012-189 189-2012-2 2012-41-2 412 189-2012-412
2012-301 301-2012-2 2012-41-2 412 301-2012-412
2012-8029 8029-2012-2 2012-43-2 432 8029-2012-432
2012-900 900-2012-2 2012-43-2 432 900-2012-432
2012-301 301-2012-2 2012-43-2 432 301-2012-432
2012-301 301-2012-2 2012-50-2 502 301-2012-502

Example of Delete sheet:
Col A Col B Col C
Col D Col E
ÅrAns AnsHÅr ÅrUkePrd Uke-Prd Ansatt-År-Prd
2012-900 900-2012-1 2012-21-2 212 900-2012-212
2012-346 346-2012-1 2012-17-2 172 346-2012-172
2012-67 67-2012-1 2012-19-2 192 67-2012-192
2012-1250 1250-2012-1 2012-23-2 232 1250-2012-232
2012-996 996-2012-1 2012-22-2 222 996-2012-222
2012-74 74-2012-1 2012-20-2 202 74-2012-202
2012-149 149-2012-1 2012-18-2 182 149-2012-182
2012-92 92-2012-2 2012-27-1 271 92-2012-271
2012-572 572-2012-2 2012-47-2 472 572-2012-472
2012-160 160-2012-2 2012-39-2 392 160-2012-392
2012-197 197-2012-2 2012-30-1 301 197-2012-301
2012-826 826-2012-2 2012-34-2 342 826-2012-342
2012-171 171-2012-2 2012-35-2 352 171-2012-352
2012-1076 1076-2012-2 2012-36-2 362 1076-2012-362
2012-8062 8062-2012-2 2012-49-2 492 8062-2012-492
2012-894 894-2012-2 2012-31-1 311 894-2012-311
2012-402 402-2012-2 2012-28-1 281 402-2012-281
2012-65 65-2012-2 2012-37-2 372 65-2012-372
2012-176 176-2012-2 2012-26-1 261 176-2012-261
2012-262 262-2012-2 2012-44-2 442 262-2012-442
2012-169 169-2012-2 2012-38-2 382 169-2012-382
2012-86 86-2012-2 2012-52-2 522 86-2012-522
2012-8068 8068-2012-2 2012-51-2 512 8068-2012-512
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Populate excel sheet based on values in a separate sheet Andi Excel Discussion (Misc queries) 3 September 17th 09 02:53 PM
Hide rows of one sheet based on values in another sheet? Andrew Raastad Excel Programming 2 June 23rd 09 11:11 PM
Advanced Filter vs. Macro for deleting dup rows in sheet Kermit Piper Excel Programming 2 June 18th 06 11:04 AM
how do I hide rows in excel based on values input on sheet ? tbo Excel Programming 1 March 21st 06 04:12 PM
how to find and copy values on sheet 2, based on a list on sheet 1 evanmacnz Excel Programming 4 February 7th 05 08:33 PM


All times are GMT +1. The time now is 02:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"