copy & insert

hi, wish to enter number "3" in D1 cell to get value "March" in cell d2?

Hello all, Been an avid follower the recent months looking to create a tracking sheet that delineates to the right after each ending week passes. The tracker has been made and now wanting to introduce a module with the intent to automate the the storing of tracked data. The code I'm looking...

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...

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...

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...

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...

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...

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.

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...

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...

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...

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...

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

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...

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...

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 -...

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...

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...

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...

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...