hard

In this photo the left is a predefined structure where all level 4's rollup to their above level 3's, and so on to level one. For example every sunflower is a flower and every flower is a plant... not a tree. Well on the right is a rollup/mapping table where we go as detailed as possible with...

Hi all, I am considering to use power query to get data for my pivot table. However, I am EXTREMELY new to both pivot tables and power query. I want to import data into this pivot table (not using power query below): I have the source data saved here: So questionnaire data file 1 is week...

Hi all, I currently have a sheet that looks like this: (Please note that I have divided my excel file into two windows, so you can see both sheets at the same time). I have created a pivot table (very new to this!) in Sheet2 where I can store the data. I expect, from now on, to download my...

Dear all, I currently have this code: However, it seems that me highlighting it with bold and underlining it through the use of "<b><u>" (which has worked for me before), does not work anymore. Does anybody have any idea how I can either fix or change my code? It would be greatly...

Hello everybody, I currently have something similar to this: Linking to this: It should return the date 21-06-2019 for XG10, but it does not. Can anybody see what I did wrong and how to fix it? Would be greatly appreciated! :) Thank you! Best regards, Jyggalag

10 years + Excel experience and consider myself to be 'advanced' but can't crack this one for the life of me! All help is greatly appreciated. See attached spreadsheet.... I have a cumulative tracker of 'packages sold' in row 54 and 55 (in green) In row 71 and 72 (in yellow), I would like to...

Hi all, New member here. I have a spreadsheet with the below format. So a single workbook would have 90-100 sheets with that same format. What I want to do is to collate all the data that match 4 criterias in a single workbook: Date, Oversees Manager, Overall Status, Assigned Contractor. For...

hi, Is there any good add-on for scraping html? VBA is too hard to work with.

Hi Guys, Please help me how to align data in different columns. Please see below raw data given. C-1 C-2 C-3 A 1 B JOHN C CRUZ -Given the sample above. Can you please help me what would be the formula on this? Because, i'm having...

I need to set range using input from a cell. So below I need set range from E2 to a value that is entered into G2 instead of the hard stop at E302. Set TargetRg = Range("E2:E302")

I have an estimating spreadsheet that we use to estimate jobs. There are 80 sheets, all identical. The sheets can be quite long, and to prevent scrolling, I froze the top row, and added some hyperlinks (using the formula =hyperlink). The links I have are Top, Materials, Labor, Summary...

Hi all... i have a fairly simple problem with what i think is a pretty hard solution (at least to me) so i have a sales comission report and need to pull agent totals to another excel file. Seems pretty straight forward.... Except this report creates a new row per sale... so the totals row...

Hello: The following codes finds the last row in a table and then creates a simple numerical index starting with 1. A couple of things: ==> Is there a way to refer to column C without hard coding it so I can add and remove columns without a problem? ==> Is there a way to refer to cell C7...

I am working on a project where I have to reference different tabs of many rounds. I have formatted my index and match searches for the first round, but found that I was doing a lot of hard coding when trying to change each of the formulas for the "Round 2" tab. Is there a way that I can...

Hi, good day! Just need help in getting VBA code for this: I want to add value to a certain cell hard coded in another sheet. To determine that particular cell need to check data on D5 and data on D10.

I have read here: https://professor-excel.com/performance-excel-study/ that INDEX/MATCH or VLOOKUPS can be up to 50% faster than SUMIFS but for some reason I am having a hard time replacing a SUMIF formula with either Index/Match or Vlookup. Has anyone done this in the past...

Hi friends, :biggrin: I have to create a macro (or a formula) to do the following: I need to get the supplier name when it appears on the below cell and transport to the same cell of the part number, adding new columns for them. Column A --> is a structure index (not really important here)...

Hi I was watching a video from CFI and then downloaded cash flow model. In the video they said that, hard coded numbers are in blue and cells which have formula/function are in black. That kind of formatting followed by all financial models. My question, did they hard format that? I mean...

I have a spreadsheet that I need help writing the correct VBA code to allow for a cell containing a formula to be overwritten with hard coded data. To explain I have a cell that calculates a date however from time to time I need to override that calculated date with a hard coded date. The two...

I need help with my vlookup statement. If Cell G20 is not blank, I want my formula to return the value in one of these columns...but I am having a hard time accomplishing that...