creating

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

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

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

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

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

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

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

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

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

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.

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

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

Book1S1PO 2 Pay Date200-Jan-00BurnardCell FormulasCellFormulaS2=LARGE(IF(Sheet2!L:L=P2,Sheet2!EE:EE),1) So this formula is producing 00-Jan-00. I wish to create a formula on top of it so that whenever it produces 00-Jan-00, I can just replace it with "" Thus, creating a blank cell. Not sure...

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

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

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

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

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

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") =...

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