make

I have a list of stock codes in randomised say A's ( out of order) , then B's etc and want to convert it to a strict A--Z list within each letter in other words, make it a proper A--Z list can some assist please thanks

Hi! Well i have a question for check keypress for multiple textbox with public sub. Heres example how i have done it now for each textbox. Private Sub TextBox1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger) KeyAscii = KeyAscii * -CLng(Chr(KeyAscii) Like "[0-9]") End Sub So i would like...

I have a report that allows users to make individual files for their reps. However there are a couple of macro assigned buttons on the tabs that are used to make new files. The code teavels with the transfer because I have it in the sheet area and not in a module. However the button...

I need one more thing <d2,"in darkness",if(h8="D2,"Under" light",if(and(h8=""><f2),"under light",if(h8=""><d2,"in darkness",if(h8="D2,"Under" light",if(and(h8=""><f2),"under light",if(h8="">=IF(H8< D2,"In Darkness",IF(H8=D2,"Under Light",IF(AND(H8> D2,H8< F2),"Under Light",IF(H8>...

If H8 is less then D2 say "Not Ready", If H8 is between D2 and F2 say "All Most", If H8 is more than F2 say "Done"

Guys, I am trying to make a spread sheet that keeps track of what I eat, when I do it and the average time between meals. I tried Excel since I'm assuming it's doable but of course, to do it, one must be able to explain it to others when one's asking for help. The actual span of a day is...

Required to make monthly revenue sheet based on the months days

Hi all, I've built a VBA macro within a .xlsm file, but I want to make the user interface look a little more professional - at the moment, when the user opens the file they see a standard Excel blank workbook with a large 'Start' button in the middle of it (not very subtle). Is it possible to...

I have an Excel bar chart I would like to make the chart axis labels hyperlink to other other charts that contain additional details about the specific tag of interest. Is this possible?

I have a workbook which currently uses a worksheet to do a lot of math for a user form. Speed, accuracy and overall performance is very stable so far. My question is, I've always wanted to do the math in memory with arrays just because I guess and learn arrays. So short of that is there a more...

I used Power Query to import file from folder. I then “close and load data” and a table appears. My question is this... Can I make changes to this table (deleting rows, etc) without having to go through Power Query editor? So far, whenever I alter the table in anyway, it will revert back to...

Hello: I have a formula in a CurrentSheet that is looping through data looking at the headers of a data table (data_table) in the same workbook for index and match. That code works fine and is below. However, I need to make it refer to another data table in another workbook for the data. That...

Hello all, I have a small problem and I just can't make it work: - in cell a1 I have a drop-down list with "yes" / "no" - I need a solution that, if the cell a1 is yes, to make me write one number in cell b2 - it should not let me continue without inserting the number in b2 - I was thinking...

Hello all, so I want to make a diagram, but would like it to be like spiderweb or something. It is interconnecting and comparing diagram. so example A1 b1 c1 d1 e1 1 7 4 5 2 2 8 10 11 3 3 3 A1 d1 4 6 B1 5 9 6 4...

=IF(I119="1",E119+J119,0) with this formula, if the value doesn't show up, instead of seeing N/A's how would i make it so I see "-"'s instead?

I have a data set with two columns of data, let's just say A1-A10 and B1-B10. I'm looking to do a countif, to count 1 time only if a value is present in both A and B. For example, if "X" is in A1 and "Y" is in B1, I would want to count this once, but if either A1 or B1 was missing their...

I need the data from a query I have, which has fields that are formulas, to be in a table. So I kind of need to do a Make table. My problem is, I need to be able to "refresh" the data in the table each time I run/update my query. Can you have VBA code that will delete the precious table...

I have a worksheet that has 70,000+ rows of data across 30+ columns. I'm trying to make a line graph to show trends from month to month. Column F contains "Direct" or "Indirect" Column S contains "Transaction Date" Column U contains "total Hours" Column V contains "reg hrs" Column W contains...

Hi I selected cells A1:A20. They are all selected and the active one now is A1. I can make A2 as an active one without losing the selection by pressing Tab key, I can make cell A10 as an active one by pressing tab key as well. My question, if A10 was the active one. How can I go back to cell A1...

any idea on how to make labels in userform look like a button ?