code & formula

Hi everyone, I am trying to write a code or function that will index the the time. I have data ranging from January 2012 to December 2014. I'd like to place in a column nearby it that if it's Jan-2012 then give me 1, if Feb-2012 then give me 2,...,Dec-2014 give me 36. Is there a way to do this...

Hello, I have been trying to work on a solution for a week and a come close but no cigar. I have a user form that the user enter's in their %'s for specific fields. Not all textboxes will have a %. What I'm trying to do is not allow the sum of all textboxes to exceed 100%, if it does, all...

Regular Formula: =VLOOKUP(A1,'SomeDrive:\SomeFolder\SomeSubFolder\[SomeFileName.xlsx]SomeSheetName'!$A:$K,11,FALSE) The Formula I need: Like =Vlookup(A1,GetPathofFileVariable(SomeFileVariable) & SomeSheetname!$A:$K,11,FALSE)

Please help ! I want the macro to go through all the files in a sub-folder and look-up the file names mention in the another excel sheet "Sample 1", and open and paste the "name" in "A2" and "no" in B2. "Sample 1", A B name no. Central 5656 Sustainable...

Hello, Please be patient with my verbiage, as I am new to VBA coding, I appreciate your help GREATLY! I've done the best research I can do on these threads, but I can't seem find one specific to my quest. Goal: To write VBA code that opens the most recent file created in a specific folder...

I am using the following code to highlight the active row in my spreadsheet while not losing my previously set background colors. The issue is when I save the document the previous active row stays yellow. I tried to use the "beforesave" in the workbook's code, but I don't think I did it right...

Background: I am a new intern at a custom interior design company and I have been hired to streamline and simplify the process that they go through with tracking inventory and the time spent on different jobs so they can calculate their job costs accurately. I have spent days working on this...

i need help on 2 lines of code Sub sendemail(subject_line As String, mail_body As String) Dim olapp As Outlook.Application Set olapp = CreateObject("outlook.application") Dim olMail As Outlook.MailItem setolmail = olapp.CreateItem(olMailItem) olMail.To =...

Hi All, Here is the code I am using to find duplicates amongst certain cell values ( max 12 here). I have been able to implement it but by using a variable in the R1C1 style formula. Here is the code: dd = -1 * (12 - Frozen) ActiveCell.FormulaR1C1 = "=IF(SUM(IF(FREQUENCY(MATCH(RC" & dd...

Hello All, I have been slowly learning to build Macros and cannot seem to comprehend enough to tie it all together for this project. I have a worksheet with 85 Vendors (currently but will grow) all in column D. My worksheet varies from week to week but can be 5000 rows at times and will...

Hello, Today I finally taught myself a basic understanding of macros/VBA. I've made a lot of progress on my project, but am stuck at the moment...Here's what's going on: I have a sheet titled "All Trades" that contains the raw data like the example below. I have two other sheets titled "As-Of...

Hey there ladies and gents, I would like to write a VBA code that would take the all the cells in a column, column B, and see if all of these different cells are anywhere as a string in column K. The only problem I continue to run into is the fact that there are more or some missing characters...

Hey there! So I'm relatively new to VBA and I was wondering if there was a way to write a code that would see two columns, each with a date and a time in their respective column (ex. -> 6/7/2013 5:50:00), and determine the amount of hours that had passed between the two dates/times. It would...

I have been previously helped by being directed to a site on excel emails, but i really dont have the program writting knowledge to convert what i see into what i want. Basically I have a table (made a simple version below) i have various orders but depending on teir status they may go on hold...

Here's what my workbook looks like. It's got 1 master sheet that has 200 rows of information. Each row is for one neighborhood. The following columns B-D list the city requirements, community requirements, home owner requirements, builder requirements, and county requirements for each of the 200...

How can I switch a cell of "first middle last" to "last, first" in excel? the cells are different some have middle names and some don't. what is the general code. such as switching from thomas allen smith adam wilson amanda r smith to smith, thomas wilson, adam smith, amanda...

Can anyone help me with code for the following application? I need the value of a cell (G2) to always equal the value of the cell in column C on the active row. For example: I have a spreadsheet for product information. Each product has 1 row of info and 6 columns. If I am on any given...

Hi All I have manage to "cobble" some script to import a numner of files into a single consolidate list. In Coulmn A of the file produced, it inserts the full path and filename. Is there a way of only inserting the filename? Code: Private Declare Function SetCurrentDirectoryA Lib _...

When i run the code - can i make the code show the result of the formula and not the formula in the cell? Suppose i have in cell A1 = now() or maybe = vlookup(B1,D1:F12,1) etc