place

I was wondering this... I want to possibly change this formula to a function in vba? I have12 sheets (months) and say 600 rows of data which below formula must act on in each individual sheet. My thought is, one place only for formula instead of 600*12 places. When row gets populated e...

Hello i was wondering if i place a Y in A1 can it = 1 in A2 or if i put a Y in A1 can that = 1 please help

Hello, I'm looking for the best way to manage a group of data record layouts where I can create one module with these record layouts, (all DIM names and types), and include them into worksheets with 30 separate code modules. I would like to modify the record layouts in one place, and have all...

Hi, I am looking for a script that will add from say G3 to G33 then place the result in G34. From there, add from G35 to G65 then place result in G66. And continue till the last used row. Here let us track the last used row from column A. Thanks in advance

I have been tasked with extracting data from SAP into an excel worksheet. I need to sort it by a material grouping(2 or more materials, as many as 5, summed together) and place it by week into another worksheet for the entire year. This will be done on a weekly basis and will constantly be...

Hi all, I have a bunch of repetitive formulas I use in my sheets. For example, I place this formula in column EE:2 on sheet "database". I dont want the formula in any of the cells as I have to do other stuff in the cells that this would normally return a #N/A. So I just want to place the...

Hello, My goal is to have a macro copy a known range (columns A:L in picture), sort them by the values typed in the yellow boxes in column M, paste the values starting in column N, ignoring null values, and then paste the format to match columns A:L. I have include a picture of the desired for...

I need help with using a table that has web page numbers. I am wanting to use those page numbers and gather the data from those webpages. here is what I have so far: (page as number) as table => let Source = Web.Page(Web.Contents("http://www.wvculture.org/vrr/va_dcdetail.aspx?Id=" &...

I have a database that I built, with the help of someone who is no longer with me. We built this tool wherein I have a massive "Active Listings" tab. The macro "Filterit" looks at the individual tabs in the workbook (ABHM, BAD, BENZ, BIRCH...etc), filters column "D" on Active Listings by that...

Hello All Excel Gurus out there, I need help with designing VBA code to do the following: <colgroup><col><col></colgroup><tbody> Example Desired Outcome *First Line*Second Line*Third Line *First Line *Second Line *Third Line *First Line *Second Line*Third Line *First Line *Second Line...

I have a sheet titled "scores". Columns are name (text), division (text) and Score (number). I would like create another sheet (Awards) that displays the 1st and 2nd place winners (highest scores) in each division from the "scores" sheet. example: Name Division Score Bob...

I have 2 sheets in my workbook for reporting. I am looking for some VBA to match a date on Sheet1 in cell C1 to a date range on Sheet2 (B:8:ABE8). When it find the date that matches it will place the value in row 10 from the cell value on sheet1 cell S6. I don't want it to erase the previous...

I have two tables. I need information on one table transferred and converted to the second table. The IF Then statement is easy. But I do not want to have to write it out 700 times. I can not seem to figure out where to place the loops and offset to do what i am looking for. Below is the If...

Using Excel 2000 Hi, Data In columns C:P, R:AE are the result columns. I want VBA or Formula which can extract only 3 first sign "1", "X" Or "2" find in the each row For example... there are 14 positions of 3 signs "1X2" in columns C:P Search for 1st sign in the row 6 there is "1" in the...

I was curious if there is any possible way to run a function within the if function such as: =IF(IS BLANK(G3),"","") but I would like to insert the function =DATEDIF($G3,$M3,"M") in place for value_if_false so if the IF is false it would calculate that formula and display accordingly

I would like to create a formula that will look at the value in D6, ie 1,2 or 3 etc) and ... - if the value in D6 is '1', then put '25' (£) into M6. - If the value in D6 is '2', then to put '25' into M6 AND O6. - If the value in D6 is '3', then to put '25' into M6, O6 AND Q6 etc I'm rather a...

Hello, I'm needing to create a chart with the ability to show where there is overlap in hours worked. For example, if an employee is working several places and the hours logged at each place overlap (thus the employee is fraudulently claiming time at once place that they're not actually...

hello all, i have had help on this before but i have added something new and can't work out the formula <colgroup><col><col><col><col><col><col><col><col></colgroup><tbody> Win Price Place Price Win Outlay Place Outlay Finished Win Amount Place Amount Won/Lost $4.70 $1.90 $50.00 $50.00 1st...

I was just curious if it was possible to turn this statement around. For example if I am in cell C2 and I want it to place the proper of john smith (which is in C1) in C2 I would type =proper(C1) and it would place John Smith in C2 what I was wondering was if it was possible to somehow switch...

Hi Everyone, I am having an issue with using Macro. In fact I had never used it before. I am having something like this: A B C D E F 50Km Dispatches 1am 2am 3am WEST 64 173 EAST 36 203 NORTH 1 37 I want my...