copy & paste

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

Hi, I am trying to find text in one spreadsheet ("PerformanceT2") in column ("E") and the copy cells from the row in which text was found from columns ("E") ("F") and ("V") from that spreadsheet ("PerformanceT2") and then copy these cells into different spreadsheet ("Cal.PerfT") and paste them...

Hello, It's a pretty straightforward issue, I need to paste a set of rows (template), available in the first 3 columns of the excel sheet multiple times, for instance, 500 times, can anyone please help me to that with a VBA Code? I am a very beginner with VBA. Thank you. C4

I have taken over a project that someone previously developed the macros for. I would prefer it to work regardless of the dataset being used, but the person that developed it used mostly "fixed" ranges and I would prefer that it determines the range based on the data set. The beginning of the...

Hey! Through a macro I managed to adjust a report and automatically import it to Sheet1 starting in cell A2. A1:E1 are static column headers in each sheet. The .xlsm should be used as kind of "tool" to generate weekly reports. Now I want to include another thing: Loop through the rows of...