copying

Hi all, Just a quick question: I automated a load of reports here at work and the one thing I can't figure out is to configure the size of a graph when copying from Excel to word. I know you can use the copy as picture function, but that requires more 'thinking' than a simple copy and paste...

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

Hello, I have a the below table with x's (only mine is 100x300). <tbody> Adam John Fred Frank Apples x x x Pears x Bananas x x x Grapes x x Oranges x </tbody> I spend an hour+ each day copying and pasting into the below format by copying sheet...

Hi I've googled around a ton and have tried out a few examples but just can't make head nor tails of any of this, I'm self taught with both vba and excel and this just isn't my area so sorry if I'm being stupid. I want to feed the macro a permalink to an item page and for it to give me back...

I am using a FOR, NEXT looking, checking through a list of 5,000 names to see if the corresponding cell is populated with any data. if it does it's copying it to another workbook, going back to the original.....etc etc , it seems that doing this check and copying and pasting is taking a...

Hi, I am attempting to import the below website table into excel with great difficulty. https://www.flashscore.com/nhl/standings/ I believe the Standing table which I am trying to import is a JavaScript table. What is the easiest way (beside manually copying and pasting every time) to get...

Is there anyway that Row 1 can be copied and pasted into evry third row as in the the attached document. When the sheet is formulated only Row 1 has the data I need need to copy and paste and I just do it manually. Is there a way it can be automated. I have provided a link to what the finished...

How do I copy a spreadsheet that won't highlight. Can it even be copied?

Hi All, I'm using Excel 2007 for the first time in a while since switching jobs, I hide columns and try and copy what I can see but it's copying the whole line into the new spreadsheet. Annoyingly it doesn't do it on my colleagues spreadsheets only mine?! I've tried saving as different formats...

I have a macro that pulls a column from one worksheet to another, formats it etc but it is not copying over the formula For example, on the column I am copying it has a cell with the content of +Y4/Y2, and I need this to also transfer over but with the sheet name to refer it back to the...

I have the above issue which I am sure is a simple fix but I am far from a power user. I receive a list of companies with their link all in one text file. I got that into column B quite easily and then you can see the formula I used to split it into the text and the link of the company. What I...

In one of the columns that I'm copying from Excel to Access I have both numerical values as well as text values. When I copy it into an Access table, the numerical values are copied into the table but the text values are dropped. The field in Access is set to "Short Text." The field is empty...

Hi guys, I have the below code to copy down cells up to the level of adjacent column. I have a couple of questions;, If I run the macro multiple times I get excess data cells at the bottom. Do I need to add an if statement to stop the copying of cells if it is already level with column to the...

Can someone tell me what is wrong with below. It is not copying to last row of data in either column. Range("O2").Select ActiveCell.FormulaR1C1 = "=IFERROR(VLOOKUP(RC[-12],Collector,3,FALSE),R[-1]C)" Columns("O:O").EntireColumn.AutoFit Range("o2:o" & UsdRws).FillDown...

Hello, Whenever I have a large excel file (23mb), and I try copying any data (even one cell), excel will instantly freeze and stop working (as soon as cntrl+c is pressed). I've tried it on multiple computers, and I've tried opening it as a csv and txt file (still same problem). My computer is...

I have two workbooks within the same instance of Excel, wb1 and wb2. wb1 has this code in ThisWorkbook: Private Sub Workbook_Activate() Application.IgnoreRemoteRequests = True End Sub If I go to wb2 and copy the contents of a cell and try to paste it into wb1, nothing gets pasted...

My overall goal is to transfer Data from Spreadsheet A that has been filtered into Spreadsheet B that has also been filtered. Copying and pasting refuses to cooperate given the filtering, I've also tried using an equation to make the cells equal to one another but I can't drag and drop that...

I have created a spreadsheet that has some formulas in it that I need to protect from other users overwriting or deleting in error. I can lock and protect the relevant cells, leaving the other cells unlocked, but when I copy and paste data into it from another spreadsheet they get protected...

hi, sorry if this has been covered before. i have a table of names (75 in total) and values, every week the values will change on the table. What i am after is a code so that once i click on the control button it will automatically copy and paste the list of names and corresponding values into...

Is there a VBA code that would allow me to select folders in a directory and copy to another directory without copying over the subfolders and the files? Thanks :)