single

  1. G

    Auto email based on cell entry

    Hello all, I have what is hopefully a simple solution to solve. I have a sheet for staff to complete entries into columns A-G a single row at a time. In column H I have a check to make sure all entries are made and return a 1 if anything is missing. In column I u have the users email address. I...
  2. T

    Verifying more than one txtbox has entries

    Hi Guys I need to ensure that if a combobox has a specific entry, a further txtbox also needs an entry The code I have used for single entries is working fine but I can't get the dual entry to work The codes I use are as below: For the single entry If cmbStatus.Value = "" Then MsgBox...
  3. sharky12345

    Track changes to single cells

    I have this which I am using to track changes to a range; Dim xrng As Range Set xrng = Range("A2:N16") If Not Application.Intersect(xrng, Range(Target.Address)) _ Is Nothing Then Set ws = Sheet1 iRow = ws.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row...
  4. A

    VBA code not auto running - protected sheet

    Hello, Im relatively new to VBA codes. I usually manage to work these things out myself, but cant seem to crack it this time...! Im using a VBA code to autosize row height for merged cells. The code (below) works when I run it, but otherwise doesnt seem to update. Private Sub...
  5. M

    Complicated VBA with 2 Conditions, 1 = Row target Sum, 2= Single number in the row

    Complicated VBA with 2 Conditions, 1 = Row target Sum, 2= Single number in the row</SPAN></SPAN> Hello,</SPAN></SPAN> I am looking some specific solution I will try my best to explain here, if it is not clear. Please ask any question I will try to make it clearer</SPAN></SPAN> There is...
  6. H

    Two Data Validations in a Single Cell

    Hi, I need to apply two data validations in a single cell. One is the name and other is a text 1) =validation_customers (This one is a named range) 2) ALL (This one is a simple Text) I would like to know how to apply these two in a single cell. Any help would be appreciated. Regards, Humayun
  7. M

    Help please assignment due tommorow !!!!! I really need the help i dont know anything.

    https://paste.pics/b10ffadd0ed8462a39d6bc8608bf6258
  8. T

    Creating Stacked Chart and Line Chart in one graph

    Hi guys... Need help, please. I was trying to create a single chart in which one set of data (premium) will show in stacked chart and another set of data (policy count) will show as a line chart. All of them will be in a single graph. I have the data here in google drive...
  9. S

    Macro to e-mail different sheets in a single mail to e-mail addresses present in excel sheet

    Existing Macro:- I have an existing macro with a send Email button on clicking it will send separate mails with single attachment to all the owner.present in the excel sheet. Requirement:- while clicking on send mail button it should first pick an owner i.e. mail recipient from coloum D of...
  10. L

    printing list of linked receipts - to single PDF - HOWTO?

    Hi, Each month I download a csv overview of creditcard expenditures and save it as an xls file. On each line I add the word "link" in column K. I then add a link to the receipt. I am on a mac. [The linked receipts are stored in a Devonthink database, the links open the relevant document...
  11. J

    Single quote disappearing

    what i have: ActiveCell.FormulaR1C1 = "=IF(ISNUMBER(MATCH(R[0]C[-1],'Hierarchy'!B:B,0))," & Chr(34) & "Exist" & Chr(34) & "," & Chr(34) & "No" & Chr(34) & ")" What i want: =IF(ISNUMBER(MATCH(G2,'Hierarchy'!B:B,0)),"Exist","No") What i'm getting...
  12. K

    Count "0" and "1" in a single cell separated by vertical bar

    Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> Data in columns C:P, need to count "0" and "1" in a single cell separated by vertical bar in the column R </SPAN></SPAN> Example data</SPAN></SPAN> Book1ABCDEFGHIJKLMNOPQRST12345P1P2P3P4P5P6P7P8P9P10P11P12P13P14EMCount 0 And...
  13. A

    VBA for Combing all data into a single column

    Hi All, This may already be answered on here, but couldn't find exactly what I was looking for... I want to take this, data pasted into Excel as rows, with varying lengths of columns (can assume I paste into Column B): <tbody> a b c d e f g h i j k l m n o p q r s t...
  14. C

    Count Email in folder + Subfolders and sorting on category.

    Hi, I would like to be able to pick a folder and then the macro/script goes through the main folder + subfolders and then also e-mails within to check their category and then post a result on how many mails were put on the different categories. I have found two different scripts that each...
  15. C

    Concatenating for pivot table

    I have two words in one cell in the data table, for example "apple pear" which have been concatenated from previous cells (in some cases I might have up to 6 entries) but in the pivot it shows as 1 entry. I need apple & pear to be 2 single entries in the pivot table. What can I put in the...
  16. L

    sorting

    I have and excel file with about 200 rows. Consecutive columns have cells with last name, first name but in between those pairs of couple there are single names. I want to sort the file in alphabetical order keeping all the couples together and listing the single names at the end and of course...
  17. C

    Convert date parts to date

    Hi folks, new member here from the UK. I've inherited a list which includes thousands of dates of birth However, the dates have been input in individual (Numeric) columns for each of Day, Month & Year (UK date style). I'd like to convert them into a single date field but my brain can't think...
  18. Dr. Demento

    Edit character AFTER delimiter and then delete delimiter

    I'm trying to adapt a function that currently uses Range.Characters and replace it with something that can be done in array. I had some ideas but it doesn't appear they were feasible. I did have one thought that I think is doable but I need some direction. I pose my myriad of questions here...
  19. M

    Sum non empty cells based on single value

    Good day experts, I am wondering if I can sum up non empty cells but it should add only single value for every group of inputs: <tbody> A B C D E F G H I J Sum 5 5 2 2 2 2 2 2 9 1 1 1 1 1 1 2 4 </tbody> Appreciate your help on this query. Thank you so much.
  20. S

    VBA Excel to Pdf

    Hi Thanks beforehand. My problem is that im trying to create a pdf from an excel sheet but I need to create a single pdf with a single page with the same sheet, cutting ranges from the excel and and pasting them on top of another... they are different tables.

We've detected that you are using an adblocker.

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.
Go back
Back
Top