How to update multiple excel files in a folder with the data from a ref excel sheet

dssandhya

New Member
Joined
Jun 2, 2020
Messages
2
Office Version
  1. 365
Platform
  1. Windows
I am having 10000 different excel files that for Health check in my environment . I need to update 2 particular cell values in 10000 excel with specific data mentioned in another excel sheet for 1000 servers . The update data is host name and Ip address on 10000 servers .

A1- refers to excel sheet that contains data that needs to updated. For E.g - The server name and IP address should be copied in specific server file in the folder in a specific cell .(refer A2)
A2- Shows the excel file in a folder . For server- name 03RNB-WMGMT01 the file in the folder with the same name should be edited in the specific cell (refer A3)
A3- The specific server file has cells system name and primary Ip address - where the data from excel file that contains server name and IP address that needs to copied .


Please help suggest . I was able to modify a common value in all the sheets but this much dynamic data updating is blowing my head off
 

Attachments

  • A1.png
    A1.png
    29.1 KB · Views: 2
  • A2.png
    A2.png
    23.4 KB · Views: 2
  • A3.png
    A3.png
    150.3 KB · Views: 2

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Leandroarb

Board Regular
Joined
Oct 7, 2014
Messages
155
Hi!

How are you?

Excuse me for the indiscretion, but have you considered using a database?
 

dssandhya

New Member
Joined
Jun 2, 2020
Messages
2
Office Version
  1. 365
Platform
  1. Windows
Ok
Hi!

How are you?

Excuse me for the indiscretion, but have you considered using a database?
Hi!

How are you?

Excuse me for the indiscretion, but have you considered using a database?
I am fine Lean. Thanks
I am not from DB background so didn’t gave it much thought. Had consulted one of my RPA automation buddy he suggested to automate it using seasharp.
Still confused which way to go.
 

Leandroarb

Board Regular
Joined
Oct 7, 2014
Messages
155
Ok


I am fine Lean. Thanks
I am not from DB background so didn’t gave it much thought. Had consulted one of my RPA automation buddy he suggested to automate it using seasharp.
Still confused which way to go.

Good morning!

Think about the database access or other platform, you have a big work with 10000 files.

I work with access, and I've already had the need to export to excel format with a good result through the company's internal network.
 

Watch MrExcel Video

Forum statistics

Threads
1,118,971
Messages
5,575,300
Members
412,653
Latest member
JyothiGrace
Top