copy & paste vba code

Hi all! How do I copy-paste range A1:L16, every time, until row 500? Can you help me build a simple VBA/Macro? Thanks.

Hello, I know there are other threads on this subject, but because of my poor knowledge in vba I couldn't adapt the answers to my problem. What I need: WhenI give two clicks in a cell (c3:d10, worksheet"PM") , copy the cell's value and paste on D1, worksheet"PLANEJAMENTO". Thank you.

hi, while I`m running below code I`m getting error like: run-time error 1004 select method of Range class failed Application.ScreenUpdating = False Application.DisplayAlerts = False Dim wsC As Worksheet Dim wbC As Workbook Set wbC = ActiveWorkbook Set wsC = wbC.Worksheets("ABC")...

I have a table like this: <tbody> 1/2/14 2345 1/6/14 34665 1/7/14 5473457 </tbody> For Column A-I would like to create a macro that will copy the info from cell A1 and paste in in A2. This will continue all the way to the last row containing info which will...

I need to pull the date from one workbook called “log” (the date is in column B) and display it in another workbook (one of which is) called “MrepoA” . I will have approx 8 workbooks in a folder called: MrepoA, MrepoB, MrepoC , etc. that need to receive date information from the “log”...

Hello, I am trying to build a code that copy cells from non-contiguous ranges and paste the data on another sheet where the cells are contiguous. The ranges have more than one column but I just want to copy the data from one column (for example the first column). This is the code I have for now...

Just thought I'd share this nugget of information. VBA based cut/paste of a range containing a form button has slightly different behaviour in Excel 2010 vs Excel 2007. If the source range is hidden the button will NOT be copied when using 2010 but will be copied when using 2007.

Hi, I'm pretty new in the VBA World and was hoping somebody could help me with this problem. I have two worksheets: "worksheet1" containing the current data (e.g. today's progress) I want to copy and "worksheet2" containing historical data (e.g. historical progress) in which I would like to...

Can someone please help me? In the last part of the code I want to copy a selection from 1 worksheets to all other worksheets except two. But the macro stops at the selection and doesn't copy at all. I get no error message. Can someone please tell me what the correct code should be? Thx...

Hi all. I Have a weekly timesheet that I have automated using vba. What happens is that from a master timesheet I copy the current worksheet into a new workbook for emailing. When I have the new sheet in the new workbook I want to copy & paste values that in the master timesheet rely on a...

Hi: I need help with writing a new macro and integrating it into some existing code. My existing code works well for creating an auto hyperlink, from one sheet to another, triggerered by a dropdown value in Sh1 column K. I'm trying to add vba code to have the same trigger do a copy of cells...

I’m looking vba code in order to segregate the data as per below requirement. I have sheet1 which contains the data and required to copy this data till 90 line items including empty rows and needs to paste special in new sheet. This new sheet name should be changed to Setitem1 and it should...

Hi all, I don't have much knowledge of VBA but am using research and help I can get from the web to create a tool. I am stuck at a stage and was wondering if anyone could help me. I have the following in sheet 1: <tbody> SKU NUMBER Supplier ISSUE RECEIPT DATE QUANTITY PURGE...

I have background sheets that make calculations based on input data that is found on each row of the main sheet. I created a ginormous macro that basically repeats the same command for a series of 30+ 'If/ If Else statements' where it finds the right background sheet for the row and then...

Hi Folks I'm trying to delve deeper into VBA and am trying to run the following macro without resorting to 'Select' or 'Activate'. What I am trying is to get the macro to loop thru two different worksheets, enter a formula, then copy & paste it down to the length of the range. What happens is...

Hi, I have this code that will copy/paste multiple columns between two spreadsheets, basically an "import". The issue is that the "Import" sheet will always be changing with more or less columns than the "Main" worksheet (which is the template). The code below just copy/pastes all columns. I...

Hello - I am looking for any assistance someone can provide to help me optimize this slow VBA code. Processing 20,000 rows of data takes about 7 minutes. Basically I have four columns of data generated from formulas - 1 sumifs, 1 countifs, and 2 vlookup. I calc the first row and then want to...

Hi, I use an excel workbook that contains around 20-30 output tables/ranges and i would to have a macro which will enable me to open a specific word document and paste these tables/ranges from excel into the word document. I am unsure as to how to get excel and word to "talk to eachother"...

I am new to Excel VBA (using Excel 2007) and have been asked to create a macro to re-order a spreadsheet so that it will load into a new software package. The workbook is a download from our website cart which shows a list of all our orders. Here is a snapshot of the workbook (the workbook is...

I'm making a program for a Photography company to help them keep track of theres invoices. On the Invoice sheet, after an invoice is completed, I want to select certain cells and have them posted in the Records sheet. I tried recording a basic macro but every time I run it, it replaces the...