specific columns

Hi All, So to give some background, i have a large data set (60k plus rows and 90 plus columns) that i need to filter and create a new workbook using specific columns. The size of the file changes daily, and columns are taken out and added. So i had to keep updating the previous macro i had...

Hello, I am having difficulty with assigning a specific sequence of numbers (seat numbers listed below) to specific records whilst keeping the order. For context, I have a running order of graduands and those known to be attending are marked as attending in column C as well as the row being...

Hi all, my currently code imports 1 csv data into sheet 1 and then I have to manually click the button and select the next csv file and import to sheet 2. Im thinking if it is possible to select all 3 csv data and import them to sheet 1, sheet 2 and sheet 3 all at once? any help is greatly...

Hi guys, I having trouble importing only the column a and b. I am importing excel file data (500 of them) into a single sheet and would only like to extract values from 2 columns. I am new to vba and got dumped by this job because our IT guy is in the hospital. My job is on the line :( need...

Hi all, Ive came up with the VBA to import multiple excel data (.xls) into a single worksheet. However, the format is still not what I want. Could someone please help? I am still working on my VBA skills. 1. Currently, the VBA imports all the columns. I would only need column A and B. The data...

Hi all, I have searched the web for hours but was not able to find a solution. Kindly help. I need excel to transfer all excel results into a single worksheet. 1. Click of button, file directory will open and select the folder where all the excel results are located. 2. Below is how the data...