copy & insert

  1. R

    VBA Code for pasting Value every nth cell in 2 different rows

    Hi there, I'm a bit stuck on some VBA code and need some help! I want to create some code for a macro button that will auto populate a value from cell A1 in cells Q19 and AJ19 and carry on doing this every 14 cells in both columns. It would be great if the VBA loop ends at row 355 as this is...
  2. K

    VBA for using a check box to Regen that row and then uncheck the box (ready to run macro again)

    Hello All, I'm making myself a task list, in this list i will have repeating tasks. Once the task is done (and dated) it needs to be done again (think how the laundry is in an never ending loop of despair). I'm VERY new to VBA and despite a few days of google searching (which I, previous to...
  3. K

    VBA to copy row from one sheet and paste above row on another sheet

    I have a workbook with 2 worksheets, one named "Timesheet" and the other named "Data". I created a button on the "Timesheet" worksheet (Add Work) that will insert a blank row on the row directly above the button. Row 2 on the "Data" worksheet has code in some of the cells and I want to...
  4. J

    VBA code to import new data to dashboard

    Good day all, I'm attempting to build a dashboard of Incident Ticketing data for our IT office. Every morning I extract a new Incident report from ServiceNow and import that worksheet into the dashboard excel file. I then try to update each row by matching ticket numbers between the new...
  5. S

    Custom VBA Dictionary Solution

    Searching for a custom VBA dictionary code, for a massive workbook, containing two worksheets, sheet1 (Release) containing +40K rows, sheet 2 (Resource) containing +185k rows. I realize that any VBA macro will take a long time to execute this command–given the amount of data, that’s okay with me...
  6. R

    VBA button that insert copied range of cells below and shift everything else down

    Hi, I would kindly ask for help to accomplish this instructions using VBA: I already looked everywhere and no luck, any help will be really grateful.
  7. M

    Copy a value of a cell into a certain cell based on value entered...

    Good evening all, The title sounds confusing so please let me try to explain. What I am trying to achieve is... When I type in a certain number (lets say "123") into one of those blank cells below into a sheet named "April", I would like the date above "123" to be copied and pasted into...
  8. G

    Search multiple strings and paste to adjacent column Macro

    Hi, I am brand new to VBA and I want to search for a bunch of keywords in one column that contains additional text like in each cell. I want to search for the keywords in each cell and paste them to an adjacent cell all by clicking a macro. How do I accomplish this? So far I have the...
  9. T

    Copy From Folder ready need add color Tracker.

    Hi Gods of Excel, how are you ? ? Guys, I took this formula from one place and try it works perfect. It can copy files from one folder to another, but I want to update it and add color in cells which were copied something as indicator ( fore example green color). Is it possible ? Example...
  10. F

    Copy rows in one worksheet to another

    Hi, I have a workbook that contains 2 sheets (Report and Report-Additional). The data in the "report" tab could be made up of any number of rows, but each row will always go up to column EI. The data in the "report-additional" tab could also be made up of any number of rows (and sometimes...
  11. B

    Excel formula to verify info in one sheet to pooulate a cell in another

    Hi I require the ability to do the following If Cell O31 on Sheet 1 contains "Yes" then the value of cell V40 on Sheet 1 is copied into cell E9 on Sheet 2 can I get so help with this thanks
  12. F

    Find first empty row and copy/paste data

    Looked around and tried to modify existing code but without success. I have a workbook with a command button. When i press the button i want to copy the data and paste it in another workbook. But it has to be on the first available empty row, so that i dont destroy the old data. So far the...
  13. D

    VBA - Loop files in folder, search column for keyword, copy range of text to spreadsheet

    Hello everyone, I'm trying to create a VBA program that will do the following steps 1. Loop through excel files in specified folder 2. Go through each file 3. Search in column B for "INTL" and/or "TRAX" 4. If "INTL" is found in column B, select that cell, move one cell over to column C, and...
  14. U

    VBA Copy, Move and Rename based on Cell Value

    Hi Guys, I have below data on a sheet with tab name "Data" Date NUM NAME TYPE DATE Subject Note 1 Note 2 10/1/2000 1 Ben Student - Math - - 10/1/2000 2 Ann Student - Science - - 10/1/2000 2 Cher Student - Math - - 11/1/2000 2 Joy Student - Science - - 11/1/2000 2 Sam Student -...
  15. U

    VBA Copy Multiple Sheets Data to Binary File

    Hi Guys, I have excel reference file named as Monthlies xxxx.xls format. Note that xxxx = date which changes every week. The file has 6 Tabs (Sheet 1-6). I need to convert the file first in binary then consolidated Sheet 1-5 on Sheet 1 as it normally consists of 300K lines when combined but I...
  16. M

    populate column k with most recent populated cell

    I have been racking my brain and google for a few days now and cannot figure this out. Column K is sparsely populated and I cannot figure out a formula to copy down the data from the most recently populated cell in that column whenever the adjacent cell in column L is populated. can anyone...
  17. U

    VBA Create a Copy of Sheet Multiple Times

    Hi Guys, I was wondering if you could help me on this. I have this Sheet with tab name "All Region" which is a formatted list. I want to create 8 copies onto the same workbook and just rename it as follows: 1. Germany 2. France 3. UK 4. US 5. Ireland 6. Canada 7. Other EU 8. Asia Any help...
  18. S

    Best way to create overview sheet showing elements of monthly sales forecast sheets from staff

    Hi - I need to create an overview sheet which pulls rows from each team member's sales sheets if they are more than 75% qualified. These are in tabs in the same Workbook. So, if a cell in sheet KIRSTY column J (Qualified) is either 75% or 100%, then that whole row should be copied into another...
  19. U

    VBA Browse Multiple Files and Copy Data

    Hi Guys, I have an open binary excel file (named "Masterfile"). I badly need the codes where the macro will browse from certain Source Folder and import multiple files onto the binary file. There are 3 files inside the Source folder namely: 1.) Survey.xlsx 2.) Checklist.xlsx 3.) CB.csv . I need...
  20. LokimotiveUK

    VBA to copy data from cell above if blank and stop when next data, then repeat

    Hi All! I've been going through tutorials for the past two days to start my journey in VBA, and need some help for an immediate problem. I currently receive a report from an ACCESS database that I don't have access to, and need to get the data filled correctly so that I can then start using...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top