named

Hi All, I have an excel spread sheet that summarises a Table of data, currently using the Sum(countifs()) functions to look up columns and Count the number of time specific Criteria are meet. two of the criteria are in the form of Arrays. i would like to change these to Named Ranges and...

Hi, I have an xlsb workbook. I have a cell with the value 1 in it. Adjacent to it I have a cell with the Named Range “Club_name” – this cell uses the 1 as the row number in an INDEX function to lookup a name from a list. I have another Named Range called “Data” which also updates when the 1...

Hi, I have several named ranges which are blocks of 12 columns. How can I identify individual columns within the named ranges for use in a SUMIFS? The key thing is the named range is the starting point (as there are several exact sized ranges but with different names) and then individual...

I have never had this happen before in all my work with named ranges. I created some named ranges to reference INDEX() functions that are row specific in a table. For example: "=INDEX(A6Bals,LastRow)". The Named Range works fine until I close and reopen. When I reopen, all of my cells with...

I have a spreadsheet that adds additional rows to a named range. That part works like a charm. I need help with a macro to reset that named range to 10 rows; i.e. delete all but the first 10 rows. It would also be needed to limit the number of rows in the range not to be less than 10 by...

I would like multiple outlets to submit their weekly sales in excel files to a cloud location. this data would be in cells A2 to G2 in a file named Outlet code of each unit e.g. 0001.xls. These seven cells of each outlet i.e. A2 to G2 will be embedded in a main file placed on cloud in a sheet...

So I have some code that I have been using for about a year. It works great!! However, it is for a workbook where all the data is in range format. I recently re-built the data structure from the ground up in a new workbook, and implemented tables. It has made things much nicer and easier to...

My file could have about 30 tabs in it, one for each volunteer. If a volunteer didn't work on a particular day there's no tab for him. That's always been OK but now I need to add a tab that looks at a list of volunteers and if a person doesn't already have a tab in the file I need a blank tab...

Hi, I have a large number of named ranges and I want to run the same formula on all of them. It seems like I should be able to make a list of the named ranges and then run the formula on all of them but I can't get it to work...anyone? Thanks in advance. JFS

Hi All, How with VBA to get folder path if you know folder name only ? For example if you know that somewhere in computer there is a folder named “Invoices_2019” Thank you in advance

I have an excel file as the sample file share link . I would like to have a macro for arranging the shee1 to sheet2. Then I want to compare the sheet2 with another workbook named book1 sheet named Data1 for Invoice No, Item Name, and party name. If work book Data1 don't have such records then...

I have 2 userforms in my workbook. One is for entering a record, and the other is for editing/viewing a previously entered record. I would like to add an additional commandbutton to the editing userform that will copy the contents of the form and then instead of unloading and exiting the...

Need experts help on this after racking brain over and over. I have a data sheet, 'DATA', that contains Product and Pricing detail by row. Each row will have a column for Product Name (ie. Product A, Product B, Product C....etc), and a column for Location, (ie.Location 1, Location 2, Location...

Hi, I have a workbook that contains 32 separate sheets inside it. I would like to copy 6 of the sheet from it, but copy them to their own individual workbook and save each one as the tab name, and have them save to my desktop. Example of what I mean, some of the tabs I want are named "Accounts...

Hello Spreadsheet 1 Name : Weekly Results (tab 1 named : 01/04/2019; tab 2 named : 08/04/2019 etc....) Spreadsheet 2 Name : Weekly Report (tab name is "Weekly Report") Spreadsheet 2 tab with Date : Reporting Period ( tab name "Report Period" with Date entered in cell A1) I have a spreadsheet...

Hi there, I have rows of data in a sheet (sheet is named "Grant") that I would like to move to a new sheet named "Archive" automatically, once "Yes" has been selected from the dropdown box in column AK (data starts at row 9) in the "Grant" sheet. I would also like it to delete the row in the...

Hi all, hope you can help I have created a named table called Customer_List I select List in data validation But when I type =Customer_List into the source box I get the error “The formula you typed contains an error” But the named table has dotted lines around it so it looks like its selected...

Hi! I'd need some ideas in troubleshooting SUMIFS formula that returns #VALUE ! error I have a named ranges (within a table) to check particular "Department" + named range to check particular "Cost_type" and summarize the match. So the formula looks something like...

Using VBA I am trying to save data within a table column into a saved column, the difficulty is the column to copy the data from changes each month as it is time related. As an example the column titles are of a standard naming convention based on their type and the month e.g. "Cost Apr-19"...

how do i hyper link to a named range in another work book? i have: ='4. multi excel 4.xlsm'!totalnegative but it doesnt work