combined

I have the following macro which does the following: Get the file names from a folder on Windows Combines the name with the folder name Hyperlinks the conjoined names How it looks in the table (the folder path is longer now and not sure if that is a problem in the script as to where the...

Good day! Anyone can help me please? I've been looking for an EXCEL VBA code in which i will have the option to select a folder path first which all the workbooks i need to combined is saved and have all the first sheets in all workbook in that specific folder is then combined to a new...

Hi All I have: Can they be combined in one countifs expression at all? Many thanks

Hello I have two spreadsheets in the same workbook, I need to pull information from each into a third worksheet. The worksheets are labeled ASV, IAR, Combined. The two worksheets have alot of columns (not necessarily the same columns). The number of rows vary between the two Is it possible to...

Access 365 Within my main form f_pac, I have 3 check boxes (USA, Canada, Combined) I need to have them enabled/disabled. If either USA or Canada is checked then disable Combined. and if Combined is checked disable USA and Canada. How can I do this?

Hi, Please can I ask if this can be done? I am wanting to vlookup some data from a cell (K3) firstly then if that is blank, vlookup on L2, then if that is empty to use an indirect function to use a dropdown list from a named range. I can do the first 2 parts...

I have two ranges: R1 and R2. They have same header How to combine them so R1 is on top and R2 is at the bottom to form a new combined range called "R"? Thanks

Cell C1 has the name 'Bob' in it and cell D1 has the name 'Sue' in it (without quotes). The formula below is returning 'Bob combined net income (before retirement)' just as it should and if C1 is blank, it is returning 'Name & Spouse/Partner combined net income (before retirement)'. This is...

Hi, I'm trying to do a SUMIF over two worksheets for a number of values in a lookup table. The idea is that in cell AV39 there should be an addition of the associated combined scores on the look up sheet, Column D. The issue comes when there are some Pt Nos that have aslight variation in the...

Hi all. I have a worksheet that contains 8 sheets, 6 data sheets(data 1, data 2 etc), 1 control sheet and a combined sheet. I'm trying to combine the data sheets into the "combined" sheet and exclude the info on the control sheet. each data sheet is setup identical with headers in cells B2:K2...

I'm currently using two formulas that works great. Thing is.. I'm combing two columns C & D w/ =C2&"-"D2)for the search on DISPO! Sheet. Searching through "J" and finding a match on Sheet (Key! returning results from columns 2 & 12 . It doesn't return correct result when the combined =C & D...

I have 2 set of numbers that I would like to mix them. My first set contains 15 numbers that I would like to combine with a set of 10 numbers and distribute them into colunms. From the set of 15 numbers, the code will choose 9 numbers (randomly) and combine with 5 numbers from the set of 10...

I have this line of code in my project... .Cells(i, 1) = CStr(CLng(.Cells(i, 2)) & Format(i - 1, "000")) Its purpose is to create a value for cell A(row) = the combined values of cell B(row) (a true date value formatted as yyyy-mm-dd), and the row number (i) minus 1. So, if the date value in...

i have a payroll tab which lists all member of staff for a department. I want a formula that will look at this whole list and then list the users employment id's when a criteria is met. so in total i want to produce 3 seperates. i want one that lists all the staff who are down as new sales. i...

Hi, I'm after a formula that can calculate - If shift 1 equal zero it will return shift 2 and verse versa Thank you <colgroup><col width="93" style="width: 70pt; mso-width-source: userset; mso-width-alt: 3401;"> <col width="130" style="width: 98pt; mso-width-source: userset; mso-width-alt...

Please help! I have a workbook with c300 tabs - all tabs are formatted the same (i.e. same headers) but have different numbers of rows. I know that to consolidate all of these into one sheet I can use: <code class="vb keyword" style="white-space: nowrap; padding: 0px !important; font-family...

Dear Members, I would be extremely grateful if anyone could guide me in the right direction. I have appended two sheets using power query and made combined report. How can I make sure that if I make an entry and that entry is also updated in combined report ? So, I would like to enter numbers...

I thought this vba routine combined all sheets in workbook into a sheet labeled combined It also included a column with name of sheet so I can pivot which is very helpful but I have a workbook of over 128 sheets and the routine does not seem to catch all of the sheets anyone see what the issue...

I really hope that someone could help me with this one as I have tried to study videos and still have no idea how to do what I'm looking to achieve, an I apologise if I'm not explaining properly. I have master table of data that I'm looking to develop a report from: <colgroup><col...

Hi, I have a huge data in excel with multi rows and columns. I want to regenerate the same data columns but some rows needs to be combined together based on the duplicated TXN no. below an example of the requested: Kindly assist me to have the data the same way i want.