formula and vba

with the data below <colgroup><col><col><col><col><col span="2"><col><col><col><col></colgroup><tbody> A B C D E F G H I J Reported Amt Balance Reported Amt On Acct Cust Balance (calculated col D - Col E ) Invoice Amt Due from transactions Fwd Aged Curr 31-60 61-90 91-120 121+ $...

Hi all, I have an VBA/Formula logic issue which I hope to pick your brains on. Step 1 - user completes a data table from column C row 2 onward which tells a macro how many times to duplicate the row by per column B row 2. I have a formula which then populates column A row 2 with the column...

Good Day, I wish to return either "R" or "NR" in a given column. This needs to be done on a file level (Column "FILE_REF"), so the function needs to be performed per file. If column "READY1" contains ONLY "R" values for a specific FILE_REF, then it must return "R" to ALL rows containing that...

Good afternoon, This is my first time posting a question on this thread but have seen many How To for my Excel projects. I've been using Excel for over 10+ years and VBA about 3 so it's not too often I come across something I cant figure out. I am trying to insert a variable formula nested...

I am trying to do the following, here's some images explaining it: 2: 3: The WO# never changes and never repeats. There can be 1,000s of w.o. numbers and I avoid defining definitive ranges in VBA because data is constantly added and deleted. To help solve this problem, I used this formula...

Hello , I'm trying to add codes to lines in VBA to make my sheet cleaner looking and less likely to be messed with. I'm am very new to this. I know that my range U4 has " in the formula and is causing an issue. What is the best way to solve it? Sub NewDashboardLine() ' ' NewDashboardLine...

I am trying to find a solution to this problem. I want to be able to return all of the possible combinations of numbers. A B C D 1 1 1 1 2 2 2 2 3 3 3 3 A + B + C + D return the values of A1B1C1D1,1112,1113,1121,1122,1123, through to 3333

Good morning Experts, I was wondering is there a formula or VBA solution to my issue. If i have a chart with Y and X values on the graph, is there a formula or way of automatically populating a cell with the values. Example: D29 should be the Y value from chart. Example: D30 should be the X...

Hi Experts, Please can i get your help as me and a coleaugue cant fathom a formul or VBA to undertake this. I have a challenge where i have a text data table which is like below with up to 1000 text values and i am tyrying to look up a text value and return the value 1 or 2 in the adjacent...

Hi I'm using in my sheet the following formula in column R =if(Q2<>"",VLOOKUP(Q2,Sheet2!A:B,2,FALSE),""). What it is doing is: if in column Q there is a "TEXT" and If the equivalent "TEXT" is found in Sheet2, column A, get value in column B. It would be great to have the equivalent vba command...

Hello, I have a big table of data, 10000 row and more than 20 formula fields with links to other files... I have to update this table each day by new data (I just update the first column). I wanted a way to manually update these data so it happens per field not as per row (default behaviour of...

I am trying to figure out how to create a dynamic dropdown of specific sheet names in a cell. Once a sheet name is selected, the data on the selected sheet will be used to populate the active worksheet. I would prefer not to use Data Validation. A user may create any number of sheets with...

If column B2 has Husband, B3 has Wife, B4-B5 has Child then starts over, how can I index each family unit ie: column A2 through A4 = 1 and increases with additional families. <tbody> Index Member 1 Husband 1 Wife 1 Child 1 Child 2 Husband 2 Wife 2 Child 3 Husband 3 Wife 4...

Good afternoon, I have the below VBA code which references a cell in another tab of a project document and returns the data from my SBD_Data tab. With Range("W6:W2151") .Formula = "=SDB_Data!V8" .Value = .Value EndWith However, the issue i can't seem to resolve is that the cell that...

Hello, I am trying to add the value of cells together. These cells already have formulas in them (multiplication). Some of the cells have no value because the data has not been entered yet, they just have the formulas for when the cells other cells are populated the formula is already there...

HI there, Can someone help, i have a problem where i have the 4 columns consisting of an Estimated Start Date (C19) and End date(D19) and Actual Start Date(F19) and End date(G19) for different project functions. I am sorted for the the start of point here i have in Cell J16 =DAY(F19+1) which i...

Hi, I am looking to copy 4 cells of formulas down one row. One of the formulas is an array. What I came up with copies the formulas down but they still reference the cell from the line above. I would like to add a border to the active row B:H at the end. <code style="font-family: "Courier New"...

I want the help in one of my excel dashboards where i need the automation. I have attached 3 document as per the below:- 1.My Dashboard data 2.Amit_Team Data 3.Harshad_Rec data I want the button to be set into my dashboard data file and do the following:- 1.It should open the Amit_Team Data...

ActiveSheet.Range("$A1:$W1").AutoFilter Field:=23, Criteria1:="Yes" Range("T1").Offset(1, 0).Select Selection.FormulaR1C1 = "=VLOOKUP(RC[-15],PV!C[-19]:C[-16],4,FALSE)" Selection.SpecialCells(xlCellTypeVisible).FillDown So far, I filtered my data where W = yes, and I am trying...

Dear Experts I would appreciate if you could let me know how to merge the data in 3 sheets in a new sheet based on comparing the first 3 columns of each sheet. A simple form of each three sheet is as follows. <tbody> x1 date2 date1 name abc abc xyz frt </tbody> <tbody>...