copy & paste

Hi, I am new to VBA and need some help with some of the procedures I would like to automate. I have two excel files to work on - employee and contract data. Basically, I need to find employees who end their contracts in the current month that I open the file. (For example, if I open the file in...

Everyone is familiar with the "Paste Column Widths" command that will take information from the clipboard and use it to transfer the column widths of a copied range to another range without including the actual data from the cells that were copied. Thus, it seems to me that when a range of...

I have a large database of information in Excel (no other software choice unfortunately) in which others want to insert data into, without worrying about entering the data into the wrong cells and dirtying up the data source sheet. Said others are not Excel-savvy, and as such I need to prepare...

Sub mM() ' ' m Macro ' ' Keyboard Shortcut: Ctrl+Shift+M ' Workbooks("Academic").Worksheets("Manpower Details").Activate Range("B" & Rows.Count).End(xlUp).Offset(1).Select 'ActiveCell.Value = Format(Now(), "Mmm yy") Dim ws As Worksheet Dim lastRow As Long Dim Alastrow...

I have in total 5 excel workbooks. Workbook 5 has the VBA code. Workbooks 1-4 have the same sheet names but with different content. I do have the below code to import 2 sheets from workbook 1 into workbook 5. Is there any way I can look for the the next blank cell in workbook 5 and import the...

Hi All, I have what I thought would be a simple copy/paste macro which appears to ignore my attempts to put a constraint on it. I'm sure there is something I am missing but I can't seem to spot it. Any help would be appreciated! Ideally the code looks at Table 2 and checks the column in the...

Very new to VAB and I have a workbook with both values and free text survey responses. I'm trying to cut the Free Response Text columns to their own sheet in my workbook. The columns this free text will be in may vary depending on the survey data entered, so I've used the input box to allow the...

Hello, including a sample of my sheet to help explain below. What is included was done manually, but I have to repeat this a few dozen more times so hoping to figure out how to drag this down correctly? Essentially I am trying to summarize data from another sheet. In this summary sheet, it needs...

I'm really not sure how to word this: I want to be able to create a template (or something) that I can 1 button press insert (like how styles are), but that is multiple cells with text and formatting. Essentially I want to be able to copy and paste the same group of multiple cells, but without...

I need a macro that does the following. - if there is a value in A3:E3, it copies and pastes to the corresponding cell in table 1 based on the date in A2:E2 and the corresponding date in E9:E11 in this example, copy and paste from C3 to D11=4,000,000 (August) and E3 to D13=4,000,000 (October)...

I have a macro to copy and paste a table from one sheet to another. I used macro recording to get this VBA: Sub CopyPasteNew() ' ' CopyPasteNew Macro ' Copy table from "New Term Deal" to Active/open sheet ' ' Sheets("NEW Term Deal").Select Rows("3:27").Select Selection.Copy...

Hello everyone! I'm looking for some help on how to go about making a code to Loop a file with 3 tabs and then copy, paste, and save another spreadsheet with the data. To be more specific I'm trying to do the 4 things below. I would like to have the code in an excel (called "Data") that will...

I'm doing my quarterly BAS statement and I'm moving all business expenses from one column into their designated columns with their correct labels so I have a total of each column at the bottom of the table. Anyhow, I'm attempting to cut or even copy and paste this numerical data from "column A"...

Looking to copy the contents of one sheet that has a filled out template into a new sheet without changing the template (maintaining highlights), and without the formatting. The letters represent identifiers that will have the information pasted to the right of each. Here's the path I am...

I have to prepare a macro for tickets. I have workbook (Test100). User open this workbook. If in column F in this workbook, user gonna change value (doen's matter what is the change, it can be just typping "x" inside the cell), macro should: a) open new workbook (Test02) in specified location...

Hello, VBA beginner here. I have just started to learn VBA. I found the following piece of code posted at: Macro prompts User to choose source workbook from folder and paste to destination workbook template Sub copyFromPlanillaReservas() Application.ScreenUpdating = False Dim cTr As...

Good day! Hi, need a little help on this one, how can I copy and paste visible cells to another column? The data attached was subtotaled. I want to copy the values of Column E (visible only) then paste it on Column F respectively. I'm still learning VBA and I can't execute this one. Missing the...

Hi all, I've had some trouble figuring out what I had incorrectly assumed was an easy problem. I've built an excel document that I'm pretty proud of, but have reached a stopping point trying to fill two side-by-side formulas from different sheets to perform some calculations. I am on Excel...

I will need to create a button that can be named "Validate". By clicking on this button the total in cells E20 and F20 will be copied into the "Paste" sheet in the corresponding case. (Name and date)

HELLO – I feel like I am asking for the moon with this and I don’t know if this going to be possible, but worth the shot to ask the brain trust…. Some background info… I am currently building a billing spreadsheet for our business. Essentially, we hire out trucks and bill on a time and km...