code automation

Hello House,I need your help for the BVA code for the paye for the form.I am still learning BVA Excel Code.Thanks ABCDEFGHIJKLMNOPQR2BasicHousingTransportLUNCHTotal IncomePensionNHFGross IncomeCRAChargeable Income1ST2ND3RD4TH5TH6THTax PayableMonthly...

I have a data base that I need to be able to automatically archive and remove lines when there are a certain amount of out of date dates. My thought process is to run a check that will detect the out of date dates, select the entire line and remove the data to a holding page until the details...

Hi Everyone, I have a code to upload an object into excel. However below code i am able to upload only one document by clicking on button. Please help me in amend the code by which i can upload multiple file. note - other file path would remain same. However name could be sample2.pdf or...

Good Day, I've had luck in the past so I'll try again and a big thanks to everyone who's helped me before. So, I have worksheet 1 that has data in columns A through M and worksheet 2 with data in columns A through F. I need to be able to match the data by number in worksheet 1 & 2 on column...

<tbody> EMP ID EMP Name Date Job JOB # 1 John 1/1/17 Manager 1 1 John 1/2/17 Manager 1 1 John 1/3/17 Employee 2 2 Mary 1/1/17 Employee 2 2 Mary 1/2/17 Employee 2 3 Peter 1/3/17 Manager 1 4 Paul 1/4/17 Employee 2 </tbody> Hello all- I am creating a converter for payroll files...

Hello everyone, I have been trying to write some VBA code to check if a cell contains a positive, or negative percentage. Based on whether it is positive, or negative I would then like to copy and paste the value into a new table on a separate sheet which has two tables. One containing all the...

Hi Guys, First time poster here. I have an excel workbook that i am using as a form and have VBA to transfer data from that form to to a database workbook. See code below Public Sub copy_wb() Dim copy_from As Range Dim copy_to As Range Set copy_from = Workbooks("Ideas...

Hello folks, I am currently struggling to set up a macro to transpose arrays of records based on conditions. I am quite new to VBA, so any tips and advice on how best to achieve this will be very much appreciated. Below is the format of my 'raw' data in Excel (Version 16.0.6741.2056) Column...

Hello. I found this code online ,which pulls data from a csv file. Im trying to make this section of the code put data into a main worksheet with existing data without deleting said existing data. How can I do this please? Sub RefreshData() Dim sPath As String sPath = ThisWorkbook.Path &...

Here is the scenario. I have an excel workbook. One of the sheets is named "Part Tree" which contains a list of parts all over meaning they go from left to right and go all the way to row 533. I have another sheet called "Sheet1" that has just a list of parts in column "A" from row 1 to 153. I...

Hello everyone! First time poster here, so feel free to give me hell if I'm doing something wrong. Anywho, the question! I'm looking for a Macro that will: A - Grant selection of multiple files (Done) B - Automatically open and close selected files(Done) C - Copy the first sheet (Kinda done?)...

Hi All, write down macro or combination of formulas to find out the following- I need to find the difference between certain column in 2 rows based on other columns. For example- Find 'A10' minus 'A16' based on certain values in B column. 'B1' or 'B2' or 'B10' or 'B?' ('B' can be anything)...

I am storing various type of codes in memory variables and would like to execute them as a command line. I have tried to create on the fly procedures, which works, but it requires my project to not be protected. Is there a way to execute a variable as a command as follows...