Copying and inserting multiple rows between spreadsheets

Dennistoun Dark

New Member
Joined
Jun 1, 2016
Messages
28
I have 2 spreadsheets; the master has the server name and details as a distinct row. The other has all the applications on that server as multiple rows. I want to copy the multiple applications to the master spreadsheet by inserting a new row for each application and pasting that into the application column.

Any ideas?


Thanks

Frank
 

Dennistoun Dark

New Member
Joined
Jun 1, 2016
Messages
28
Just to clarify, Spreadsheet 1 has:

Business Area
Server Name
Domain
Status
Environment
Physical or Virtual
Model
Type
Site
Application Name
Application Version
Clustered or Load balanced
OS Name
BA1
Server 1
Deployed
Virtual
VM1
Server
Site 1
Windows
BA2
Server 2
Deployed
Virtual
VM2
Server
Site 2
Windows
BA3
Server 3
Deployed
Physical
Physical 1
Server
Site 3
Windows
BA4
Server 4
Deployed
Physical
Physical 2
Server
Site 4
Windows

<tbody>
</tbody>

Spreadsheet 2 has:

Server Name
Server Type
Operating System
Applications
Server 1
Virtual Host
Windows Server 2003 5.2.3790
App 1
Server 1
Virtual Host
Windows Server 2003 5.2.3790
App 2
Server 1
Virtual Host
Windows Server 2003 5.2.3790
App 3
Server 1
Virtual Host
Windows Server 2003 5.2.3790
App 4
Server 1
Virtual Host
Windows Server 2003 5.2.3790
App 5
Server 1
Virtual Host
Windows Server 2003 5.2.3790
App 6
Server 1
Virtual Host
Windows Server 2003 5.2.3790
App 7
Server 1
Virtual Host
Windows Server 2003 5.2.3790
App 8
Server 1
Virtual Host
Windows Server 2003 5.2.3790
App 9
Server 1
Virtual Host
Windows Server 2003 5.2.3790
App 10
Server 1
Virtual Host
Windows Server 2003 5.2.3790
App 11
Server 1
Virtual Host
Windows Server 2003 5.2.3790
App 12
Server 2
Virtual Host
Windows Server 2003 5.2.3790
App 1
Server 3
Server
Windows Server 2003 5.2.3790
App 1
Server 3
Server
Windows Server 2003 5.2.3790
App 2
Server 4
Server
Windows Server 2003 5.2.3790
App 1
Server 4
Server
Windows Server 2003 5.2.3790
App 2

<tbody>
</tbody>


I want to copy the data from spreadsheet 2 into spreadsheet 1, creating a new line for each application on every server.
 

Forum statistics

Threads
1,081,560
Messages
5,359,608
Members
400,538
Latest member
leon_oscar

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top