dan

  1. Dan Wilson

    Forum privileges

    Good day. After writing a rather lengthy question, I found out that I am not allowed to attach documents to my post. What privilege do I need to be able to do that? Thank you, Dan Wilson...
  2. M

    Subtracting from a total and show remaning

    Hello, Ok so what I am trying to do is, I have a total of 500. And I have different accounts I want the 500 to come out of like for example: (A1) (B1) (C1) Dan. 100. ¤ Bob. 50. ¤ Mark. 50. ¤ John. 25. ¤ Alex. 200. ¤...
  3. S

    Formula to count dates in column C where there are specific values in same row on column A&B only

    Hi, I hope someone can help me; I’m tearing my hair out trying to get this to work. I am trying to put together a table to measure progress made by a number of individuals to completing their tasks for a given month. In this summary table I will need to count the number on nonblack cells in a...
  4. E

    Search and Return References from Multiple Workbooks

    I have multiple workbooks for each month (Named January, February, March, etc) with sheets within the workbooks for each day (010119 for January 1st 2019, 010219 for January 2nd 2019 for example). In each sheet is a list of people who have registered and paid for a sport (see below). Some...
  5. N

    Transposing and compressing data

    Hi, I am exporting from a database as a csv which provides the following ID,NAME,RATING <tbody> ID1 BEN 1 ID2 BEN 1 ID3 BEN 2 ID4 BEN 3 ID5 JAMES 1 ID1 SAM 1 ID4 SAM 2 ID2 DAN 1 ID9 DAN 2 ID10 DAN 2 </tbody> I need to transform this into the following <tbody> ID1 ID2 ID3...
  6. D

    Conditional Formatting based on a few different possibilities?

    Hi, I was wondering if it is possible to have a formula to do the following in conditional formatting. If A1 value is "JP" or "GB" and E1 has a value of either <244 or >265 the cell turns red. Any help would be much appreciated. Thanks Dan
  7. D

    How to get the second to last value cell in a column?

    Hi, Please can someone help me? I would like to get the second to last value in column C. I have this code so far but it just gets the last value. TextBox3.Text = Range("C" & Rows.Count).End(xlUp).Text Any help would be appreciated. Thanks Dan
  8. C

    Formula with multiple IF's?

    Hi There, I need to do a simple calculation between 2 cells in a table. Column headers are "Weight in" and "Weight out" I simply need to deduct weight out from weight in and only want this calculation to be applied when both cells contain value and weight out is less than weight in . Thanks Dan
  9. A

    Train Graph

    Morning all, Strange request.. I have seen a graph that is basically a train that moves along when the data changes and wondered if anyone can help me replicate it. Thanks Dan
  10. D

    vba refresh query table

    Hi, I am trying to refresh a querytable using vba and the vba code i am using is the following: Sub RefreshEmployee() ' ' Sheets("Employee info").Range("A1").ListObject.QueryTable.Refresh BackgroundQuery:=False End Sub But I get an run-time error 91 (object variable or with block...
  11. S

    Compare Columns in sheets and report values

    I am hoping someone can guide me in the right Direction, I have got the basics of Vlookup, but want to take it a stage further I have two sheets with identical entries in columns a - c A= Organization Name B = User Name C = User Email <tbody> Organization Name User Name UserEmail...
  12. D

    VBA code to stop 2 entries not being signed off

    Hi, Please can someone help produce a code to do the following: Column I = Scan out QTY. Column J = Sign off userform triggers when there's a value in I Basically what I would like is to prevent there being 2 values in column I that haven't been signed off. I hope this makes sense and any...
  13. A

    Restrict Excel Access

    Hi, I have a Workbook that i would like to restrict access apart from certain users. I don't want it to ask for the username and password i would like to it auto detect the username of the person and if they are on the list allow access and if not it wont allow them in the document can anyone...
  14. B

    scrolling within a long comment needed

    Some of the comments in my cells are very long. Is there a way to immediately scroll to the last line when I open it? Also, once the comment is opened is there a way to do a find within it and have the cursor position itself at the found line? Thanks in advance to all those who reply. Dan
  15. D

    Formula help

    Hi Everybody, I'm looking for a formula to look at duplicates in column A and return the lowest # in column D from those duplicates. I also need it to ignore the cells with "#N/A". The answer & formula will be in column E. Hopefully, I've explain that well enough. Below is a link to a screen...
  16. R

    Establishing a Pattern, then Repeating the Pattern, based on User Selected Data

    I have an inventory of items in a sheet named Working Population. I would like to write some code that allows someone to select the names of the Associates that are in the office that day, then have Excel auto-enter those names into column E (the same process would happen in column J, but with...
  17. A

    Merge Multiple column from different sheet and highlight the row with unique value.

    Hi, I have multiple sheet in given workbook. Each sheet filled with Column A:E with same number of rows. I would like to combine all these sheets into one sheet and highlight the row for the column header named as "Order" with "Yes" option. Sheet1 <colgroup><col...
  18. Dan Wilson

    Organizing Macros

    Good day. I am using Excel 2013 on Windows 10. After creating several Macros in one Workbook, I find that the macros are spread over different modules. Is there a way to move all of the macros into one module so that the script of the macros can be printed out? Thank you for any help. Dan...
  19. S

    If Cell A is X, how to auto populate outcome?

    Hi all, I'm creating a spreadsheet with a list of different names and a rating associated with those names. I have the "master list" in order with the names in column A1-A32 and their rankings in column B1-B32. Now in C1-C50 I have all of those names in the A column but randomly assorted. How...
  20. D

    Text Date to Date

    Hi all, I have cells with the following date format "3 Aug, 2017 10:00AM" Is there a simple way to split out the date? Dan

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