named rage

Good day - I have a code that needs tweaking for it to work as I intend it to, since I am very green when it comes to coding, I am asking for your assistance. Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("Database").Columns(2)) Is Nothing Then If...

Hi, Hope someone can help. I am trying to create a formula to lookup data in an input sheet and create a summary of key info and gap analysis. the table looks simply as follows: <tbody> <tbody> Input Table REF Region PM Wave Ref 1 Region 1 PM1 Wave 1 Ref 2 Region 1 Wave 1 Ref 3...

I have a spreadsheet with nearly 5000 defined names. We have a code that transfers filled out information from the template, to the most recent release of that template to capture any changes in sale prices or new items. So they are both the same spreadsheet except the most recent template has...

<tbody> List No. Name 1 Pablo 2 Pepe 3 Luis 4 Juan 5 Manuel </tbody> Hello everyone! Let's say I have an small array as shown in the table and I want to create a named range for each column with all its elements. When I use the "Record Macro" tool it turn out this: Sub...

Hi all, Newbie to the forum here. Wondering if it is possible to include a Named Range within a Calculated Field in my Pivot Table. The Named Range is "Period". Essentially, I require a calculation which looks at the field "Actual Entered Amount" / "Period" * 12. This field would then be...

Hello All, FYI: I have a couple sheets that have 12 to 15 groups of grouped columns, these have replaced 24 to 30 separate sheets. Other sheets, say the Cashflow sheet, link to the two sheets with loads of groupings. I/the user often double clicks or "ctrl-[" to jump from the Cashflow sheet...

I am trying to create a VBA to copy a value from an specific cell and worksheet (example: cell A1 in worksheet "Info"), to the first available row in a specific named range ("test") in worksheet "Data". So far I have gotten this but it doesn't seems to work: Sub SaveData() Dim ws1 As...

I've used named ranges to create charts before but lately I seem to be having some trouble with it as i've got a couple named ranges (one for each series pretty much) which relate to the proper data but when I put the named ranges into the chart, I get the error message "A formula in this...

Hello - Here is a formula which returns the value from another sheet found at the intersection of a column range (d12.31.12, which is a date) and a row range (Room250, which is a location). =(INDEX(d12.31.12,ROW(Room250),)) I have 52 similarly named columns (one for each week) and a dozen or...

Hi, My Excel sheets need to have a number of conditional drop down lists. To do this I currently use a fairly lengthy process of =INDIRECT formulas with Data Validation. I want to start using PivotTables more but I wish that each filed within a PivotTable was a named range that would update...

I'm trying to learn more about the SUMIFS and COUNTIFS functions and am practicing with some hypothetical data. I have data about the number of gallons of paint sold in 4 regions. In my hypothetical situation, I need to find out the number of gallons sold in the Northeast region during the...

I'm trying to copy/paste date from one range to another. The following code works fine for me until I assign it to a command button. When I assign it to a command button, I get the following error: Run-time error '1001': Method 'Range' of object '_Worksheet' failed Any thoughts on how to...

I have a sheet, where range f26:r26 is named as EBIT Now, I am trying to get a YoY growth in EBIT I tried using this =EBIT/Offset(EBIT,0,-1) -1 However, it returns 0 Essentially, I need to refere a cell which is 1 column to the left Any ideas?