vba copy paste

Hey Team, I am looking for the quickest cleanest way to update a list of names in my excel document with VBA automatically when I open the workbook. For example I wrote a code that whenever I open my workbook it automatically opens the source workbook, copies the list of names from it and...

Hi there, I have many worksheets that are used to track suppliers and I want to collect all into a dataset for a pivot table to refresh and summarize quickly. Each supplier sheet is named by the supplier and I wanted to copy each column in the supplier sheet and loop through the dataset sheet...

Hi All I am new to VBA excel, currently I am doing a major project. For this project, every week I will receive new data updates from information company about the percentage of emails we have collected. My purpose is to create codes so that immediately after I receive the excel from the...

I am looking for some help to make the below code a bit more efficient/elegant. Any help much appreciated. (note this is a sample, I use the same code 5 or 6 times hence I'm looking to shorten!). If it helps I have the active sheet stored as sht from earlier in the code. LastRow, Next_Free_Row...

Hi Guys, I need a small help from you guys, I need to copy Paste Column A,B,C and D column into the end of the sheet with their headings. Can anyone help me out in that case? Thanks in Advance

Hi, I'm very new at VBA, and I want to learn how to import a specific block of data from a closed workbook to my active workbook (in which my macro will be placed) in the following manner: 1. Prompt the user to select the workbook 2. Prompt the user to select the sheet 3. Prompt the user to...

Hi, I am very new at VBA. However, I'm working on this tool, where I need to develop the following in sequence: 1. User has to browse for a particular workbook 2. User then selects the sheet required for copying 3. User then selects a rage of columns required to be copied 4. This tool copies...

Hello, I am new to VBA. Right now I am really struggling to do this. I need to create a macro that reads the value of a column, (column F), and depending on the value of the cells in the column, it will insert rows below. If the value in column K is greater than one, it will insert n-1 rows...

Hi, I have a code written in Excel VBA, and I a trying to Copy-paste slides from one PowerPoint file to another Power-Point file. But my code is doing regular Copy-Paste and as a result I am loosing some of the graphics. But when I am doing manually Copy-Paste (Paste as- Keep Source...