Change same cell in multiple files.

  • Thread starter Thread starter promethious
  • Start date Start date
P

promethious

I have about 150 Excel files that I need to replace the content of
specific cells (A2, A39, D39, and A53) in all of them. I have on
workbook with the new correct data in it. Is there any way to replac
the data in all of the other files without actualy opening them an
copy - paste them
 
No, but it is easy to do with a macro (open them and put in the new data).
 
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

If question 1
find replace in multiple sheets based on namebox 2
... I need some help with a formula ... 3
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Numbers change in cell even when formatted as text 4
Copying multiple cells out of multiple worksheets at same time. 1
data from multiple files: best way to extract 1
Sharing workbooks limitations - Merged Cells 12

Back
Top