1. B

    Save with references to unsaved documents

    Hello, I have an excel file that gives the above warning message when saving. I've tried to find references to any .xl. files with find but this gives zero results. Is there another way I can find unsaved documents in an excel file? Thanks. B
  2. A

    Repeating same range of data

    Hello, How can I dos this? I want to repeat a range of data which contains 3 colums and 70 rows 20 times. First colum contains a reference number, same for all 70 rows, second column a vale which doesn't change and third colum the name of 70 different countries. I want this range to repeat again...
  3. G

    I need a Macro that sends out email with one cells contents

    I need to fix this code so that the body of the email texted out is actually the contents of Button!D44 Not the actual text "Button!D44" this is hat I got Sub TexwhenDone() 'Must add references (Tools > References) to ' 1) OLE Automation ' 2) Microsoft Outlook xx.0 Object Library Dim outlookApp...
  4. Y

    Find and replce takes 5-6 hours

    Like any software developer, when I make significant changes to my spreadsheet I increment the version (So Ref Stats V7 becomes Ref Stats V8. I then have to change the references in one sheet for a couple of different files. Each file takes up to 6 hours to replace the references. (There's about...
  5. A

    32 to 64 bit

    Someone has asked if an App I have can work in their 64 bit Office. (I think it's the online one). I installed 64 bit office 2010 onto my laptop to find out. Running the xlsm file brings up a pile of problem but I did manage to alter all the Functions to ptrsafe Functions. Then there are lots...
  6. D

    Structured References between workbooks

    Is it possible to use structured references between workbooks. I have a data work book which is pulling data from a table in a master sheet using row / column references and this is causing me an issue if a column gets added in the master sheet and I want to use structured references to get...
  7. A

    Vba for each cell in rng insert dynamic formula

    Hi all, this might be simple but can’t get my head around it. i would like to put a formula into each cell within a range (B2:AZ517) Then paste the value then move onto the next cell. The only thing is that the formula contains references e.g. row 1 and column A must stay constant. for...
  8. danhendo888

    Copy paste formulas to new sheet (absolute references)!AvjBsEPEq12ngUDMrgxRZFuYzsgm?e=ghaRAa Hi guys, I need to copy/paste cells M1:V14 to Sheet2 but have the absolute references point to the cells from the original sheet Is there a way to do this?
  9. F

    How do I replace all cell references with another one when they appear multiple times in an expression?

    For example here is the expression i got...
  10. AndyTampa

    Save a copy of a workbook with a new name

    I have two workbooks that I open every day. Workbook #2 relies on cells in workbook #1 . Occasionally, I need to save Workbook #1 with a different name, but when I "save as", it changes the relationship source for cell references in workbook #2 . What I need to be able to do is run a macro...
  11. B

    Return text value base on match index

    I am trying to match a range of references between two worksheets to return corresponding text string . so far I've got this but to no avail. {=INDEX('Sheet 2'!F$3;F$2000,MATCH(A1,'Sheet 2'!A$3;A$2000))} Sheet 2 A$3: A$2000 contains references Sheet 1 A1 is a reference Sheet 2 F$3:F$2000...
  12. H

    VBA/formula to show w/c date, month, quarter and year across all columns

    So I 've got a Gantt with lots of narrow little columns each of which have the date in UK short date format on that row (row 22) so that just the date shows eg '6' for the 6th of March 2019 say Row above that one (21) references the date in row 22 but is formatted to appear as "W/c Mon 05" Row...
  13. J

    VBA Updae Cell References

    Hi, I'm sure this will be a dumb question because I'm sure I already know the answer. I have written a dozen modules of code in a spreadsheet and now the main sheet used needs to be edited slightly. This means inserting 6 rows to it so all my code references are now out by 6 rows. I don't...
  14. E

    Is it possible to use RegEx in Search and Replace?

    Hello I want to use back references and regex with Search and Replace, is it possible? Thanks!
  15. E

    How to use names of columns instead of references?

    Hello I have a sheet with the first row being the titles of the columns. I want to use COUNTIFS but I don't want to use the references of the columns as these may change. I want to use instead the names of the columns. I use INDEX/MATCH to locate the name of the column I need. How can I...
  16. D

    Can't find project or library error HELP!

    Hello All, This has happened to me before, and I still have no idea how to fix it. I have looked around for an easy fix, and it usually revolves around "going to tools, then references and unclick the missing reference". My problem is that I can't open the References box, it just won't open...
  17. I

    Hiding a SINGLE row from dropdown list.

    Hello, I've done a lot of googling and can only find references to hiding multiple rows, or based off a fixed cell.. I have a buildsheet that I'm trying to hide a row based off a dropdown list, an example below: Project Management >Included >Excluded...
  18. N

    Code works in immediate window, not from button click

    Hi all, I have a relative simple sub that I am running to change the name of a reference in a cell(we are replacing a worksheet, I'm looking for references to the old worksheet and replacing the name). It works perfectly when I run it from the immediate window, but if I call it from a button...
  19. H

    Sorting Data Across Two Columns

    Hi, I'm looking to sort two sets of data so that matching pairs appear in the same rows and gaps appear where there isn't a match. The end result would look something like this: <tbody> 1 1 2 3 3 4 5 </tbody> The columns either side of these (A and D, assuming that the above are...
  20. G

    SUMIFS with Range Determined by Formula

    Hi, I want to use the SUMIFS function to add the values in $AS$1:$AS$2000 based on the criteria_range $A$1:$A$2000 and criterion in cell AZ1. Rather than selecting the sum_range and criteria_range directly (e.g. by typing in or selecting the range with the mouse) I would like to build these...

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