griffinlross
08-02-2017, 11:57 AM
I need help combining 3 worksheets into one and some of the columns have different headers and are in a different order. All of this is in Excel 2016. If there is a VBA to run that can do this that would be much appreciated.
The first worksheet's columns are in the following order:
Date Time
C
Event
Period
Surv(M)
Actual
Prior
Revised
S
Ticker
The second:
DateTime
Name
Country
Volatility
Actual
Previous
Consensus
Third:
Date
Event
Impact
Previous
Consensus
Actual
Currency
I would like to sort the master sheet by date and the third sheets date format is 2017, August 02, 00:00
Meanwhile, the first two sheets date format is 08/02/17 03:30
Event and Name can be merged into one column. C column is the same as Country in the second worksheet but country is included in the event column of the third worksheet in parenthesis. S, Impact, and volatility can be combined into one column. Prior and previous are the same, actuals are the same so those can be combined as well. Is it possible to update the worksheet automatically as well using a calendar online or bloomberg?
The first worksheet's columns are in the following order:
Date Time
C
Event
Period
Surv(M)
Actual
Prior
Revised
S
Ticker
The second:
DateTime
Name
Country
Volatility
Actual
Previous
Consensus
Third:
Date
Event
Impact
Previous
Consensus
Actual
Currency
I would like to sort the master sheet by date and the third sheets date format is 2017, August 02, 00:00
Meanwhile, the first two sheets date format is 08/02/17 03:30
Event and Name can be merged into one column. C column is the same as Country in the second worksheet but country is included in the event column of the third worksheet in parenthesis. S, Impact, and volatility can be combined into one column. Prior and previous are the same, actuals are the same so those can be combined as well. Is it possible to update the worksheet automatically as well using a calendar online or bloomberg?