copied

Hello I have tried using the hyperlink formula to dynamically link to newly created test sheets from a template sheet. Its a basic workbook at this point with the template having name "sheet1", and the subsequent test sheets having names "sheet1 (2)" and so on. I have used the formula...

Good morning everyone. You currently have a report where I must perform data repairs. In question, a copy and paste of data in specific columns through a specific line. graphically it is this. (https://i.ibb.co/FH8RmvZ/Animation.gif) Column A shows the line where I must carry out the...

Hey All, I am wondering if someone can help. Is there a way that if a file is copied or moved to a location other than the one i set in-bedded into the VBA it will pop up a message saying "Workbook should not be moved or copied from shared location". And then close? Reason is i have created a...

Hello, I have a workbook with over 60 tabs, example of their names: 111100 111100A 111100Detail 111100B 213100 213100Detail 213100A 131460 131460Detail 312504 312504Detail 312504Ele 312504Wat 312504Gas so they all start with a 6-digit code and they all have a code+Detail tab...

Dear All, I have an excel sheet where I have data in Sheet 1, A3 to H3, I want to copy the data to Sheet 3, A3 to H3 Then, Again, I start from Sheet 1, A3 to H3, different data set BUT Now this new data set should be copied to Sheet 3, BUT in the next line i.e. Sheet 3, A4 to H4 And so on...

Howdy, How can I copy data from multiple files (between 2 and 5 files) from a folder on my desktop? Every day I have to copy data, which are not arranged identically in each file, from sheet1 (each file has only one sheet), of each file found in the WORK folder. In a file the data can be in the...

Hi! I have a worksheet that contains a variable amount of excel tables. I have code to filter these tables, but then i want to be able to click on a cell (using a button probably) in any given table in a column that would be named "Add to order:" and have that active row get copied to a...

Hi dear forum members, I have a vba situation where I need to know the address of the range that is currently being copied (or cut) ie: when Application.CutCopyMode <> 0 . I wonder if I am overlooking some easy solution or missing something obvious. Regards.

Hi i have a simple sumif formula in B2:B11 that is = SumIfs(tel!$J$2:$J$11,tel!$A$2:$A$11,$A2) What i need to is when i copy the formulas across to C2:C11 I need to move these ranges down 5 rows down from the end so this tel!$J$2:$J$11 to tel!$J$16:$J$25 tel!$A$2:$A$11 to tel!$A$16:$A$25...

hi I am trying to copy entire row based on cell value and also wants to create a mail with the copied row data. want to paste the copied row as mail body. can anyone help me with this

Hi Are there anyone who can help? If I insert a row e.g. between rows 10 and 11 and in the new row I select SUB or RSD from the Drop Down List in column D, the values ​​in the row above the new row, must be copied down, except values ​​in columns H and I. In the new row, these cells must be...

Hi Experts, I have a situation where I am looking to copy data from one sheet across a range of cells on multiple other sheets but the copied value is dynamic. So -- Sheet1 has a list of items that I want copied to other sheets, starting in cell A1. Sheet2 has a range of B1:Y1 that I need the...

Hi, Please help me with VBA code to capture the current date when a particular cell in excel is clicked or copied. like doubleclick or rightclick event. <tbody> Order# Status Comments Last access date AD1212462 Completed Login success </tbody>

Dear Friends, I have a sheet having data in Sheet 1. I want to copy the data in Sheet 3 BUT with the incremental row. For eg Data is in Sheet 1 - A3 : F3 will be stored in Sheet 3 - A3 : F3, Now The next data AGAIN will be written in Sheet 1 - A3 : F3, But it should be copied & saved in...

Hi I have a worksheet tracking sales reviews. I want to copy specific cells from that worksheet to a sheet in another workbook depending on whether or not a given cell in the first worksheet contains the letter Y. The first worksheet will be looked at by me every Monday and I would like any new...

Hi All, I found a video on youtube that draws bingo numbers with no repeats so I simply copied the Macro code by hand, the first part works and creates a random set of numbers the second part however is coming back with an error. This part works fine: Sub StartOver() Cells.Clear...

Hello All I have a sheet (Master) where I have protected with password were I do not want anyone to change or modify. However, when sheet is copied and named as "today's Date" I want it to be unprotected so that it is changeable and can be modified. Perhaps when someone attempts to change...

Hello everyone, I need some help, im looking for a vba script that can loop through one specific folder and all of its subfolders located on a local network, in each of the subfolders there will be one or several .XLSM files, in each file there will be a tab named DATA with a range from A1:K1...

Hi all, I know how to find the last populated cell in column A however how do you paste the rows that I have copied below the last used? Thanks in advance

Hi, I copied a formula and transfer it to my worksheet. However, it returns an "N/A" unlike from where I copied it from is working. Below is the formula =(1+F7/k)^(k/p)-1 May I know how is it possible to use "k" and "p" in a formula? Do I need to assign a value to them?