1. B

    Purchase Order Generator

    Afternoon... I have created a Purchase Order Generator, and now I need to log the entries on the purchase order to another sheet before I clear the purchase order for new data. I can get it to update and copy to the log, but it keeps over writing what I did rather than creating a new row and new...
  2. J

    Creating a UDF to execute a formula

    I am trying to create a UDF that executes the following formula but I am unsure how exactly to structure the code for UDFs, more up to speed on run-of-the-way VBA macros. Any guidance would be appreciated...
  3. J

    Help creating a graph

    Hello I need help creating a graph, I have a photo of what I need - what is the best way to display a photo on the forum? Thanks Jay
  4. L

    helping creating working formula

    Sorry for naive question, but appreciate somebody could helping me. thanks
  5. J

    Date loop

    Hello: I need a sub to input last month's date into a column of data and then hard code the date. The only solution I came up with is below, but I'm wondering why it's not creating a circular reference. Thank you! I'm sure it has something to do with equivalency, but I'm still new! Sub temp()...
  6. N

    Defining an Array Within a Formula

    Greetings all, I'm looking to multiply the values returned by these 5 rounded sumproducts by the array created by "Volume!Y$24:Y$28/Volume!Y$63", but I don't know how to get the formula to recognize those 5 returned values as an array. Thank you for our help in advance...
  7. M

    Creating a macro to hide all rows containing currently selected values

    I am hoping to create a way to hide rows on multiple sheets based off the text in the currently highlighted cell. So, for instance if I am on Sheet 1 and I am highlighting a cell containing "John Smith", I want to hit a button (from developer inserts) and it will hide all rows (across all 5...
  8. R

    Need Help on creating a forecast for completion date

    Hi Everyone! I was looking for some help on creating a completion date forecast. Here are some details of my inquiry Total Callable Records: 60,000 Total Agents: 34 WorkHours/day: 8 hrs (weekends are not included) Start Date: 8/5/2019 I want to determine the date of completion with an...
  9. L

    Test Plan FOR Excel Workbook

    I maintain an aged workbook for my company that is twenty years old (approximately), containing over 20,000 lines of code. There is no documentation for the workbook. I am having difficulty successfully publishing updates to it because there is no test plan. If anyone has a guide, or a link...
  10. J

    Creating separate workbooks using a macro

    Respected users, Can we create a macro which would help us to create separate workbooks; for example, we have workbook named A, can we create workbook B and workbook C using a macro function in workbook A? If not, is it possible using excel related time saving tools? Thank you.
  11. J

    Macro keeps creating a charts for interger 2 rather than looping down a list.

    So I have a basic Macro to select some data and create a chart - this works perfectly. The problem I have is that I need to create 78 of these charts. I am trying to get Excel to update the chart data for each estblishment based on a single reference cell that drive a host of VLOOKUP and...
  12. M

    Creating Pay Bands in excel

    Hello Please could someone advise how best to create the following pay bands in excel: <colgroup><col></colgroup><tbody> £0-7,550 £7,551-9,925 £9,926-12,500 £12,500-17,500 £17,501-22,500 £22,501-30,000 £30,001-50,000 £50,001-100,000 £100,001- My data is 4500 lines with pay...
  13. danhendo888

    Help with IF formula using a date created by a formula

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /></colgroup><thead><tr style=" background-color...
  14. H

    Day and Date in same cell

    Hi Everyone, I am looking at creating a roster with a month to a worksheet and say starting from A3 list each day for the month down the A column, which is easy. What l am having trouble with is creating a formula that will list each day in each row of the A column (for example January would...
  15. D

    Creating names under Formulas>Define Name issue

    Hi Everyone, I have a problem, I tried creating a new Define Name but the name I'm gonna use look like this... SBC(D255) but when I create, it says an error The name you entered is not valid. Is there a way for me to use these ( ).? Thanks for your help
  16. J

    default to not move or size shapes?

    Is there a way, like creating a template, that will default to"do not move or size" shapes"?
  17. JackDanIce

    Partial array slice

    Hi, Have a 2D array R x C in size, C max (column count) = 14. Is there syntax (without explicit ref e.g. arr(x,1) & arr(x,2) & ... & arr(x,8) ) to join first 8 columns per row? Psuedo code: myKey = LEFT(join(arr), 8)where 8 represents 8th column (not 8th char!) Ideally, without creating a...
  18. A

    DTPicker Issue

    Hi, Expert I am new in a Excel. I went to get you expert solution for creating VBA on DTPicker Tool. When is used a DTPicker in a UserForm then showing creating date but i went to show hear as current date & to be change if required manual. I do not do it. Can any one please help me to solve...
  19. C

    creating a simple userform

    Remember I'm a newb so if I sound ignorant it's because I am, lol. Ok so I'm creating a simple user form that will be using a bunch of text boxes to input data into specified cells. So the code for each one of the text boxes look like this: Private Sub TextBox1_Change() Sheet3.Range("b1") =...
  20. S

    Creating a New Sheet with all relevant data from a different table.

    Hi, is it possible to create code to go through a table and if a value is met transfer the whole contents of the row into a new sheet totalling all relevant values. For example creating a sheet with all the row information for every row that has the value in Column F higher than 0? Thanks in...

Some videos you may like

This Week's Hot Topics