copy & insert

Hi Guys, I have an open binary excel file (named "Masterfile"). I badly need the codes where the macro will browse from certain Source Folder and import multiple files onto the binary file. There are 3 files inside the Source folder namely: 1.) Survey.xlsx 2.) Checklist.xlsx 3.) CB.csv . I need...

Hi All! I've been going through tutorials for the past two days to start my journey in VBA, and need some help for an immediate problem. I currently receive a report from an ACCESS database that I don't have access to, and need to get the data filled correctly so that I can then start using...

Hello, im trying to figure out how to make this work. I got a table with informaton. with a checkbox on the side of the table. simply explained: When the checkbox on the row is true, copy table row "b3:p3" to a new table. but i want it to be activated by a commandbutton, so i can choose 5...

Hi guys, I have a question, and would like to hear your thoughts :) So in sheet 1, I have the following: <tbody> Company Data1 Data2 Priority company1 information information 1 company2 information Information 3 company3 Information Information 2 company4 Information Information 1...

Hi all. thanks you in advance for your help. I am new at VBA and have been trying to compare 2 lists and add or delete records as needed. Both the lists are in tables of which I also need formulas added. Hopefully the detail below makes it easier to understand. Column B on this sheet is the list...

I would appreciate your valuable help. I have a sheet that contains a 3 columns every column contains a value A1:TOKEN, B1:CHIP & C1:DATE, the token value can be repetead any times but i need that if this ocurrs copy the same DATE of the first TOKEN that aparece. For example: <tbody> TOKEN...

Having a bit of trouble wrapping my head around how this would even work. Here is the data I will need to manipulate: <tbody> A B C 1 ALASKA FLY FISHING 2 2 JONS LOG CABINS 3 3 LUKAS LODGE 5 4 SCOTTS SALVAGE YARD 4 </tbody> I am looking to have the value of B:B determine how...

Hi All, I am looking for a vba which will do the following: Daily I get a list with data. The numbers of rows differs daily. From 10.000 rows to 18.000 rows. I am looking for the following: · VBA to check the dates in column AO and date in columns AP. If date in column AO > AP, select...

Hi All, I am trying to copy and paste value from one cell to another. The value will be pasted after a phrase and in between quotation marks. For example: Before copy & paste A1: 4567892300 C1: phone number = "" active etc. After copy & paste A1: 4567892300 C1: phone number =...

Hi, I am new to this website and have looked around but can not find exactly the code i am looking for. Basically, I am trying to search Column A for various words (hopefully they can be pulled from a existing table in excel) and copy and paste them in Column D of the same sheet. The looping...

I have a series of large (1000+ rows) sheets in a workbook. I need a macro that will: (1) - Copy each row and insert it twice immediately below (2) - Repeat until the last row of the sheet is reached For example, Row 1 will be copied and inserted as Rows 2 and 3. What was Row 2 is now Row 4...

So I have scoured the internet to put together this small macro, but I haven't had any luck figuring out what I'm doing wrong. I know the answer is going to be simple, but it certainly beyond me. The goal is to have a checkbox insert several rows from a separate sheet, then delete those same...