repeat code

Selecting only few fields 3 ( Has subject ID, Stimulus defines and %Change) rows out of 1500 ..(.Problem is they appear in different cell location for every excel file) is from the Excel file, copy and save them in Master Excel file. In my head it works perfectly: 1) drag .dat file into Excel...

Hi all, I am extremely new to VBA so I apologize if this is a stupid question. However, I have created this code sub (format) Sheets("T_maintained").Select ActiveCell.Offset(0, 2).Activate Dim B As Long For B = 1 To 36 Fill Next B Sheets("Mastersheet").Select ActiveCell.Offset(1, 0).Activate...

Hello, I am new to vba coding so apologises if this is a very basic question! I am writing a macro that will generate a .zrxp file on which is written the following (from the Active Worksheet): Print #1 , "#REXCHANGE"; Range("A3").Value; "|*|RINVAL-777|*|" Print #1 ...

Hi, I am looking for a code that will help with what I want to achieve. I have a table where I have to split a column using text-to-columns. The number of columns created after will vary time to time. What I now want to do is copy the rows to a certain column and then for each of the columns...

Hey everyone, This is a basic math inventory and order tracker. Each week 1 inventory is to be imputed, I want the code to repeat as necessary until the next inventory column is empty Also to highlight Negative numbers in RED and Text in ORANGE. anywhere in the big selection within L2 to...