excal vba

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

Please Help, I need help inserting Text that would say "Total" under each product group and Auto Sum for each group of data in the next column Thanks <COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><TBODY> Apple 3 Apple Apple 4 Apple Apple Total 7 Orange...