populated

Hello, I have a multi-sheet workbook and I am having problems with a cell in sheet 1 that references another cell in sheet 2. That second cell is populated by means of a drop-down list and I’m sure that’s where my problem lies but I don’t know how to fix it. I keep getting the #N/A error...

I want to build a hyperlink or a macro which when clicked on will open an new Outlook email with a copy of the file and the email address automatically populated. Is this possible? Ian

I'm looking for a formula to put in 100 rows to tell me if "exclude" is populated in any of the 250 columns. If yes, then "exclude included" If no, then "Exclude not included" Any ideas?

Hi, can you help please? I have a data set that is populated with data from a set of formulas. There are multiple rows and multiple columns. The data set contains blank cells where the formula returns no results. What i want to do is to create a single list in one column that will be the...

I am trying to lock cells (starting from D16 to D2005) and only unlock the in cell in Column D cells when adjacent cells in column C has been populated with any data (text or numbers). For example if C20 has NOT been populated then D20 remains locked and if any attempt to populate D20 will...

Good afternoon, I need the code for a macro that will select an item from a validated drop down list and then break whilst a form populated from a database is populated. This then needs top reapeat 200+ times cycling to the bottom of the list until there is no more data to pull through. I...

Hi, I am trying to sort the populated data in a worksheet. Column A has a few records with the cell blank and I want these at the bottom. I have the code below. It runs with no errors but doesn't seem to be sorting correctly. Sub Sort() Sheets("XXXX").Activate ActiveSheet.UsedRange.Select...

I'm an Excel novice, so I appreciate any help anyone can provide on this. Here's the situation: 1. I have a cell on a sheet that will be either remain empty or be populated with text, depending upon the value of another cell. Let's say the text that'll appear is "Opp" 2. If the text "Opp"...

I use this on many work sheets and it works well. But i am working on a table and I think it is doing the entire possible range rather than the populated range. How can I modify this so it only works on populated cells? Sub ProperCase() awsn = ActiveSheet.Name ib = InputBox("Count What Row")...

Hello to all, We have a WB1 that upon opening evaluates cell d37 if D37 is blank then VB will go out to the network, search another wb2, and retrieve a number and apply that number to D37 of the current WB1. Next, if d37 of wb1 is populated we use this: If Range("D37").Value <> "" Then Exit...

Hello, I need help with a function to populate the right date depending on what date another cell is: I need to have either 10/1/"current year" or 10/1/"next year" populated in cell D60 based on what date cell B60 is populated. If B60 is before 10/1/"current year", then I need to have...

Hi All, I required assistance on the below. Would be great if someone could help me out with it. I have the below file. https://www.dropbox.com/s/5wzide7bso...%203.xlsx?dl=0 I have to look at the below columns I - Usage , column L - Batch creation Date , M - Batch Expiry Date and N -...

Hello, I have sheet (VAT registrations) where certain columns are populated by VBA with todays date (N and P), based on condition selected by a drop down list. I have another summary sheet with few SUMIFS and COUNTIFS formulas, with ranges the columns populated by the VBA (N and P). The...

Hello, I am trying to write some code that will calculate the days between two dates if cell in column "A" is populated. Currently i have this bit (if A is populated, Q(offset 16) should equal the difference between N(offset 13) and P(offset 15): Dim cell As Range For Each cell In...

I have an issue that is similar to the one discussed in the thread at https://www.mrexcel.com/forum/excel-questions/769002-worksheet-cells-dependant-eachother-circular-reference-problem.html; however, it stretches across multiple tabs. This is a spreadsheet used as a statistical scorecard for...

Help Please! I am trying to populate column F based of the information in columns A-E. The cells I have labeled as Yes/No will initially be blank and will have a data validation to be either Yes or No. An ideas are most appreciated! <tbody> A B C D E F 1 Build Yes/No...

I have a chart which has a data range of M$2:M$200, but often only some of the cells will be populated and the rest would be blank. I want the chart to ignore the empty cells and only chart up to the ones that are populated. Thanks.

Hello, Cell V16 contains following formula "=G16+H16-U16@ , what i want is if Cell O3 is populated then Cell V16 = 0, if not populated should run the formula. Best Regards.

I am trying to apply this formula to column AJ where column A is populated My sheet has headers and this formula will result in some blank AJ cells. Column A is always populated =IF(AK2<>"",CONCATENATE(($AK$1&": "),AK2)&CHAR(10),"")&IF(AL2<>"",CONCATENATE(($AL$1&"...

Hi All, I have the following in a worksheet "=IF(F2>=801;3;2)" It worked perfectly if the value in cell "F2" was populated from another cell on a different worksheet, within the same workbook. When the value in cell "F2" is populated from a text box on a user form it no longer works. Why...