Hi all!
I have a file that is full of hyperlinks to different files in another folder.
I moved the location of tbe original fil and hyperlinks stopped working.
Now I also want to move the location of the hyperlinks folder.
Is there a way of fixing the links? (File names are still the same)

What junk foods are getting you through these strange and unprecedented times

Should I expect a signing bonus when moving to a new job within the same (very large) company? Job is in a totally different area of the organization. Expecting the offer soon and trying to gauge what’s normal!

Hey Fishes,
Been working at D India as a Manager (Not USI) for past few months.
Ask me anything as there are very few reviews available online.
To clear few misconceptions
1. Global projects are available here
2. They've started mentioning Bonus, Gratuity amount etc in offer letter
3. Work life balance depends on Project and managers you work with
4. Inside opportunities if you're the creamy layer
5. PF amount in offer letter is the total deduction and not just company's contri

Other can add

Hi Boshlers,

I joined in July month.

when will I be eligible for salary revision. Please tell me. TIA.

Does anyone else here have a career in academia? Is the salary worth it?

I am currently 100% remote and went through training and onboarding 100% remote. I am now looking for a new job and I have found remote work is really competitive. Any tips for how/where to apply? I am applying for content and copy writing roles all around the US as long as the are remote.

Settled a case at presuit mediation. Payment was to be made within 21 days. We are now over 30 days out, and all OC will tell me is that he requested the settlement draft and will let me know when it arrives. At what point do I file a complaint to enforce the settlement (and to seek fees and costs)?

Any views on a Sr Tech Prod Mgr salary for Natera? Do they offer joining bonus / stocks

⚠ OFF TOPIC ⚠
GYM 🦈 please suggest diet chart for fat loss (vegetarian) & (office going)

1. How can I build 6 pack abs on vegetarian diet and I'm not interested to take creatine or any cutting steroids. How much time will it take.

2. How much weight should I lift and how to improve weights in gym for weight training.

6 feet height
80kg weight
22% body fat
4 months gym

With the new travel advisory to US travel from India, do we still need to obtain NIE for parents to travel?

Inherited stocks that I want to sell and then invest in index funds. Better to sell today before end of the year or wait until next week and not have to deal with taxes until 2022?

Omg so happy to find this bowl!!

Hey all, is anyone willing to refer for roles in Capgemini/Bain/McKinsey/BCG? I am happy to share my CV, and would appreciate any constructive feedback. Thank you!

What happens when we start outing recruiters by name who've ghosted us after scheduling an interview/time to talk? Would it make any significant change in behavior or accountability?

Do you have any pointers for an associate looking to move to Dubai?

I am in my seventh year of practice. I was admitted to the bar in March of 2015. My main areas of practice are Corporate, Commercial, Banking and Finance (mainly asset finance - aviation), and Projects. 

I am looking for a paying placement in Dubai (currently based in Kenya working at a Chambers, Legal500 and ILFR ranked firm that is a member of an international network of firms).

Your advice will be highly appreciated.

Hashedin by deloitee how is this company

Has anybody used muthoot gold point for cash for gold ? If yes how it is ?

HCL or IBM

Hello,
Hope you're doing well!
I need referance for position of business analyst ( job id - 167210) @ Amdocs it will be very helpful for me if u refer me.
Kindly consider it

I have two offers one from IBM another from Persistent. Persistent is paying 2 lakhs more than IBM. Although IBM is giving 2 lakhs joining bonus.

I'm into Salesforce Development with 5YOE.

Which one should I go with?
People say IBM doesn't give any hike. Is it the same even for Salesforce practice?

And anyone knows hows Persistent?

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)))),"")

Is there a text to rows (instead of text to columns) trick?

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.

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

Can someone help me with recoding surgery question into binary variables? I’d so appreciate your help! TIA

Is there a way to wrap your header text within access database?

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..

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.

Can you use the SUBTOTAL feature with formulas as well? Such as IF statements

Best way to pick up LBO modeling? Recommended resources, tips, tricks are appreciated

Index Match > Vlookup

Anyone work on a Mac and use parallels when in need of excel? If so, does it work or is it a big no-no? My work going forward will not primarily be excel, but I have to use it on weekly/monthly basis. Might also have to use some Power BI. Would love to go back to working on a Mac but excel has stopped me from buying one…

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?

What’s your Excel horror story (worst crash, worst mistake, worst there-was-a-way-to-do-this-quicker moment)? Extra points for self-shaming

I was sent an Excel skills test to complete as part of a job interview process (through Test Genius if it matters). I've had some assessments in Excel that I've bombed, and I've aced off the top of my head. I'd like to get in a quick review before taking this assessment, but I'm worried about not being prepared. Any good resources for practice, and/or tips on what topics these assessments typically cover?

I have an idea- unsure about the execution...

I have an Excel worksheet which has a table of items, i.e., a stock count of items available.

Is there a way to link this table to Microsoft forms/sharepoint whereby someone can request an 'x' amount of stock from this summary table and whatever the requestor asks for, once approved, is automatically deducted from the table of figures and the corresponding items

I appreciate that there is a lot of automation in the above. Would welcome any advice

I am trying to create a formula based on data type geography. I want to ba able to write if(cell=NY,,) but I get #value.

How do I get formula to recognize the text of a geography data type?