Questions tagged [consolidation]
160 questions
0
votes
1 answer
How to use vba for sumif function( data consolidation)?
Hi I have a data set like this:
A B
a 2
b 1
c 3
a 1
b 2
I Want to the consolidated data on column D and E that the duplicates are removed. Example below.
Eg.
D E
a 3
b 3
c 3
I have figured out…
Nefer Zhang
- 11
- 1
- 7
0
votes
1 answer
Consolidate Click Functions
How do I consolidate the following?
var vid01 = $("#vid01");
$("#img01").live('click', function() {
$("#aaaLogo").fadeOut(100);
$("#frame").fadeIn(100, function() {
vid01.show(setVideo(0));
});
});
…
FrankDraws
- 385
- 1
- 6
- 21
0
votes
1 answer
Consolidate data between 2 spreadsheets and delete data in source sheet with Google Apps Scripts
I've been browsing different forums & stackoverflow to find the solution to the problem in my script. Let me explain:
I have 2 distinct spreadsheets each containing one sheet. I want to consolidate the data from "Spreadsheet1 - Sheet 1" to…
BigBadBaptiste
- 19
- 6
0
votes
1 answer
Consolidate formatted tables?
I am trying to consolidate multiple formatted tables across all sheets of a workbook into one main table.
I have the following VBA to loop all the sheets and tables:
Sub GatherTables()
Dim tbl As ListObject
Dim sht As Worksheet
For Each sht In…
Salvatore Fanale
- 113
- 1
- 7
0
votes
2 answers
Excel VBA: Merge Rows and Sum Values
I have read just about every other question on here on merging rows and consolidating data. I did come across a solution I think will work for me, but when I ran the macro it didn't actually sum the right column. Being new to VBA, I'm having…
Adiamond
- 5
- 2
- 6
0
votes
1 answer
How should I consolidate graphics methods in Java?
So I'm creating a game where I'll need multiple methods that can output text (to a JFrame) or display images. I've created a GraphicsEngine that has a paintComponent method - but the thing is, this will run through adding it to a JFrame and not…
danishanish
- 345
- 1
- 3
- 13
0
votes
1 answer
Excel - consolidate with OR operation
I have in a sheet a table like so:
+------+---------+
| Name | Boolean |
+------+---------+
| A | true |
| B | true |
| B | false |
| C | false |
| C | false |
| A | false |
+------+---------+
But in another sheet I…
Pedro Witzel
- 368
- 3
- 14
0
votes
1 answer
Merging 3 MySQL Tables Into Consolidated Table Getting Too Many Results
I have 3 tables: members, products, product_costs
I need to consolidate the info from these tables into one single table. When I do this, I'm getting far too many results and I'm not sure why.
For every product, there should be a cost, but there…
Mike Smith
- 3
- 1
0
votes
2 answers
Consolidate AdWords Script
I have the below code in a script I am using for Google AdWords and it is working well however was hoping that it could be shortened or consolidated in some way easily. It is currently working however has nearly double the script run time and is not…
Ryan
- 82
- 8
0
votes
1 answer
Script to copy files on CD and not on hard disk to a new directory
I need to copy files from a set of CDs that have a lot of duplicate content, with each other, and with what's already on my hard disk. The file names of identical files are not the same, and are in sub-directories of different names. I want to…
John22
- 1
0
votes
1 answer
How can I combine sparse columns in a data fame?
I have an R script that creates a data frame with 61 columns. The data.frame is made by reading a bunch of csv files into a list of data.frames, then merging the list such that commonly named columns in each data.frame in the list populate the same…
Camden Narzt
- 2,271
- 1
- 23
- 42
0
votes
1 answer
Many workbooks consolidation
hello i'm having a problem with the macro bellow on the line 21,
worksheets.add.name = shtname
it seams to me that it's not changing the value of the shtname string once it end the first loop
i´d like to know what's happening hre is the code:
Sub…
Ygor Yansz
- 176
- 1
- 4
- 12
0
votes
1 answer
Openerp - Multi Company consolidated P&L and Balance Sheet
I am using Openerp version 7.0 and using "Indian Accounting template " to configure accounts for three companies.
1.ABC Solutions(Parent)
2.ABC Solutions Hyderabad(children of ABC Solutions)
3.ABC Solutions Delhi (ABC Solutions)
ABC Solutions Don't…
Samba
- 1
- 1
0
votes
1 answer
Local SQL Server 2008 Express data upload to Web based SQL Server 2008
Over the next few months, we need to consider the best technology/technique for periodically uploading SQL Server 2008 Express data that is held on a local network up to a Web based SQL Server 2008 server.
The idea is to allow us to consolidate the…
Mitch
- 2,471
- 8
- 38
- 46
0
votes
1 answer
INSERT new row consolidate similar rows
Here is what I need to accomplish:
INSERT a new row into t_order by combining two or more rows from the same table (t_order) where all values are the same except for order_id (Identity) and order_number
The New Row will represent a consolidated…
Mr.Drew
- 31
- 1
- 6