dan

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...

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. ¤...

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...

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...

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...

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

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

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

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

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...

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...

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...

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...

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

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...

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...

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...

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...

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...

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