anchor

Hi, I have an excel sheet that has hundreds of anchors. I've tried to find a string that is exists in all of the them and replace it with another string. When I try to do this with find / replace, it doesn't detect the string even though it's in the link. Is there a way to do this? I'd rather...

Hold or anchor cell content to scroll with cell Not sure if I am explaining it right but in the attached example you can see the milestone I added do not scroll with the sheet they stay on the page no matter how much I scroll. Any ideas on how I can add them and they scroll correctly

Hi, I'm trying to figure out a way to post a date of 05-15-2019 in column AJ and fill down to the last blank cell using column G as my anchor. When I use the code below, it not only puts 05-15-2019 in column AJ but all columns and this date changes each month, this month is 05-15-2019, but next...

Hello Mr Excel I am trying to get a rolling average of income for three months. I have created the anchor for current month (which automatically moves based on current month), let's say in cell D1 and want to then average the income in cell B3, C3 and D3 - see below. If the current month was...

I'm having some trouble with data formatted in tables and doing the Index() function within them. What I would like to do is anchor some fields in a multiple Index() function I'm doing. Essentially here's the deal. ------------------------------------------- Year Month Segment Shape1...

Hi members/admin, Situation: I am a data analyst delegated the task of assembling a product catalogue. Information is to be stored in the following columns: Category - Vendor - Serial number -Text description - Image The task in theory is simple. Provide a template to the 80 companies we...

I'm trying to create a spreadsheet that uses filters and contains images. The floating images don't work properly when the filter is on. I've tried inserting the picture as a comment, but it is really slow because there are going to be approximately 8000 pictures when sheet is finished. Is there...