recording

I wrote this program to take some data that was being transferred to my tablet through a keyboard wedge software and put it into our inspection sheet. It takes data from a few different types of inspection eq and the data string was different for each so I had to pull the number from different...

Hi all I have a file with 22.000 lines. They contain our stock codes plus their suppliers (plus some more information but not relevant for this thread). I want to create a separate excel file (or CSV, whatever I can get) for each supplier as there are over 300 suppliers. I suppose someone...

Hi, I have a spreadsheet containing 12 ActiveX drop-down lists and 3 check-boxes. I want to create a macro that selects a certain combination of rows and checks/unchecks. I've tried recording a macro, but it won't register any of my selections in the ActiveX controls. Do you have any suggestions?

Hi Sir, I am beginner in excel macro. I am able to use the macro recording. In recording we will get the formulas as is So, instead of that I want define VBA codes. So, Please help me defining the below formulas, =CONCATENATE(C2,"-",D2) = VLOOKUP (G2,'MASTER TEMP TL'!E:E,1,0) =...

Respected Seniors, When I am recording a macro in Excel VBA it showing like below given formula ActiveCell.FormulaR1C1 = "=TRIM(R[-9]C[-2])" I want to change it like :- ActiveCell.range("A1").value style without R [-9] C[-2] is it possible Regards Narendra www.Excelnsg.com

I'm trying to record a macro for rolling forward our financial statements. In doing so, I have to copy column D then insert copied cells. I then hide column P and in column FY it has a calculation for column D and column O. when recording the macro I highlighted all the cells and did a...

Good morning / afternoon everyone. I have a macro that is not completing the pivots which were recorded. This happens with not only deleting the pivot information but also creating a new table.:confused: I'm not sure if anyone know a good solution for this as I have tried several times to...

Hello, I would like to enable the recording function while I am editing a macro. Sometimes I have no idea what, or cannot remember, particular programming language such as Paste Special stuff. Is there a way to record an action while you are in the process of editing a macro to add in extra...

I have a lot of data which shows what dates staff have been sick.. a bit like what is below: I want to be able to get Excel to recognise where a sickness for an employee is greater than 14 days on the data below. I was thinking IF(AND(something something something),"LTS","STS)... but I can't...

I have 2 problems that I can not solve. I don't know if a solution to either of them is possible in excel. 1. From a large spreadsheet/database with time and price information I need to extract the data from every 15th row and insert it into a new spreadsheet in chronological order. 2. Is...