VBA Tutorial - Merge 2 Data Sets

I have two data/time series that I need to work on together.

One is continuous 30 minute intervals around the clock and the other is about 14, 30 minute data points per day.

The continuous data is a result field or formula and the other is static. I need to merge them together in a way that I can continue to manipulate the formula.

I think the data from the continuous time series needs to be called into the sheet dependent on the discontinuous one based on date and time.

Anybody know the best way to merge the two so the continuous/ computed set is still hot linked to the source sheet?

Hello Members,

I have a large set of data based on 1min intervals in the datetime column.
I wish to reorganise this data such that i have new values - 30 min averages.

I have tried to start a new column using the average function for the first few 30 min slots [that is =average(A1:A30) say], but when i try to drag the formulas down it ends up producing a rolling 30 min average [that is =average(A2:A31), =average(A3:A32) etc] instead of =average(A31:A60), =average(A61:A90) etc....

Is there another way to do this without having to write all the formulas in?
Pivot tables perhaps?

Thanks in advance from an excel amatuer.

Morning all,

Can anyone suggest a good tutorial on linking Access to Excel, possibly through data access pages?

I have a spreadsheet "Map" of the country, and lots of data stored by different scenarios in Access. What I'd like to get to is something where I can pick a scenario, and for that data to be shown on said map.

The table structure is roughly as follows

Scenario:
ScenarioName
Year
Situation

Supply Point:
Node
Volume
ScenarioName

It shouldn't be very complicated to link the two together, but not sure how to start this one off.

Is there a Tutorial on Connecting Live Data into Excel?

Dear Forum,

I am in need of connecting a Stocks Website Data to an Excel Sheet but am not so good in VBA.

I would appreciate if someone could help me with aTutorial to achieve this, as my requirements might keep on changing and it would be difficult to get help from the forum time and again.

SO can someone please help me on the same?

Hi, I would like to know if there is a method of creating a graph with multiple sets of data for the Y-axis, and with different sets of data for the x-axis... to illustrate
data set a
column1 column2
20.20821 -0.2067743
20.20700 -0.2089011
20.20879 -0.2110612

then data set b

20.20884 -0.2144541
20.20830 -0.2162071
20.20888 -0.2175114

I am attempting to do a routine mail merge (I do these weekly with no
problems until now) using an excel datasheet as my datasource in a word
document. I restored the program to make sure it had nothing to do with an
internal error. I also checked the data for errors, which it indicated none.
Is there some small thing I am missing here that would take care of this
problem I have not encountered before?

Program Steps

The program needs to find words in {} in Template sheet
find relevant column in Data sheet
substitute the data inside {} from the respective column and remove {}
save for all combinations below template

This is something similar to mail merge in word, but data is dynamic.

Thanks a lot in advance.

Hi,

I'm trying to create a macro that runs from an excel data source, opens Microsoft Word and merges specified fields into a letter (the fields/data are in the excel document).

What is my best approach for attempting this?

Thanks

Hi all and just want to thank everyone in advance for your help.

I have two spreadsheets they contain the following:

1. First Name Last Name Phone Address City State Zip -- About 30,000 entries
2. Is basically a lead sheet I use that contains fields for all of the above.

Is there any way that when I am talking to a customer from spreadsheet 1 to have that information merge into spreadsheet 2?

I can see this question has been somewhat asked in the past but unfortunately I can only follow specific instructions.

Thanks
Mooch

Hello,
I am looking for a single formula solution that searches the concatenated values of columns A & B for entries that do not match the concatenated values of: cell D1 and Range C4:C11, or E1 and Range C4:C11, and put the results in a list in column C from range C14:C30 as shown in the screen shot.
Thanks,
Ken

Sheet1 A B C D E 1 Work Order Sqwk W/O G1348 G1348I 2 G1348 105 STATUS AS OF: 06/03/11 3 G1348 105 SQK-100 PERFORM THE F/P EFFORT AS FOLLOWS FOR LH OUTBOARD AILERON: 4 G1348 110 105 CHECK ID & VERIFY PART NUMBER 5 G1348 115 110 DISASSEMBLE FOR STRIP 6 G1348 115 115 STRIP EXTERIOR 7 G1348 121 120 INSPECT STEEL FASTENERS FOR RUST & CORROSION 8 G1348 125 125 TOUCH-UP STEEL FASTENERS 9 G1348 125 130 REMOVE UPPER SURFACE PANELS 10 G1348 130 135 REVIEW AFTO FORM 103 11 G1348 135 140 INSPECT THE AILERON 12 G1348 135 SQK-100 Total 13 G1348 140 W/O & Sqwk MIS-CHARGED TIME 14 G1348I 105 G1348121 15 G1348I 110 G1348I1359 16 G1348I 110 17 G1348I 115 18 G1348I 115 19 G1348I 115 20 G1348I 120 21 G1348I 125 22 G1348I 130 23 G1348I 130 24 G1348I 139 25 G1348I 140 26 G1348I 140 Excel 2007