anchor

  1. M

    Hold or anchor cell content

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

    VBA - copy and past to next blank cell using another column as my anchor

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

    OFFSET and MATCH? How to get rolling 3 month average of income based on moving anchor?

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

    Trouble with Tables and Index: How to anchor table headings?

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

    List of products containing images - Excel 2003

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

    Inserting pictures w/ filter, w/out using comments

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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top