pasting

I am new to VBA and I am trying to copy Cells B5-E5 and pasting the values into the active cell I have selected. My issue is that sometimes the column will change I will be pasting in column B-E or F-I and J-M. I was hoping someone can point me in the right direction on how to figure this out.

Hello! I'm attempting to copy a range from Excel and paste into a blank word document. The following code works up to the point where the pasting should occur. If I run the macro a new word documents open but it remains blank. The data is copied and makes it to the clipboard but won't paste...

Hi All, I have been reading through this forum for a while and struggling to come up with a solution. In my job we have a spreadsheet that has to have two spreadsheets (downloaded from SAP) daily, these need coping and pasting into a tab on our spreadsheet and completing a SUMIF, now the Macro...

Hi all, I have some vba running on my sheet that colour fills a cell if it is changed. Current code is this: Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("A5:F2000")) Is Nothing Then Target.Interior.Color = rgbBeige End Sub However - I am pasting...

Hi, I need help in using vba to copy the last cell which contains only a number and then pasting it to the row beside. Assuming the value below the last cell in column one gets updated with a value For example, Initial <tbody> Column 1 Column 2 1 1 NA (this value would get updated) NA...

Hey guys, Is there a macro for selecting multiple workbooks and then bring them to a new workbook in tabs? I have about 2000+ workbooks that I am currently copying and pasting and renaming each tab and it’s a pain! Any help is appreciated

I have a workbook with four tables that are updated monthly to create financial reports. Recently, one of the tables (just one) has not been accepting all the pasted values. It inserts the correct number of rows to fit all the source data but it may leave out anywhere from 7 to 130 records from...

Hi Guys how is everyone I have an excel task where I need to automate a task which involves copying data from the first columns of 4 tabs ( column A:A from sheet1,sheet2,sheet3 and sheet4) and pasting all this data in to the column A on sheet5 Stacked one after another, is this possible...

We recently upgraded from Excel 2013 to Excel 2016. When pasting values for a pivot in 2013, it used to keep the formatting but now in 2016 it does not. How do I make the pivot table keep formatting when pasting values? Thanks!

When downloading .csv files with a date range in a column separated as; 28/01/2018 I can't seem to change the date format to look as; January 28, 2018. I've tried copying and pasting as values, some text to column options but there doesn't seem to be an easy fix? Any suggestions?

I'm having trouble cutting and pasting an excel chart with the table of data next to it. I'm pasting as picture with an expectation to get a result that is exactly what it looks like on the excel sheet. Also, this has not been an issue up until very recently, and the issue follows all excel...

Hi Friends, I have this data in one column. Date 29-12-2017 30-12-2017 When I am pasting this data in another excel through VBA code , it is not preserving data format. This is the sane data after pasting. Date 43098 43099 I guess these are no. of days. Do we have a way in which we can...

i have a A4 = 167 if i want to copy this cell from 1 sheet to sheet 2 i can copy only precedents is it possible to bring dependents by pasting cell in sheet2? Any Tips would be Appreciated because it have Huge links in same sheet..i need to give individually

Hi Everyone, I am in need of copying filtered content from excel table and pasting it into another sheet below already existing data. I am using below code but it doesn't work fine every time. The sheet where it pastes it shifts 1 row leaving a blank row after every code run. Private Sub...

I have the following... Range("A3").End(xlDown).Offset(0, 5).Select ActiveCell.Copy Range("U3").PasteSpecial for the table... <tbody> Joe Golding (13-16) Season School Conf G W L W-L% SRS SOS AP Pre AP High AP Final Notes 2013-14 Abilene Christian Southland 31 11 20 0.355...

Hi All, First but definitely not my last contribution here! I am running into an issue with my macro where inconsistencies are appearing between various end-users. The issue falls in the pasting method; my macro starts off by pasting data from the clipboard into a new workbook and does some...

I have a large spreadsheet w/ over 8000 lines. I want to create 15 different worksheets (1 for each supplier) is there a way to automatically do that? I have been copying and pasting. I thought there might be something in subtotal - like at every change in vendor, create new worksheet, but...

Good afternoon, I have some data in cells A1:B10. I want to paste directly into another excel sheet, but fill the data upwards instead of downwards. For example, I want to paste directly into D80, so B10 = D80 and A10 = C80. Is there some settings I need to enable or some formula to...

I'm sure this is a very basic question for the folks here but, not being an Excel guru I figured I would ask the experts here. I am working with an Excel sheet on a regular basis which I update each week. This involves a lot of cutting and pasting. Sometimes when I do my updates and use the cut...

There's probably a simple answer, but brain isn't working today......I'm trying to move a tab (with formulas and conditional formatting) from one workbook into another. I've tried copying the entire page and pasting, but I end up losing all my formula's and my conditional formatting. Any help...