copy-paste

Hi, Can someone help we with a code for below scenario. I have data in A column and need to split it to B, C, D Columns. below is possible formats of data. 1. If it contains data with "AB" then it has to pull the 8 digit alpha numeric (8 numbers + 5 alphabets) ID and paste it in B column cell...

The below code was created with intention to autofilter column K with criteria, copy data and paste it at the bottom of the sheet on the same page, just below the last row. I am not getting any error, but code is not working as intended. It works up to autofilter and copy, but it won't paste...

This below is the Sheet1 <tbody> Model Brand Status Quantity Minimal Quantity a1 Asus In stock 2 1 a2 Sony In stock 1 1 a3 Toshiba Test 3 1 a4 Fujitsu Test 1 1 </tbody> I want to separate in different Sheet according to status.If status=In stock then copy the row and paste it to...

How can I move further in writing this code so that it skips if a blank row is found and then increment the cell in Sheet2 from G53 to G54 and then paste it in column A after the blank row is found and so on for G53:G60. I could do it manually too but I am just trying to give this a shot...

Dear all, I have a working VBA script, but it's missing some (for me important) steps. I would like to paste the data in values - without formatting - and I would like to have a reference sheet instead of "ActiveSheet". The reference sheet would be "DATABASE AB" in the masterfile "VIVA PPT...

<tbody> I am a martial arts instructor and I keep my attendance records in an Excel workbook. There is one worksheet for each of four schools, a Master and a Consolidated (as the students are allowed to train at more than one venue, so I need to have a record of their attendance at their...

Good morning/afternoon/evening MrExcel peeps, I'm in need of manually copy-pasting a bunch of tables from Word into Excel and haven't gotten very far before encountering a strange error in translation. At least, what it does is a surprise to me and would result in a lot of time added to my task...

Hello, So basically I have the following code: Sub FindStr() Dim stFd As String Dim stDg As String Dim sh As Worksheet Dim ws As Worksheet Set ws = Sheets("Input View") Set sh = Sheets("Financial_View_1") stFd = "Lubricant A" With sh...

Hello all, Excel novice user here and complete VBA n00b so please bear with me. Basically I have a spreadsheet with 4 sheets here: The first sheet has a table that is meant for a certain user to input values into...once they have inputted all their values (some of which are calculated within...