Stack Overflow
Stack Overflow

Questions tagged [consolidation]

160 questions
0
votes
1 answer

Merge multiple records into one record owned by a person?

How do I turn the following: username | userLastFirst | email | approver1 |department FAlbert | Albert, Frankie | abc123@ships.com | Doe, John |HR FAlbert | Albert, Frankie | abc123@ships.com | Smith, Mike …
Vincent Luc
  • 1
  • 1
  • 3
0
votes
1 answer

How to consolidate Sheet1 and Sheet2 in Sheet3?

I need to consolidate sheet1 (2 columns: A=REFERENCE and B=QTY) and sheet2 (2 columns: B=REFERENCE and C=QTY) with the result in sheet3, like: A=REFERENCE of sheet1 with sheet2 (unique data) and B=SUM of QTY sheet1 and C=SUM of QTY…
Epontes
  • 15
  • 6
0
votes
1 answer

Consolidating Workbooks with two sheets into One workbook with the same sheet. Second sheet will not copy correctly

I am trying to copy data from 3 separate workbooks into one workbook with two sheets. All the workbooks have the same set-up just different amounts of data. When I run my code, the second sheet "All Insured" only has the same amount as the coverage…
Kaylie
  • 23
  • 4
0
votes
0 answers

Find common ID set to consolidate Table of IDs

I hope I can explain my problem in an understandable manner. I've an ID range from 1 to 9999 I also have a table/list of arrays (~ 5 million rows) with each row containing a variable number of IDs (1 to 9999) no ID can be added twice What I want…
Janitor
  • 1
  • 1
0
votes
0 answers

VBA: Consolidate 2 columns into 1 using ListObjects

I have 2 tables: table1 (3rd party sales) table2 (Change of sales) I have a summarize table: table4 (3rd party and change of sales) I want to consolidate each columns from table1 and table2 into table4. I use ListObject because the order of…
Corentin Canet
  • 35
  • 5
0
votes
1 answer

Excel VBA: How to consolidate specific worksheets in the same workbook?

I have a workbook with 10 worksheets, 6 of which need to be consolidated into a single worksheet. Those 6 all have the same header row. I can get my code to work some of the time. However, if one of the worksheets is empty (only has the header…
Will
  • 21
  • 5
0
votes
1 answer

Copy varying range from multiple sheets and paste from same row

I am working currently with one workbook and want to implement a preparatory work, copy/pasting all the relevant range from my workbook contained in separate worksheets (3 worksheets at most). I have the below code to loop through the worksheets,…
Jules
  • 15
  • 4
0
votes
1 answer

How to collapse and aggregate rows with character / long string data

I am working on a large dataset with lots of text data that needs to be consolidated. There are supposedly unique cases / observations, but they do have duplicates. The catch is, that sometimes the duplicates cases provide complimentary and new…
Paul
  • 216
  • 3
  • 11
0
votes
1 answer

Consolidate data in more that one column

I have the below dataset: gene# (cell A) Databases (cell B) 1 Uniref 2 Genemark 3 GeneBank 3 Swissprot 4 Uniref 4 Swissprot 4 GeneBank 5 …
KGee
  • 323
  • 1
  • 9
0
votes
1 answer

Consolidate data from multiple worksheets into one sheet

I am having trouble with writing a macro that could consolidate specific data range R10C1:R26C2 from multiple sheets in active workbook as i have to write macro physically for lets say 14 sheets as you can see from example. is there a way where the…
syed
  • 1
  • 3
0
votes
0 answers

copy/Paste Range not the Same: Error...why is this happening?

I am working on copying and pasting ranges from multiple workbooks into a masterfile. I have am having trouble pasting one workbook, as it is telling me the copy/paste range is not the same....do you know why this is happening? It is working for a…
zemarshall44
  • 1
  • 3
0
votes
2 answers

Consolation of multiple columns/rows into one column/row

Ok, I don't think I explained properly before I need the table on the left to be consolidated into the table on the right. Thanks
user8722680
0
votes
0 answers

How to merge/consolidate multiples xlsb files into one

I need to merge multiple xlsb files into one using vbscript, all of them have a header, but only a header of the first file is needed in this merge, headers of the other files should be ignored. Anyone has an idea how to do this? I tried this…
Nattan
  • 13
  • 5
0
votes
0 answers

Excel 2010 VBA: Consolidating data from tables in closed workbooks: Copy/Paste or Array?

I've got a macro to consolidate data from 2 different tables in 14 different workbooks, tblstaff and tblwage. Currently, the way the code works is: Open source WB copy ListObject.DataBodyRange from each PasteSpecial (xlvalues) into consolidated…
sockpuppetmonkey
  • 51
  • 7
0
votes
2 answers

c# - Using LinQ to look for duplicate items in a list and updating object properties if so

I have a list Allflights of object type FLightInfo. If an object from the list has the same flightNumber and takeofftime. I want to consolidate those entries and add their user count Example: This is my list: FlightNumber 123 Takeoff 12:00…
Fernando
  • 29
  • 6
1 2 3
…
10 11