excel & vba 2013

Hello all. I have a project Dashboard that needs to refresh the Daily Numbers in order of Order Volume. Then, after I supply the number, I want to application.worksheetfunction.match/index the client associated with that Nth Large number. Only match/index isn't working for me as there are...

Hi guys, I am facing difficulties in developing incremental functions for my excel vba. My current excel macro can't generate incremental number by +1. I will explain in more details in the following. Firstly, i have a macro file(file named: Still working on it.xlsm) there are one button inside...

Hi, im having trouble with my code, what im trying to achieve is to automatically select all fields change them to a sum and the format to currency GBP. the reason for this is i have 104 columns of data and the goal is to save time. here is what i have so far, i also need help stitching it...

Hello guys! I am a novice with excel and trying to learn VBA to assist in project that has landed in my lap. Here is what i have to do: I need to build an excel workbook that would allow us to assign incoming referrals to the correct region they belong to (assigned by state), while still...

Hello, I would like to know if there is a way to lock a cell based on the content of another cell on the same line ? (this action will occur multiple times in the sheet) So far I have this but it doesn't seem to work and looks quite heavy ... I would be very grateful if somebody could help me...

Hello, I have this macro to hide columns based on the value of a cell but I would like to know how I could tweek it to make it hide 2 columns at a time ? Thank you very much for your help ! Best regards, Hippolyte Private Sub Worksheet_Change(ByVal Target As Range) Dim rMin As Integer...

Hello Expert, is it possible to do? any formula? if column A value exactly match with the sheet name then Hlookup/Vlookup on that sheet for the value of Column B. There have about 100 more sheets in a workbook, which should search for sheet name. TIA,

Hi all, I have a macro that is trying to copy rows over from one workbook to another based on whether the values in column AR (column 44) are not equal to 0. However, I'm getting an "error 400" every time i try to run it, without direction to which line is causing the error. Does anyone have...

Hello. My apologies if this was previously discussed. My work just switched me to a new computer. I am now running Windows 7 from XP and I am now on Excel 2013 from 2007. I am trying to import a fixed with text file to excel. I clicked on Data>Get External Data>From Text and attempted to...

Hello, I am using excel 2013 on Windows 7 on a PC. I am trying to figure out how to delete an entire row if the value in the cell in Column B is a date. I have the code to delete the row if the cell in column B is blank, but I can't figure out how to do this for a date...

I have a code that creates a new sheet for each list of names in Sheet1. The problem I'm having is when the name has an apostrophe in it (such a O'Donnell), I'm getting a type mismatch error here: If Not Evaluate("ISREF('" & CStr(N.Text) & "'!A1)") Any suggestions for this VB newbie? Thanks...

HI everyone, My code is below. I want to have a button that will allow someone to add a record to access without having to open up the VBA editor to select the reference library. Private Sub CommandButton2_Click()MsgBox ("MAKE SURE THE ENTIRE INPUT TAB IS CORRECT") Application.ScreenUpdating...

I am trying to write a VBA code that autofilters , copy and pastes to a new sheet. The names of the sheet will be soft medium hard where those values are found in column B. The problem is the cell that labels it as soft medium or hard has a bunch of filler characters before the designation. For...

Hi I recorded the following macro: Sub Macro2() ' ' Macro2 Macro ' ' Selection.Copy Sheets("Data").Select ActiveSheet.Range("$A$1:$AJ$2958").AutoFilter Field:=19, Criteria1:= _ "114112" Sheets("Data Source").Select Range("C2").Select Application.CutCopyMode =...

Need to filter on each region (Column F) and copy the result to a new worksheet. would be helpful if this can be done through looping as the original data set contains more regions. Thanks for the help https://drive.google.com/file/d/0B02dDRY-jgk8Yks0bG5nbDlvME0/view thanks

I have a workbook that has 20 sheets. My goal is to save each sheet to it's own workbook, in the same folder as my original workbook. The code below is in my Personal.xlsb, and it creates a workbook just for my vb book (although I have the 20-sheet workbook open), and saves it in my xlStart...

Hi all, can you help me please to solve this problem? I have set of csv files in one file. To merge the content of this files and then split text to columns I use this script that I found in another thread (see below). It works great but.. I have new problem. I have this csv files In folders...

VB novice here. I am working on a code to pull one column of multiple sheets into a "summary" sheet. My workbook has sheets: summary, teacher, template, and 20-30 student sheets (varies). I need a code to copy each result (not blank cells) in column Q of each student sheet, and paste it under...

I have the following data and I would like to remove opposite values "rows". For example using the following data, rows 1 and 2 should be removed since they have the same description and exactly the same but opposite values. <tbody> Num Reference Description Amount 1 1 Test 50 2 2 Test...

Hi, I need help with this query-I want to split the data present in one of the column to multiple rows keeping all other info same.I am using excel 2013.Vlaues in column D will be multiple and separated by spaces.for eg- Input Columns value- A B C D...