combine

Hi Would like to create a sheet that automatically pulls info from two separate tables when they are pasted into a file. To clarify, two different tables are pulled from a system, pasted onto two separate sheets in an Excel file. I then have to add the two lists together onto another sheet...

hi all i need to combine multiple workbooks with password into one, but while someone is opening one of it, it shows error, i would wanna know how to fix it, thanks:rofl:

Hi, I'm trying to figure out why this nested if is giving me a false: =IF(OR(F3="Y",AN3<=6),AQ3,IF(AND(O3="N",SEARCH("Open",D3),AQ3>=3),AQ3,IF(AND(SEARCH("Open",D3),O3="N"),IF(OR(AND(VLOOKUP(A3,'WOs (DSP Only)'!A:B,2,FALSE)>=3,(365/((AN3*AQ3)/VLOOKUP(A3,'WOs (DSP...

Hello, I am working on a problem and I thought i would see if someone here could help. I have a workbook that has a worksheet for each Client that we serve, and I will need to continue to add worksheets as we add Clients in the future. Each worksheet is the same where it lists the...

I am working with 7 lists using conditional formatting to sort list selections by color. I am hoping to find a way to combine list results to reach a conclusion. Each list supplies the option to choose Low, Minimal, Moderate, High. If List 1 is Moderate, List 2 is Low, and List 3 is Moderate...

Excel produces me various .pdf files, some i then combine to produce, for example a drawing pack. What i now need to do is select some, but not all, of the pdf files in the folder, in a particular order (rather than just reading down the list) The code i am using to combine the files is: Sub...

Hi I thought I was doing it the right way but not because it throwing it out. Im trying to combine macros into one so they all run one after the other. I thought that you created a macro called combined and then just input the macro names you want to run? Tried inputting...

I have 5 workbooks and I need to pull two select, completed sheets out of each of those 5 in order to combine those into a new workbook. From there I am going to use that new workbook to run a print macro I already have. It's just cumbersome to go into each of the 5 workbooks, select the...

I work in MS Access almost exclusively in Design View because I have to do quick little queries often and it is fast and easy. With that caveat, I would prefer to have a solution in Design View if at all possible. I am trying to combine wildcard queries that are both "Like" and "Not Like". When...

Hi guys, sorry again for a simple question but I cant seem to get it to work. If Weekday(rngCel) = 1 Then rngCel.Offset(0, 1).Value = 45 .NumberFormat = "0.00" If Weekday(rngCel) = 1 Then rngCel.Offset(0, 1).Value = Format(45, "Currency") I have tried with this...

I have a file that on one tab has countif statements that yield percentages and on another tab I have linked certain cells, what I need help doing is I have 2 cells on tab 1 that I need to combine the percentages on tab2. Cells K3 and L3 currently 40% and 7% on tab 1 need to be combined on tab 2...

I'm working with multiple worksheets in one workbook and want to find a way to extract data from the multiple tabs into one sheet. Each tab has different headers, see below. I only want to pull out certain data. Each worksheet would be updated weekly. TAB 1 HEADERS: <tbody> Shoot Date Air...

Hi, Anyone know how I can combine these formulas? =IF(OR(ISBLANK(A5),ISBLANK(B5)), "" =SUM($H$5:H5)-SUM($I$5:I5) Thanks

Hey... I'm a newie on Excel and I've seen a lot of smart people around. any of you came across the given exemple below? I've got a column of different products, and I'd like to find all combination of procucts up to a maximum value of 2,45 meters and count all those combinations to optimise the...

I would like to combine records into a query. For example, the table would be Jane, Doe, teacher, math Jane, Doe, teacher, English I would like the query to have: Jane, Doe, teacher, math English

Hi all, I always thought that I was rather skilled at working with Excel, but I’ve got me a ‘problem’ that I can’t fix by myself. Looking at the topics and solutions offered on this forum I’m merely a novice compared to what some people can do. Therefore: Any help would be much appreciated...

Hi all How can I combine a Proper and substitute formula together?

I’m trying to combine 2 AND statements and can figure it out. By their selves both return TRUE... =AND($H2>=$C$2,$H2<=$D&2) =AND(K$1>=$B$3,K$1<=$B$3) Thanks for looking and for your help in advance. Charlie

Hello all, In my user form, I have two comboboxes. "uf1_hr" is a combobox that allows the user to select one of 24 values representing each hour of the day (0-23). The rowsource data is numerical. The second box, "uf1_min" (rowsource is text) allows the user to select 1 of 4 available...

I need to combine 2018 invoices into one main invoice for the year. Each month has employee names and the amount of premium for health insurance. Some months employees drop off or new ones are added. Is it possible to somehow combine all of these monthly invoices into one for the year showing...