copy & past

Hi there to evereybody! Im Juan and i'm writing from argentina. I have a TXT file with millons o lines (literally) like this: 22082019;01092019;30092019;20000163989;D;S;N;0,00;0,00;00;00;ETCHEVERRIGARAY JUAN CARLOS I would like to use a command button to search for the number i've marked...

Hi, I need to copy the conditionally formatted cells and paste format to a new range. Currently I do: Workbooks(EnvelopeFile).Worksheets("System Envelopes").Cells.Copy Sheets(xlSheet.name).Cells.PasteSpecial Paste:=xlPasteValues Sheets(xlSheet.name).Cells.PasteSpecial...

Hello, I am trying to create a macro that does the following: Loop down sheet and copy the Description (Column E) Ex: Copy "Cash in Bank" [Note: the empty cells at the category description level (Beg and End)] Paste the description in (Column L) next to each transaction Ex: Paste "Cash in...

Thanks in advance for the help. The calculation sheet has several API keys that determine distances between multiple start points compared to one end point. The data dump sheet list all my end points that I want to know the optimum distance. Instead of manually going line by line, I would like...

I have column A with 22 rows in sheet 1 but there are spaces between these accounts and 27 rows in column c in sheet 2 als with spaces between them. I need to copy and paste the range in column A to sheet 3 and when the copy paste ends it skips a cells and then pasted the data in column C under...

Hi, I’m having trouble to figure out how to write that code. Let say that I have ten values on column “A” and each cell in column A have different values between column B to F of each row, and I want to copy each value between B to F to the DIFFERENTS CELL VALUE of any columns. Currently, the...

Hi, Everyone! I'm simply tring to get a cell content from an unsaved workbook (Book1) through GetObject function, plus Copy and Paste. But as the content of the cell is a very long string, I only get a piece of it (until characters 255). The code I'm using is: Dim oApp As Application Dim oWb...

Hi All, I'm trying to manipulate the following script. When I paste new data over a range on sheet 1 I would like the old data range copied and pasted into sheet 2.. id like this as a cycle.. every time I paste new data over the data in sheet 1 the old data overwrites the older data in sheet2...

Hi Team, So I usually work on a particular task where i need to collate specific data. I need to produce a sheet where it has 5 columns in it namely ID, Name, Note, Source and KEY columns. I was thinking of using Getopen file were it will openthe source sheet which is normally in xls or xlsb...

Hi Team, I know this is something can get it online but I could not get it and leads to lots of confusion. I need help in copying visible cells. For Example I have columns from A to AE and want to filter something on column AE and code should select only visible cells post filtered and copy...

I have a workbook with sheet 1 the data for clients. I need to lookup the client name and pull through specific data from sheet 1, their website address located in column D and copy that website address to sheet 2 column B. Their website address is a hyperlink and if I use the normal vlookup it...

Hello So i have have this code that i need to mutilply by 500 and change the "tab=number" in each line to next higher number for example : this counts as one line >>> 500 of thoese <colgroup><col width="64" style="width:48pt"> </colgroup><tbody> { "Command": "click"...

hi, I am new to VBA and tryin to reduce some workload to make a small VBA program to copy range randomly with mouse and paste it to destination file. source file is "Mytest.xlsm" and destination file is "BatchEntry.xlsx" I can easily copy range by below code and successfully paste It to other...

Hi Team, Could you please help me with code for exact requirement ..I have data from column B to P and need to filter on column P say "One" and need to copy only data from column B to Column D -top 10 visible cells (excluding header which is there at row 5) and need to paste it in different...

Is there is any possibility to paste data from one sheet to another sheet(That is hidden) I have a vba code to copy data from one workbook on particular path and i have to paste that data into another workbooks sheet 6 but the sheet 6 is hided Thanks in advance Azhar

Hi All, I have 18 different workbooks saved in 1 folder (Workbook 1, Workbook 2, Workbook 3 etc) with the same worksheet names (Sheet 1, Sheet 2, Sheet 3 and Sheet 4), in all the 18 workbooks. I need to collate the data in Sheet 2 of all the 18 workbooks Sheet 2 of all the 18 workbooks has...

I want to use the code shown below to gain a better understanding of how copy and paste work in VBA. When I run the code it gives me: Run-time error '1004' Application-defined or object-defined error when it tries to execute Cells(NextRow, 1).Select At that point NextRow value is 6...

Hello. In Sheet1,2,3,4 and Sheet5 of my Workbook I have a data stored in column C (on all sheets). I need to copy only non empty cells from all sheet's (column C) into column D of my master sheet (Sheet6) in the next empty row eg. without empty cells. All those five sheets (as well as master...

Hi, I have a section of code that grabs a block of data and copies itself below 2x times. The data should overwrite the blanks at the end of the grabbed section each time. What happens now is it goes to the end including the blanks that were just selected. I want to drop the data right below...

Currently this macro only paste the second table into the sheet, so it basically overwrites the first table and paste the second table. I need it to paste ALL tables as you see in code, how do i fix this? Sub ExportToWord()<code style="margin: 0px; padding: 0px; border: 0px; font-family...