combine

to combine multiple sheets from one workbook to another worbook. I have one SHARED workbook "Tasklist" with mulitple sheets (all sheets have the same data) and another workbook called 'Master". I would like to combine the all sheets starting from Row 2 and display it on A5 onwards in Master...

I have a column that has comments and I would like to combine those comments into one cell which =concat does but how can I add a comma and space between the comments from each line Column 1 = Topic Column 2 = Comment Not every row has a comment though Your help would be greatly appreciated

Need help on below. Basically, I want to combine all the data from worksheets into one worksheet. And this workbook is shared and will be used by multiple users at the same time and save the files before combine. However, when run the macro, it is not responding. Code: Sub Combine() Dim J...

Hi All, I'm looking to do a countifs formula with one of the criteria being a cell length of 9. I've done some research and found the following: Can you help with how I can combine this with my countifs: Many thanks :)

Hi Everyone, I need your small help in execute a macro to combine sheet i have three sheet by the name of sheet1, sheet2 and sheet3 all have same headers and data avaiable in A1:C10 i want to combine all three sheets into one. kindly help

Hello Is there any other way than power query to combine multiple columns of a table and get a report in pivottable?...

I am attempting to combine 2 countifs formulas and then divide them by another countif and am getting 240% and I cant figure out what I am doing wrong. Below are the countifs that I am trying to combine and the third is the one I am trying to divide by. For reference the first set of formulas...

I have a vlookup in Google Sheets that isn't making sense to me. =MID(A3,search("(",A3,1)+1,6) returns 263972 =vlookup(263972,$S$3:$X$158,3,0) returns the expected result =vlookup(MID(A3,search("(",A3,1)+1,6),$S$3:$X$158,3,0) returns N/A. (Did not find value '263972' in VLOOKUP evaluation.)...

I need a macro to combine a bunch of excel files into one file. i want something that when i am ready to combine the file it prompts me to pick a folder and whatever is in that folder gets placed into one combined excel sheet Thanks in advance

Hi everyone, I'm new to this forum and hoping to get help with an issue I've been trying to resolve for a few hours now. The company I work has two entities with separate sets of accounting books in QuickBooks, the US-based accounting software. I'm trying to combine identical data sets from...

Hello all, It was kind of tricky to come up with the best way to title this thread...my apologies for vagueness. I have a pretty big spreadsheet with a lot of detailed items. Rows A:CV are a bunch of details about an item. Rows CV:DH are a list of categories...if the item meets certain...

I am trying to merge 4 date and time cells together into 1 cell. I am using the following formula: =CONCATENATE(TEXT(Table_query__42[@[Soft Lock 1 End]],"mm/dd/yyyy h:mm AM/PM"), "; ",TEXT(Table_query__42[@[Soft Lock 1 Start]], "mm/dd/yyy h:mm AM/PM"), "; ",TEXT(Table_query__42[@[Soft Lock 2...

I need to locate two values and combine them in the same cell and add a text value. The final result would look like this: $3000/$6000. =VLOOKUP($D$6,'Portfolio 2019.csv'!$D$4:$AE$116,5, FALSE) & =VLOOKUP($D$6,'Portfolio 2019.csv'!$D$4:$AE$116,6, FALSE) I have tried a few different...

I have 1 workbook with 8 worksheets. All worksheets are set up in the same format using columns A - Y. Is there any way that I can easily combine all worksheets into 1? On the new worksheet in column A I'd like the name of the orginal worksheet and the actual data to be from coumn B - Z. Thank...

Good Morning, I am attempting to combine a Dynamic rolling chart with aCombo box to select different data streams. For example: The data sheet has sales volumes for 3 customers frompast 36 months I have been able to produce a rolling chart using OFFSETformula and named ranges which...

I'm trying to combine hlookup() and offset() to find the last value in a row, then go up 2 rows and left 1 cell. Each works independently, but when I try to combine them, errors occur. =OFFSET(M3,-2,-1) --- "M3" is the below hlookup() reference =HLOOKUP(9.99999999999999E+307,B3:Y3,1) Is...

hi expert.. i need your help, how to combine this 2 argument in single argument : INDEX($L$2:$L$31;MATCH(A17;$K$2:$K$31;0)+IF(master!F2>0;0;IF(master!F2=0;2;1))) i want this below formula can be inserted in above formula =VLOOKUP(I2;master!$A$2:$O$5;6;FALSE) i have trying to combine it but...

Hello kings i want to to combine ( sum if with subtotal ) to calcul consomation of Motor fuel so when i filter a car number it can calculate Gasoline Diesel fuel exemple in picture

Not sure how to combine this into one formula. =IF(ISNUMBER(SEARCH("m",Invoices!C2)),"DC","DS") =IF(ISNUMBER(SEARCH("c",Invoices!C2)),"DC","DS") Thanks, Matt

Hi I have 2 payroll tables. MAIN and MGMT. They both don't contain the same fields, but do have common fields such as name, date rate... I currently paste the data from our payroll export into 2 tabs and pull them into power pivot and back down as pivot tables. But I would also like to...