Seems this wouldnt be too hard, but I'm scratiching my head bald... I have multiple workbooks. They are all housed in the same folder. WBa, WBb, WBc. I need to combine these, (or at least a Worksheet from each) and have them tally a certain column, which seems easy enough, however, people are constantly adding to this folder, so either a manual daily, or dynamic tally would be ideal. Is there an easier way to do this in Excel? Is there a quick VB script for this? Thanks!

Member Avatar
Member Avatar
+0 forum 1

hello fellow programmers, i am doing an assignment for class and i am having a bit of trouble. So the assignments reads Given two sorted (in ascending order) lists of size M and N, write an O(M+N) algorithm to find the sorted (also in ascending order) union of the two lists. Assume each list contains no duplicate items. I know that i want to use a MergeSort to merge the two lists together, i just dont know how to write in code. So far i have: template<typename T> list<T> listUnion(const list<T>& one, const list<T>& two) { list<T> result; std::list<T>::iterator modifIter; …

Member Avatar
Member Avatar
+0 forum 3

Say I have 2 tables: Table 1 Name - Toys - broken - recurrence Jack 6 4 0 John 8 3 1 Mark 8 2 2 Jack 4 2 1 John 3 3 1 Mark 6 0 2 Table 2: Name - Toys - recurrence COlumn Name: name Column Toys: average of (Jack, John and Mark)'s toys (each a different record). Column recurrence: average of the 'broken' field when the recurrence is 1; My main issue here is how to write a statement to insert data from table 1 into table 2 with the correct calculations. I was assuming there …

Member Avatar
Member Avatar
+0 forum 1

Sorry guys, asking simple question for which i don't have the solution. please help me. Can you modify my query to return single column with both name and sname ?(rename the column if required) select name, sname from claim,CV where claim.num=cv.cnum

Member Avatar
Member Avatar
+0 forum 2

Why cannot we merge one to one relationship entities in one column?

Member Avatar
Member Avatar
+0 forum 1

Hi all, hope you can give me some help to edit my code. I'm unaware how to merge two arrays and allocate them to a third array(of the right size) and let's just say for the sake of things, we'll call it C. I went ahead and instead used the StringTokenizer, but I assume there's a simpler way to put it together. (Also, I'm getting the data from a .txt file, for my instance the file is called "SortedArrays.txt") import java.io.*; import java.util.*; class SortedArrays { public static void main(String args[])throws FileNotFoundException{ File f = new File("SortedArrays.txt"); Scanner s =new …

Member Avatar
Member Avatar
+0 forum 5

Hello, I am using a php function to merge 2 pdfs and it works great. <?php include 'PDFMerger.php'; $pdf = new PDFMerger; $pdf->addPDF('testFile5.pdf', 'all') ->addPDF('testFile57.pdf', 'all') ->merge('download', 'samplepdfs/TEST2.pdf'); ?> I get a merged pdf as soon as the page loads. I need the ability to make this merge happen when the user clicks a button, and I am stumped. Im a bit of a php nooby so please excuse my ignorance. Further more I need the user to be able to select or click and drag over pdfs to be merged. Any help is MORE than appreciated.

Member Avatar
Member Avatar
+0 forum 19

Hello, I am facing a problem in creating setup project in C# window applications. Actually I have made two pojects, one fee managment system and library management system. In library management project i have merged the fees management project, so that i can reuse Student entry and updation forms in library management project. It is working fine. But when i am creating the setup for library management project it adds the EXE file of fees project in library project setup, so when i install it on any computer, it makes EXE files for both library management and fees management. I …

Member Avatar
Member Avatar
+0 forum 1

Say I have a list of lists as follows (which I do): [CODE][['Value1', 'Value2', 'Value3'], ['Value1', 'Value2', 'Value3'], ['Value1', 'Value2', 'Value3'], ['Value1', 'Value2', 'Value3']][/CODE] What I want to accomplish is if in any list Value1 & Value2 equal the Value1 & Value2 of any other list, I want to merge those two lists so only one is preserved and the two values for Value3 are summed (then append the list back to the list of lists). I'm thinking along the lines of looping through the lists within the list, comparing the lists for matches where [i] & [i + 1] …

Member Avatar
Member Avatar
+0 forum 7

Using Data1.txt and Data2.txt, create two control break reports. The first should break on name and report the highest frequency style or styles. Send the report to result1.txt. Include appropriate headers. The second should break on style and report the total quantity ordered for that style. Send the report to result2.txt. Include appropriate headers. Use functions called Merge, Sort_Style, CBR_Name, and CBR_Style to simplify main. Use structs as needed. Also, you must use arrays of size 100 to input your data into and to store your merged data.

Member Avatar
Member Avatar
-3 forum 5

This snippet defines a function to merge sorted iterables containing similar items into a single iterable. Items are supposed to be sorted in ascending order. Only one item per iterable is stored at a time.

Member Avatar
Member Avatar
+0 forum 5

The End.