loop a copy

Hello everyone, I am new to VBA for excel and I would like your help for a problem. I have two excels, A and B to be created in runtime. I need to copy only the values of all the worksheets from A (except one), to B, without specific filters or range. The following code copies all the sheets...

Hi friends, I am stuck in a VBA problem. actually, the code is printing the value twice in subsequent rows its working fine on my previous excel version 2007 but now I shifted to office 365 and its printing the values twice whenever the cell changes. Attached photo for clarification see timing...

Hello everyone! I am new in VBA and I have problems with importing text and copying it in current worksheet. I created a code that imports text file to last worksheet in current workbook, but an error "Type mismatch" appears when I try to copy it in worksheet 1. Actually, I need to copy every...

hi i want a code which check second colulm and if to right charcter was 01 then copy entire row to another sheet for example if b2=9164801 then copy row 2 in sheet2 and do it again until the last row can anybody help me on it i would appreciate you

can anybody explain how to copy from a range of cells in a column and paste into a data driver cell. the thought is building the copy paste out so it takes the first number (sheet a cell b1) copies it. pastes it into a different page in lets say sheet b c4 goes back to the other page copies the...

I wish to do a simple (I think!) Do-loop for the following: My simple program works as I want it to, but I think there is an easier way as I wish to repeat it 1000 times. Perhaps using some kind of loop? Do-Loop or otherwise. In short I want to: copy the contents from A1 Paste them into B1...

Hi all, I just made a code to collect data from all excel sheets in one folder into one master file. I need a code to reflect any update in the master file to all files in the folder. So the code should check the column G starting from G7 and if data in G matches any file name in the...

Hello, I need help with some VBA coding, my requirement is: I need to copy and paste ranges from 21 excel docs in a folder to a Master workbook within relevant named sheets. I have some code, but want to loop it so it runs through each of the docs and copys+pastes the relevant parts into the...

Hello Everyone , I have this code Worksheets("Graph5").Range("G1").FormulaR1C1 = "0.01" Worksheets("Graph5").Range("I1:J1").Select Selection.Copy Worksheets("Graph5").Range("L1:M1").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _...

Hi, I have a huge text file which consists 22 Lacs rows of data:eeek::eeek:. Need to copy the data to excel. while copying Once the excel copied data till 65000 row it should start to save in new worksheet till EOF. Have tried available sources in forum and google but nothing works as...

Hi Friend, I am trying to gather particular details from a bunch of workbooks located in a folder. Suppose I have a folder "PI 17 - 18" on my desktop which contains around 370 Performa Invoices. Now I want to collect only few details from each perfoma Invoice in below Format, <tbody> Agency...

Hi all, I have searched and found pieces of parts but I really need your help. Here is my task. 1. I have (x) number of rows with various text in a single column 1.5 I would like to copy the text in each row. 2. I would like to take each row, insert x number of rows beneath...