Copy Insert Paste into all Workbooks in Folder

  • Thread starter Thread starter JavierDiaz4
  • Start date Start date
J

JavierDiaz4

Hello Everyone,

I was wondering how can I copy Column C from MacroAllFile.xls and insert
paste it into all workbooks in a folder into the first worksheet in each
workbook.

Thanks in advance,
 
Ok, I have an easier one, All I want to do is look in Column C of each
workbook, 1st worksheet, and find the letter P, replace the letter P with a
formula.
 
Take that back, I cant paste the formula, it wont work, copy and paste the
column from another dummy workbook to all other workbooks would be better,
lets stick to the first idea. Sorry
 
Thanks Ron, which one do I use to just copy column C from MacroAllFile.xls
and paste that column on all 3783 xls in a folder?
 
Do you want to replace the data of column C of each workbook with
the data of column C from MacroAllFile.xls or do you want to insert this column
 
Btw: There is a example below the macro to copy a range

Replace the red code with this example and change the range and destination cell
 
Exactly. That would be perfect!

Ron de Bruin said:
Do you want to replace the data of column C of each workbook with
the data of column C from MacroAllFile.xls or do you want to insert this column
Click to expand...
 
Replace the red code block with this
Be sure you copy the code in MacroAllFile.xls and that this file is not in the folder with the other files

'Copy a range to a worksheet in mybook
On Error Resume Next
Set sh = mybook.Worksheets(1)
With sh
If .ProtectContents = False Then
With ThisWorkbook.Worksheets(1).Range("C:C")
sh.Range("C1").Resize(.Rows.Count, .Columns.Count).Value = .Value
End With
Else
ErrorYes = True
End If
End With
 
Thanks a million Ron, when I grow up, I wanna be like you, LOL! Thanks again.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copy past two existing sheets into 30 workbooks 4
VBA code for pasting links -- modifying RDB code for summary workbook 10
Import multiple workbooks to current workbook in specified row number 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
VBA - retrieve data on last create named range from previous inserted named range 0
How to bypass password when pasting FROM a protected workbook 3
how to copy worksheet to new workbook with values only 3
inserting rows into worksheets 2

Back
Top