cell reference

Hey guys, I'm in a bit of a head scratching loop right now :) I will try to explain as much as i can and as clearly as i can so please bear with me on this one. I have a workbook with worksheets from January to December which are there for organizing purposes only. I have this other Worksheet...

Hi, I feel like I've done quite a bit of research to not have found an answer to this - please help! Using Office 2013 Background: I work for a company that has about 20 facilities with an employee at each that performs general data entry multiple times per week for about 300 items each time...

Hi, I am trying to make a Macro to add trackers after clicking a button. My excel is set up this way: - The 1stColumn of Row 9 is a formula that shows today's date - Row 10 has 6 Column with 6 criteria - From Row 11 to Row 2010, they are formulas for the 6 criteria on Row 10 I am trying to...

I need to create multiple named ranges for a workbook that is updated regularly. Each time the workbook is updated a new worksheet is added and it needs named ranges to make other formulas in the workbook continue to work. "Admin" tab: This tab has the name of the new worksheet that will be...

I have a project where I need to match my company's disciplines with the previous client projects. I have sheet one where I will list a client name in column A1 with disciplines used for that client in B1, C1, D1, etc. Client two in A2 with discipline in B2, C2, etc. Sheet two contains the...

Hello great, friendly & helping people! I have the following question with VBA: I am using cell references, which I usually refer like this: [irr_cf_at].FormulaR1C1 = "=ma_irr_cf_at" However, due to some strange reason, there are a few, which do not want to be referred that way! :) They...

Hi all; "Vlookprint" is the cell where the first vlookup formula will fall into. this first cell is necessary to establish because it gets resized to the correct amount of cells to do Vlookups in. I have a cell in sheet one that contains literally, "W36". So, cell T16 = "W36". The value in...

Evening, I am trying to figure out how to offset based on a cell referenced in a formula So for example if Cell B5 had the formula: "=B20", I would want in another cell, say cell A1 to look at B5, and return the cell one column to the right, e.g B21 Hope this makes sense! Thanks in advance, Ben

HI, I have the code below which works fine to update a single pivot table (PivotTable3) which is on Worksheet "P&L Analysis". The sheet "P&L Analysis" contains another two pivot tables named "PivotTable10" and "PivotTable11" which I would also like to update automatically. Can anyone tell me how...

I am wanting to create a filter for just Column AG in a worksheet titled "Darren" based off cell C8 in a worksheet titled "Control Sheet". The cell I want to reference is a value. Below is the VBA code that I am currently using but every time I run the Macro is returns a message saying...

HI all, I'm using many different formulas with row/columns reference (located in F4: Q14) the problem that i'm getting is that on daily basis i have to insert a new row (ROW 37) - Data start on row 37 - after the insertion the Formulas stay but it change the cell/columns reference. Example...

Hello, I've recorded a macro to save various files down as PDF's, but I would like to be able to make the location and filename variable, as I save these down each week in a new folder, and with a new name based on the week number. I've looked at numerous threads on how to do this, and have...

I have a spreadsheet where it shows sales in units per product on sheet A along with some other data. On sheet B is my weekly report. I also have a graph that shows the sum of unit sold per week for the last 4 weeks The data for that graph has a week start date and week end date cell and then...

Can you use a cell reference in a countifs formula? I am making a spreadsheet where users will fill in a list of names and I want to make a forumula that will countif one of those names is selected + if a checkbox is marked true = to equal one. So far I've got this as an example...

Hello ~ Can someone assist in helping me with correct formula. 1. I have 12 sheets (Jan, Feb, Mar, etc...) 2. I have a master sheet to "recap" the 12 sheets. 3. I have the first formula to read " =JAN!E49 (which means I am pulling information from Jan sheet from cell E49) Now, I want to copy...

Hi I have several worsksheets, which all basically are alike. However, there are small variations in row number for the same lines in the two sheets. I have an overview sheets, which are meant to sum up, what the different sheets amount to. Therefore i have created formulas like the one below...

Hi All, I currently have a spreadsheet that uses rectangle shapes as bar graphs. The graph's sizes are adjustable by a calculation I came up with based on start and end dates. What I would like to do now is place multiple milestones on the graph at a week by week view. There are about 600...

I got this code from another web site and it does almost everything i need but... i would like to replace the criteria1 reference (currently displayed as ="a") with the cell reference c4 in other words i would enter a value in cell C4 and the macro would use that value to filter on field 2. i...

Hi All, I am no expert on vb code and usually get by by pasting chunks of code from forums and tutorials etc. The first part of my macro, for information/ context is as follows: A .csv data file is opened and a macro started, which does the following: Open a template .xlsx file (which is...

Hello I'm trying to filter a pivot table using a cell reference as my "value", which is current week #. For some reason, I keep getting autofilter 1004 error code and cant seem to figure out why. My current code is as follows: Sheets("Pivot").Select...