Hi
I am creating a spreadsheet where people will fill in details for certain things, my idea is to have them add rows as they go to each of the tables within the worksheet. However, when they add rows to the first table, this now means that the insert point I chose for the following tables is...
Hi,
Looking for some help, if I have a simple formula like =A1 in cell B1 I want to write some VBA code so that if I select B1 then run a macro it will then select A1. Slightly more complex as what I have in B1 actually refers to another workbook e.g. ='[book1.xlsx]sheet1'!A1 and I want to...
Just started using Excel Formulas and I'm using this to get sums across 3 sheets.
In the following Section, B3 and L3 are not updating to B4 and L4 when dragging down a row
Any help would be greatly appreciated.
Hi,
I have a large data ranging between 200k-400k row every weekday to analyze.
I need to get result for Column P, Q, R, S, T, U , V, W, X, Y from Row 2 to Row 7201 (sometimes until Row 1441 , 481 ,241 ,121 depend on what kind of analyze is).
Current formula I use is "...
I have a workbook with 25-30 worksheets and every single cell that would have a cell reference uses a named range instead. I am trying to replace them all with cell references using the following macro (found on google):
Sub AbsoleteNamesWithRelativeRefs()
Dim Rng As Range
Dim WorkRng As Range...
I am looking to create a dynamic range that I can manipulate in VBA for sorting purposes. I have the following code:
Dim x As Range
x = Sheet1.Range("A2").End(xlDown)
Sheet1.Range("A2:" & x).Select
I would then put my sorting code after the selection. How can I make the...
Hello all!
I have this portion of code that seems to work, however I need instead of a fixed item like "California", I need it to reference a sheet and a cell instead. I feel like everything I've tried isn't working, and its probably something super simple that I'm doing wrong.
For...
Can anyone help me please,
I'm trying to find blank cells in a range (O2142:O2206) and the get reference to those cells.
And is there a way to only get reference to the row.
see image below:
I want it to look for the blank cells in column O (Date Job Delivered) because if there is cells...
Hello all,
Could some one please assist, I would like to have a spreadsheet with cell references that refer to another spreadsheet stored under a different user.
Example
Network user 1 - master file
Network user 2 - copy of master file with fewer data.
Copy file to have cell reference that...
I have a button on a workbook template that will save the work book and attach it to an email. I want to incorporate the ID number into the subject of the email. This number is changed each time the template is used.
For example: If the ID number is 000001, I want the email subject to read...
Hello,
I'm trying to text in the advanced editor with a cell reference from a sheet in my workbook. I'm constantly having to manually update the advanced editor in 25 different tables which is taking me ~30minutes to run a report. Is it possible to do a cell reference for this? I've highlighted...
Hi,
I need a VBA code to autofilter list of values reference from a different sheet. The filter condition is such it should contain the values in the referenced cells not equal to the value in the cell
The code I have been trying is as below
Worksheets("ZBA extract").select...
Hello,
So I am having an issue with formatting after copy and paste.
My process is I copy a an entire row from one workbook and paste the row onto another workbook. Where I paste it is in one tab which I call "RAW DATA". I have another tab, my "Platform", that uses cell references or VLOOKUPS...
I have Column A that references another column on another tab.
So I have cell A10 referencing W2 on tab 2. I want column A to change automatically when Column W on tab 2 changes (i.e.- a row is deleted) and not display any errors such as #REF . I understand why it does that, but I don't know...
Hello - i have an excel file that has numerous tabs. Each have a name, what i am trying to do is in the main sheet, enter in the tab name so that the info that is copied will paste to the correct tab. see code below - i get an error on the top line. The Tab will change each time i go into the...
Hi,
I am a beginner at excel. A number of months ago I created an excel file, used for sorting quantity data.
The first sheet is used for importing (pasting) the raw data. This raw data is then sorted into other sheets depending on the "Product Type" column.
I have since introduced two new...
I thought this was straightforward but it does not seem to be. I have a two spreadsheets and in one (call it S1) I get a calculated value in column C. In the other (call it S2), I want to link to the values in column C.
If, in S2 B10, there is a reference =S1!C10, and I sort S1, how do I...
I have an interesting one here. I'm looking to try and substitute the text from a cell into the measures portion of a CubeValue formula in Excel. The CubeValue references data from a related sheet in PowerPivot and I'm bringing over multiple columns of numbers so it would make life easier if I...
In case possible, how do I make a cell's value reflect in another cell and have the capability to edit the value on either cell? For example, I have cell A1 in Sheet 1 and A2 in Sheet 2. I want it that when I put "Pass" as the value for 'Sheet1'!A1, the same value appears in 'Sheet2'!A2...
Hi Folks,
I am assessing the values of several thousand data sheets. So far, I am running a macro to conditionally highlight cells of specific values, then writing down the table location. I am trying to expedite the process by getting Excel to list the cell names for me. I named each cell...
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.