excel &

For Excel VBA, I am trying to make a code which looks at the value in the column "case type" and let it paste a formula or clear a cell, based on said value in the cell of the column "case type". For Case type 1, Column 1 should contain be cleared of any values and Column 2 should contain...

Hi I am making an excel with some ranges in it. Bottom left, left, middle, richt, top right. And I want to show the full range with an & function. As shown below. Bottom Left Left Middle Right Top Right Range 2 4 6 8 10 2-10 In the "Range" column I am using an =A2&""&E2 function. This...

Hi all, I currently have a very messy sheet that looks like this: Essentially, row 1 is the heading, row 2-3 is the results that I want to produce through a text to columns, and rows 24-45 are the data that I currently have. The issue is that my cells have become messed up, so for every...

Public Sub Move_Files_To_Matching_Folder() Dim sourceFolder As String, destMainFolder As String, destSubfolder As String Dim FSO As Object Dim FSfile As Object Dim FSsourceFolder As Object sourceFolder = Environ$("USERPROFILE") & "\Downloads\" destMainFolder =...

Hello, I am trying to find a way to use VBA to clear all cells below row 1 on an excel worksheet. Row A has headers I want to keep but would like vba code that I can put into a button to clear all cells under row 1, so clear rows 2,3,4, etc.. Also the sheet is called "User Info". So would like...

Hello All, I'm currently using Office 16 on Windows platform, and am looking to export data from an Excel sheet in one of my workbooks to MS Access. I've got the basic outline down, and am able to send data from Excel to Access, however, I am looking to only send rows based on a cell value...

Hello, I am trying to make a sales bundle to offer to customers. I have it all done but the issue I am running into is with the unit amounts. I would like the add a section for "Units requested" and have that cell multiply with the "Cost" cell. Then have those cells trickle down to GP and GPP%...

Hi There, This forum has been helpful to me from time to time ..!! Its helping me in learning as well as writing small automation. However, I am struck at this point in the automation I am working upon. It would be kind of anyone who could help me with this. Thanks a ton in advance...

Hello, i would like to make a data input from two workbooks that is in the same path. The data input should be in the master workbook from those two files. The first sheet in the master workbook should just be empty as im going to make macro run buttons for later purpose. The data from the first...

I'm using the following formula but I want to exclude blank cells from the countif criteria... "*"&'Sheet10'!$B$5:$B$9&"*" =IF(OR(INDEX(COUNTIF(F2, "*"&'Sheet10'!$B$5:$B$9&"*"),)), "YES", "NO") Anyone know how?

Hi All , I'm trying to automate my trading on betfair horseracing using Excel , So the set up is I have a countdown clock in seconds to the start of event , in the next column I have the horses price updating in sync with each new price/ second being in a new row .I would like to monitor the...