references

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

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

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

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

on trying to close one of my files, I get the "can't find project or library" message. there are no macros used in this file. I can then not open the References list from the Tools menu. I click on Tools and nothing happens. If i force close excel and then come back in using a different file...

Hi All, I do hope somebody can help me? I have formula references in cells, such as: <colgroup><col style="mso-width-source:userset;mso-width-alt:4386;width:96pt" width="129"> </colgroup><tbody> Deliveries!T25 Deliveries!AZ25 Deliveries!CK25 Deliveries!K26...

Hi, Hope someone can help with below macro. Thanks in advance Iteration 1 Sheet 2 includes formulae with cell references to row 1 of Sheet 1, a second macrox runs with these cell references Iteration 2 Sheet cell references are updated to row 2 of Sheet 1, macrox runs again Iteration 3 Sheet...

Hello In my example, I have a list of fields (name, address, phone, etc.) that I transfer from an inputs worksheet and use VBA button to save it to another sheet for the database reference. So, it starts at J5. Then it is on other columns on the sheets. And there are a few locations for...

Hi all, We have some legacy workbooks that have numerous Consolidation references that need to be removed. The references can be deleted manually using the Data tab > Data Tools group > Consolidate button A web search shows some examples of how to Add Consolidation references using VBA, but I...

So here's the deal, I work for a company that does "floor lifting". I.e. when a house has sunk we come in and do measurements, and give people an estimate of what we can do, and a recommendation. One way we collect measurements is by placing different height values at x, y locations in an excel...

Goal: Copy unknown # of sheets in a workbook that cell formulas references the previously copied sheet. NOTE: I need to Lock the sheets and protect the workbook, but cannot get it working protected or not. I have a master sheet in a workbook "PR1" that I have filled out, I also have "PR2" that...

Hi All I have a very large workbook with a large volume of validation rules across multiple sheets. The validation uses custom hence standard formulas that evaluate to either TRUE/FALSE. I would like to extract all of the formulas in to a single worksheet. In doing so I find a problem in...

Hi All, I am trying to figure out a better way to get monthly totals for data imported from a Gantt chart into columns A to D. I added a hidden reference column that gets imported to column A in Excel. The table in the image below needs to show the monthly orders for: Australia which...

Worksheet 1 contains data I want to sort. WS2 contains relative cell references (=) to WS1. When I sort and filter WS1 the cell references in WS2 do not change so the data in WS2 is incorrect. How do I solve this please?

When dragging, I want the reference cell to add 57 rows each time. For instance, if I were to use the OFFSET function. The first use of the OFFSET function references B5. The next row down, I want it to reference B62 and so on. See below. =OFFSET(B5,3,6) =OFFSET(B62,3,6) =OFFSET(B119,3,6)...

gafc2012 08:21 PM Yesterday Hi, This is probably very simple but i'm stuck I have two sheets, both with References and Amounts in Columns A and B. I would like to subtract the initial amount in Sheet1, Column B by the first amount in Sheet2, Column B providing the References match. So in...

I'm trying to use .PageSetup to get a few pages in a workbook ready for print, but I'm having trouble getting the expected response with Title Rows, and I can't find a good code example for using VBA to insert a header (and footer) with cell references. Below is the code that I have, and I need...

Hi I'm trying to figure out code to copy and paste a set of formulas across a bunch of columns and then down to the end of the range. I can figure out that part with VBA, but I can't figure out how to set the formulas so that the cell references don't get messed up in VBA. It's just a simple...

Hi all, I have a markbook that is pulling in data from an external reference. There are a lot of external references in the markbook, and quite a few versions of the markbook (for different departments) all referencing the one data sheet. What I seem to be experiencing is that the markbook is...

Hi, Is there a way to do absolute references in Power BI like there is in Excel. Essentially I want to be able to always reference a single cell value in a table visual. Thanks!