excal vba

Hi All, I'm very new in writing VBA. Please help me in activating already open workbook. Following is the code i'm using but don't know how to complete it. Please help. Sub AssessmentDataPaste() Dim MyPath As String MyPath = Sheets("Main").Range("C7").Value ' Pop-up a...

Hi All, I need a help where I have the numbers in column B but they are not in the number format. So I want the moment my macro paste the data in column B, it should convert that column in number format. I have tried multiple time but it only paste the data in as usual format. Kindly advise...

Here my code: Private Sub CopyRanges() Sheets("Test2").Activate Application.ScreenUpdating = False Application.DisplayAlerts = False Range(ActiveSheet.Columns("A"), ActiveSheet.Columns("A").End(xlDown)).Value = Range(Sheets("Test1").Columns(2)...

Hi there, I would like to know if there is a way to combine two strings together into one cell. I am talking about putting numbers together, there is a set of Account#which are on different lines and they are displayed like |Account#:12542-|5651256|" The pipe (|) is there to show the column...

Hey Bros, I am facing an error with this simple code. It can't write the formula in the cells. Can you please help. Thanks Sub update_formula() Dim c As Range With Materials For Each c In .Range("tbl[Shortage]") ' Debug.Print c.Address ' Debug.Print...

The code below copies data (Associate Entry named range) and pastes it into the particular row number (1RecRow) in a different sheet (AssociateData). I would like the row to be pasted to all the rows ONLY BELOW the numbered row. There are a couple of things to bear in mind: A. The data is...

I have an excel sheet that has page numbers, Categories, and item numbers. I want to make almost an index of the Category then unique page numbers this is the code I am using now I need to find out were to add to remove the Dups. Function ConcatenateIf(CriteriaRange As Range, Condition As...

I hope someone can help. I have an excel sheet with over 65,000 rows. I have attached a picture of what I am trying to achieve The problem I am facing is that i have a worksheet with 65,000 rows, and I have payments and reimbursements withing these rows. In the below screen shot you can see...

I am currently writing a piece of code, that finds the first date of something for two categories, in the cells. If one of the cells has a date filled in, it ignores it but if the other cell is blank it runs the evaluate formula. The problem I am having is the code formula works on the sheet...

Hi Gurus, I want to find the cells with dates using vba macro. I'm hoping to find dates under column Q which contains dates formatted as "m/d/yyyy hh:mm" and a text "---". After that, the return value is in column B which I plan to use offset function. I just also want to add that I'm a...

I having a problem With my macro. It has so many steps that causes my excel to not respond. It there a way to shorten the process. I need a Macro that Removes all punctuation by that i mean ,./':;"()| in column J starting in row 2. DO the same in column K row 2 but also remove - with a space...

Hi All, I am trying to create a DOCU Tracker , in my tracker there are 3 sheets , sheet 2 is a registration sheet , once it was filled by the user the form in the sheet 3 should be generated as new excel file or new sheet in the same excel file. I am using the below script it helps me to...

Hi All, I'm having some real trouble getting the error handling to work properly on some code i'm using. Private Sub CommandButton7_Click()Dim i, lastG As Long Dim j As Integer With Application .ScreenUpdating = False .EnableEvents = False .CutCopyMode = False End With ' find...

Hi can i paste cell selection multiply times each after 13 rows, the number of how many times to be pasted to be from a cell eg. F1(12), also some formula in that are in the selection range to be updated automatically with the row number til to the number in cell F1 eg. =A1+B1 to...

I'm new to VBA. I'm trying to do the following but the code isn't quite working as expected - Export/Copy particular sheets in the workbook (any sheet name that contains "Upload") to a particular file directory. I don't want these worksheet names to change nor the workbook name to change. The...

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

Hi , I am having work book with different work sheets. I am having macros for different worksheets. i AM HAVING SHEETS (UsageTracking, DeveloperUsage,DMNE-0418, SAS-0418,SOD-0418, DMNE-0411,SAS-0411,SOD-0411...so on) I am having a macro for all work sheets starting with SOD, another macro for...

Our company recently moved most of our files onto SharePoint in an effort to backup our files. A byproduct of this is some of the macros in place no longer work. In particular, I have one that copies and pastes a row of information (from lets call it the CM form) onto the next available row...

Hi everyone, I have a question but I don't know if it is possible. If I have an AutoCAD drawing with its dimensions can I write a code in excel to copy the dimensions from AutoCAD into excel? If it is possible can you please give an idea or some resources where I can search

I am in need of a way to consolidate data from multiple files into one file. I am using the code below to perform this task. There are 2 errors and I am at a loss for how to correct them. Any help would be greatly appreciated. Sub GetData()Dim strWhereToCopy As String, strStartCellColName As...