copy & past

i have problem that i think it is not easy to solve(maybe not,but i think it is so hard :wink: ) ,i have a 2sheet(shhet9 and sheet10) and a user form,i put command button on userform for printing the special area of sheet10,data should copy from sheet 9 to sheet 10 by step 1row by 1row then...

Hi, i am trying to create a macro that will move data entered on three separate sheets to one master sheet either as the new line is entered or upon saving the document. The file has 3 different agents adding data to a shared document for internal audits, then a master audit sheet where the data...

Hello Since I don't use much Excel Macro I will need help with a VBA Macro for Excel. What I need is to copy a specific value from the 5th row (the Main Value) depending which month it is (cell K1). As an example: if the month is equal to number 9 then it will copy the value from the cell for...

hello below i have given my code the problem is when i enter the value for few times in the userform and its working fine and when i delete the values and enter the value from first it copies the data for the times i entered previously. FOR EXAMPLE IF I ENTER VALUE FOR 5 TIMES (THE FIELD ARE...

Hey guys. I've done some snooping around to find the solution to my particular problem, but don't know enough about using VBA outside of Excel to figure it out with what I've found. Here's what I want to happen: I want all files with the extension .pdf, .doc, .zip, and .7z to be copied from a...

Hi - I am trying to write a code that searches for any value in a cell in column B. If it has a value to copy it to the cell next to it in column C. If it is blank I want it to leave it alone. Then move on to the next cell down in B and repeat..all the way down to my last cell in B. Here is...

I am trying to compute a score of players based on a macro with a series of checkboxes. The output values of the check boxes are pasted on the "Calculations" worksheet where the score is then computed in cell F18. I would like to copy cell F18 and paste it in the next empty cell of column D on...

Hello all! I am attempting to copy selected information into the corresponding columns. Below is an example of the spreadsheet I am working on. <tbody> Sponsor 1 Sponsor 2 Sponsor 3 Sponsor 4 Sponsor 5 Investor Thanks Sponsor Investor Thanks Example A Example A Example A...

Please help. I know this should be easy but having trouble getting this line to work; P1 = Worksheets("Past-here").Range("B" & i).Left(cell("B" & i), 2) I get a "type mismatch" error. I need to check the data in a worksheet for several types of data, such as 100, 109, 400, 300...

Hello, I was wondering how I could copy a filtered selection of a pivot table into a new document WITHOUT having the possibility to reset the filter in the new document. Example: Into the pivot table I select one customer "X" with the sales evolution per month. I Copy that selection into a new...

Excel Gurus, I want to copy values from A1 A2 A3 .... to B1 B3 B5 .... Is there an easy way that I can Ctrl+C A1 and then select the cells B3, B5 etc and paste to get the value of adjacent values of A1, A2, A3 ... Thanks MMM

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 Folks I have been pulling my hair out with this, i have found pieces of code around the place but this is just not working for me. to give you an idea, the code selects all of the data in x cells, copies the data, opens a workbook (master data sheet), finds the first blank cell in column A...

I am creating a customer database in excell that identifies customers on a plan via a reference number. A plan has a reference number and on the spreadsheet and all customers on a plan are input next to each other on a spreadsheet at the same time. E.g <tbody> Plan number customer number 4...

Dear All, I use the below code to copy the data from .csv file to .xls file, but the format of the dates copied in .xls was in text format which gives me Type Mismatch error while subtracting two dates. Suggest what has to be done. Set t201 = xlws2.Range("A1:AZ" & sins1) Set t202 =...

Hi! Working on a code to convert a part of a sheet into a CSV file: Problem is that I get "Run-time error '1004': Application-defined or object-defined error" when running it, stopping at "ActiveSheet.PasteSpecial Paste:=xlPasteValues". Any help? :) Sub ProdCSV()...

Hello there, Not sure if this is possible or not. I'm looking to be able to copy and paste a series of cells based on an input code a dynamic distance away from the formula cell. In the image, there is an input value. This defines where along the scale the string is placed. There is a...

First time posting I apologize in advance if question is not formatted clearly or if this post is unorthodox in any way. This is my first time using VBA so I am not familiar with the language. I have a work assignment for which I need to copy and paste the data from several excel files (All...

Hi everyone, I am trying to copy / paste a sheet with a pivot table and 2 slicers. When I copy / paste my sheet, I have my pivot table but the slicer are not pasted. Do you know to solve this problem. I looked for VBA code to bypass this problem but I did not find anything. Thanks in advance...

Can anyone help me create a <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> code for my business? I have a...