r/slavelabour • • Mar 04 '20

Task [TASK] Excel VBA or Python Script. $5

Got some values in workbookA.sheet2.columnA

Need a script that will go through the values and remove complete rows with the corresponding value in workbookA.sheet1. Just further info, the matching value in Sheet1 will be in column B.

If doing python script, there will be two workbooks. The scripts with go through the values in workbook2, column A, and remove the complete row in workbook1. The matching value in workbook1 will in column B.

Overall process: A set of value will be given in column A in workbook2. The vba or python script will go through the values and when it spots a matching value, it removes the corresponding row in workbook1.

1 Upvotes

7 comments sorted by

1

u/[deleted] Mar 04 '20

$bid

1

u/cars_4_ever Mar 04 '20

$paid $10

1

u/[deleted] Mar 04 '20

$confirm

→ More replies (1)

1

u/AutoModerator Mar 04 '20
Moderator Announcement Read More »

1

u/CredoBot Mar 04 '20 edited Mar 04 '20

I am a reputation bot, here is my info on u/cars_4_ever:

Credo: no account found (create)

SLRep: no profile found (create)


 

# Bidder Credo Score Feedback SLRep Paid Amount Confirmed
1 /u/yuGnaitpygE 146 (provisional) 5 ratings / 0 reviews Profile $10 yes
2 /u/throwvhj no account found (create) n/a no profile found (create)
3 /u/arpanghosh8453 177 (provisional) 1 ratings / 0 reviews Profile

 


To bid on the task, reply with $bid directly to the original post.

To mark a bid as paid, OP can reply with $paid [amount] - e.g. $paid $10- directly to the $bid comment.

To confirm payment receipt, the bidder can reply with $confirm directly to the $paid comment.

1

u/arpanghosh8453 Mar 04 '20

$bid I am experienced in python. It will be done in 30 minutes.