I used Google Sheets at work. I have one document with two sheets: 1. Active Matters and 2. Closed Matters. In the Active Matters sheet, when I select "closed" from a drop down status column, I want to move to Closed Matters (and delete from Active Matters) the entire row. How can I accomplish this in Google Sheets?

How is the Pepsi account at OMD

Hey guys! I’m working with an arts group in NYC who needs some help with their strategy post-COVID. They are severely impacted and we have a group of volunteer consultants supporting this pro-bono project on the weekends. Looking for an experienced consultant to lead a workstream for financial analysis, board management and senior leadership engagement. 2-4 hours commitment mostly on weekends, unpaid. Please reach out if interested! Thanks

Experienced hire, looking to practice cases over Skype. PST time Fri- Sunday, CST - Monday - Thur. Connect at fishbowlpractice3276@gmail. Weekend mornings; weekday evenings.

Daycare recommendations in 78750 neighborhood?

Just got fired from my first job for not having good enough work product. I work at a small town firm general practice—-litigation and municipal law — the assessment was fair I think.. just feeling like there was not much of a warning. I was catching myself daydreaming a lot and the partners questioned if I was suited for civil practice. I guess I didn’t worry enough about my work product being perfect because I thought not getting right the first year was normal, guess not

How are y’all doing? Any huge accomplishments last week?

Any openings for Banking operation services in Accenture? Right now working as a Assistant Manager for Banking operation

Can anyone refer me to KPMG??

What's your method of politely telling someone you're waiting for the machine/equipment they are using?

Looking for a gym buddy 26m at either orchard or soho eqx. Who wanna get swole

So Delta is rewarding all its SkyClub members by cutting back when you can actually use the club. Starting 6/1, it has to be within 3 hours of your flight. But worse, you will not be able to use the club after you land for a call or a quick snack unless you are on a layover.

New plant mom here! Looking for plant recommendations - indoor plants to keep right next to floor to ceiling windows, grow tall (6-7 feet), can survive with indoor heating (I live in Chicago and my apartment is heated to ~78 degrees). Thanks in advance!

What's the craziest client feedback you've heard?

29 M - Any one in Montreal for a relationship?

A fullstack developer with 13 years of experience gets in TCS. Skillsets and experience as follows: MVC .NET (10+Years), WEB API (3+), AngularJS(2+), Angular (2+) , Azure Services (3+), SQL (10+)

For my fellow healthcare workers out there.. Hyatt just extended the healthcare worker discount. Use code “THANKYOU”.

Best blazer/suit jacket brands for men? For when we can eventually travel outside of the home office.

Anyone here who has cleared Wings 1 Technology track 3 - "Machine First and intelligence business process" ?

My last working day was on 19 sept , when can i expect f&f tomorrow?

Which checking account should I get for my business? I'm two houses in, one ltr and one str where my net out per month is around 4.5k while my net in 5.2-6k? I have airbnb deposits frequently (and pge) while other home just mortgage. Looking at cap1 and chase rn do local banks have better sign up bonuses? My goal is to grow to 4 homes (probably 2 more ltr) within the year and utilize this checking account. Any advice welcome!

To all heavy Excel users, what brand laptop are you using and how’s it working for you?

Can anyone recommend good learning resources for excel? I’ve used it for years and am familiar with all the vlookups & index matches but would like to grow my skills beyond that... TIA

Dear auditors, please explain how you pick samples for substantative testing.

Right click menu. If you have a Logitech keyboard with no key to access the right click menu, press FN and F10 to pop open the menu. Very handy when you are trying to lose the mouse.

I currently work for a manufacturing company and worked my way from an entry level customer service role to a high visibility operation leadership role in 5 years. I currently handle the master schedule, forecast and SIOP process and want to expand on that… I have done all of this with only my GED… I want to grow more and I do not have the right people in my life that can direct me to the right degree. I truly found something I love to do but need the degree to open more doors. Help!

My excel columns have switched to numbers (so I know have numbers for columns and rows). This has also made all of my formulas incredibly confusing. Was this part of some update? How can I switch my columns back to letters?

I’m copying a report into workbook but the columns don’t line up to the report is there something I can do like to make it if this column name copy here. Not sure if this makes sense. I just fell like it really manual and there has to be an easier way

I’m trying to go back to the basics. How do you guys structure thoughts around identifying the correlation between 2 variables? A basic example: the number of steps I take in a day and the hours of sleep I got that night.

Can I write a macro that will fill out a table of information based on cells that have comments on them? For example, if G12 has a comment, I want to pull text from that comment + data in A12.

Looking to expand my Excel skills by learning Power Query/Power Pivot & VBA & then expand my learning towards certain programming languages (not Excel related).

I currently have access to LinkedIn Learning, but curious about Udemy and Coursera. I know about the differences between them, but content-wise, anyone have a better experience with one over the other out of three? Other recommendations?

Anyone know how to capture reference text (I.e. some reference of a particular word in a given cell with multiple words) within a Median(if()) formula? Usually I use the funky “*”&xyz&”*”, where xyz is the word I’m looking for, but isn’t working in this formula I have down:

=IFERROR(MEDIAN(IF(Data!$AR:$AR>0,IF(Data!$Y:$Y>0,IF(Data!$M:$AM="*"&D$345&"*",Data!$BR:$BR)))),"")

Been in consulting for over a year and wondering what other formulas other than index/match and vmatch is useful.

Does anybody know how to create a VBA code to automatically extract all the active data in a sheet on a different workbook without opening and manually copying to a different workbook? Ps also to create a reference cell to be able to change the file name and run macro so that it can use the reference cell to find the file and copy..

Hi, two of my colleagues keep getting a run-time error 91 when trying to run a macro on this worksheet. However, I am unable to detect the issue nor find a solution as this does not happen to me when trying to run the same macro. Any way I can find a solution?

I have a filtered date data and wanted to only copy the visible cell in column A and paste it to the next column (column B) with special paste. Because it is filtered data, I could not simple copy the whole column and paste it all at once. What is the quickest way to do this? I tried to search macro online but still cannot do it right.

I have a large dataset and when I filter, I keep getting up pop ups that say “fixed objects will move”. How do I get this to stop?

Is there an easy way to see a +/- 10% on all of my variables in a model? Is the easiest way just using a formula and creating separate columns to visualize it