|
Copy Insert Paste into all Workbooks in Folder
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, |
Copy Insert Paste into all Workbooks in Folder
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. "JavierDiaz4" wrote: 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, |
Copy Insert Paste into all Workbooks in Folder
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 "JavierDiaz4" wrote: 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. "JavierDiaz4" wrote: 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, |
Copy Insert Paste into all Workbooks in Folder
See
http://www.rondebruin.nl/copy4.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "JavierDiaz4" wrote in message ... 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, |
Copy Insert Paste into all Workbooks in Folder
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? "Ron de Bruin" wrote: See http://www.rondebruin.nl/copy4.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "JavierDiaz4" wrote in message ... 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, |
Copy Insert Paste into all Workbooks in 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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "JavierDiaz4" wrote in message ... 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? "Ron de Bruin" wrote: See http://www.rondebruin.nl/copy4.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "JavierDiaz4" wrote in message ... 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, |
Copy Insert Paste into all Workbooks in Folder
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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Ron de Bruin" wrote in message ... 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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "JavierDiaz4" wrote in message ... 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? "Ron de Bruin" wrote: See http://www.rondebruin.nl/copy4.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "JavierDiaz4" wrote in message ... 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, |
Copy Insert Paste into all Workbooks in Folder
Exactly. That would be perfect!
"Ron de Bruin" wrote: 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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "JavierDiaz4" wrote in message ... 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? "Ron de Bruin" wrote: See http://www.rondebruin.nl/copy4.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "JavierDiaz4" wrote in message ... 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, |
Copy Insert Paste into all Workbooks in Folder
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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "JavierDiaz4" wrote in message ... Exactly. That would be perfect! "Ron de Bruin" wrote: 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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "JavierDiaz4" wrote in message ... 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? "Ron de Bruin" wrote: See http://www.rondebruin.nl/copy4.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "JavierDiaz4" wrote in message ... 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, |
Copy Insert Paste into all Workbooks in Folder
Thanks a million Ron, when I grow up, I wanna be like you, LOL! Thanks again.
"Ron de Bruin" wrote: 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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "JavierDiaz4" wrote in message ... Exactly. That would be perfect! "Ron de Bruin" wrote: 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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "JavierDiaz4" wrote in message ... 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? "Ron de Bruin" wrote: See http://www.rondebruin.nl/copy4.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "JavierDiaz4" wrote in message ... 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, |
Copy Insert Paste into all Workbooks in Folder
You are welcome
-- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "JavierDiaz4" wrote in message ... Thanks a million Ron, when I grow up, I wanna be like you, LOL! Thanks again. "Ron de Bruin" wrote: 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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "JavierDiaz4" wrote in message ... Exactly. That would be perfect! "Ron de Bruin" wrote: 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 -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "JavierDiaz4" wrote in message ... 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? "Ron de Bruin" wrote: See http://www.rondebruin.nl/copy4.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "JavierDiaz4" wrote in message ... 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, |
| All times are GMT +1. The time now is 12:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com