macro - copy/paste

hi all, I hope you're all well : I'm trying my luck with writing a Macro today for the first time and would be super grateful for a little help. I'm trying to copy three cells from one row over into another sheet, across three columns. Then I'd like to move on to the next row and copy over...

Hello Guys, I have seen similar threads on the forum but none has gotten a final solution. I would really appreciate your help, My requirement is pretty simple. so this code, Range("C" & Rows.Count).End(xlUp).Offset(1).Row -> Is supposed to give me the last available row in column C which it...

Hi there, I'm having trouble figuring this one out, I'd like to include this code in a macro that sorts some information out for me, but for the life of me can't find a code that will just select a column on the left/right without putting the exact cell name, which is not what I want. Here's...

Hi there, I hope that you can help me. I am wishing to copy and paste rows from a donor worksheet to a recipient worksheet based on one of 2 criteria being met in column H. When the appropriate rows are copied across there are gaps in the recipient worksheet pertaining to the questions that...

Hi all, I'm somewhat new to macros in Excel and I've been experimenting with a couple of macros but can't quite get what I need. I have three columns (AF, AG, AH) in an Excel sheet that I need to limit with a certain amount of characters (I can't use formulas as the data will be copy pasted)...

I have a column at Q in sheet OC where values are there Q3 to Q24. These values are fetched in real time. It changes every millisecond. I have raw data in different sheet which changes every millisecond. I use vlookup function to format and give meaning to it in OC sheet in Q column. I have...

Hello, I am trying to trying to create a Macro to move information from my 'Export' file to my 'Yearly' file based off the worksheet name in the Yearly file. In the 1st screenshot below, I need to copy all rows and only column A to P, and then move these rows to the matching worksheets in...

Hello guys! Hope u are good! Could someone please help me with this code I'm trying to edit an reach my goal? Goal: copy rows from a Sheet1 to a Sheet2, that meet a criteria, with a Date and time record! for example, all rows that have yellow as text in the colum G of sheet one, after I click...

Hi, Good day. I have a concern I hope anyone can help me. I have a list of files from d2:d4 on a worksheet. I need a macro that can open one at a time copy the latest date on a specific column and sheet tab and paste it to another worksheets, then close it, then open the next, etc. On Column D...

Hello fellow excel users, I have 5 spreadsheets each with 48 columns. Based on the values entered in 'column B' I would like to copy those particular rows but not all the columns to a separate 'destination' sheet. Also, checking across the rest of the spreadsheets. Please see below to the...

Hi Gurus, Do you have any thoughts on how to code this. I have a binary file with data ranging to 1 million lines. I am planning to copy the data in xlxs version. The header to be use is same with what's in the binary for all sheets. Example: Open Binary File that contains 1.05 Million lines...

Hi Guys, Happy New year! I found below code however, it seems like only column A of each sheet is being copied on the combined Sheet. Is it possible to adjust the range and copy everything except Row 1 for each sheet? = = = = = Sub Combine_Sheets() Dim startRow, startCol, LastRow...

Hello Gurus, Hope you are doing well despite the pandemic. I was wondering if you have any idea on how to code this: 1. I have a worksheet with 5 tabs or more (may vary). The headers are same (see below): Number Name Sales Div Data Note 1 Sam SA 100 2 Amy FA 90 2. I want to create...

Hello, I am very new to using VBA and don't really understand much at the minute. I am trying to get it where when the word "Yes" is selected in both drop down boxes in columns V & W, that row is then cut and pasted into the worksheet "Delivered". I then obviously want it to paste to the next...

Hello All, The purpose of the macro I am working on is to batch produce pdf customs documents, by copying the values from the variable workbook (it changes name every time I take a fresh download from the database), pasting them into the fixed workbook where the relevant customs info is...

Hello Gurus, Good day! Could you possibly help me amend the codes I found below: Basically, I am trying to create a PPT Template for my report - the charts, table format and tab names in excel are same. Is there any way to copy the format in excel (as seen in the excel print preview) on the...

Hi, I'm trying to figure something out with a macro that I'm working on. I'm not very experienced with macros but I'm figuring it out as I go, and what I want to accomplish is working EXCEPT when the source table doesn't have data for a particular filter. Here are the details (with fictional...

Hi Gurus, Could possibly help me formulate the codes so I can get the results like the Clean Sheet? I just need to get the data per account per month in descending order and will exclude those accounts with zero shares. Raw sheet <tbody> Account Name Note Mar-19 Feb-19 Jan-19 001...

Hi all! I'm super new to macros/vba and am working on a project for work that requires me to import csvs from a folder into a specific workbook. Each csv will need to go into a new sheet of this same workbook. I read around on the site to get the code I need to pull this off, but for some...

Hello Team, need to automate the process where in i am currently copy paste the data from one file to another file. Needed in macro. 1. Select the file that needs to copied (Source File). 2. Copy the all the cells, which have data. 3. Open the Destination File, last + 1 row & paste the...