stored

Hello Team, I have workbooks stored in the folder with the different names, i have to create a master out of those in one workbook. Workbooks stored in the folder contains name starting from Apples_x.xlsx ddd_Apples_Y.xlsx CCC.Apples.xlsx Grapes_dd.xlsx Grapes_PP.xlsx Each workbook contains...

Hi I have a reoccurring issue with a daily EXCEL file I prepare. Quite often I will open the file after it has been prepared earlier, and all the macros that were stored in the workbook will have disappeared. Any suggestions for how I can rectify this situation? Kind Regards RUMPOLE

I have a spreadsheet which contains pricing information which I refer to when creating estimates. When I enter the pricing information, I record the year I entered the amount. I'd like the spreadsheet to show both the escalated rate and also the escalated rate. Unfortunately, escalation does...

Good morning, I'm working in MS Excel for Office 365 (MSO 16.0.10730.20344) 64-bit. I'm copying large numbers over from a table to a new sheet. They're all numbers stored as text. I can convert them into numbers. They're all different numbers stored as text, but when I convert them back to...

Hello! I have a simple excel file from which I'd like to share just certain rows and no comments with my colleagues in a separate file stored on a common file area. I'm thinking about creating a copy that is automatically updated at least daily in which some of the rows and all of the...

I have a spreadsheet that is used to generate quotes for clients. The worksheet (npss_quote_sheet) is used to generate 1 quote for one client at a time. There is a table (npss_quote) that lists the services in the quote for the one client. Once all services have been entered, the quote is...

Hi, im currently trying to learn about VBA arrays so if you know any good learning resources i would appreciate it. With the following below, how can i store or update the values assigned to an IDNO in an array and make it available to other modules. So if: Range("B3") = 7 and Range("C3") =...

I have a range of numbers in a column that are stored as a number: StartDate 20120103090000 20120104000000 20120104000000 20120104100000 20120104140000 20120104150000 20120104153000 20120105000000 20120105000000 20120105101500 20120105130000 20120105130000 20120105130000 20120105140000...

I am working in Excel 2016 with a SUM(SUMIFS()) formula that I am trying to use with an array as part of the multiple criteria where that array is stored in another cell. Specifically, while I can get this SUM(SUMIFS()) formula to calculate correctly when that array is directly written out as...

Hi, I use sumproduct on range A1:A300 for numbers stored as text. Works perfect. But I want to extend the range to A1:A1000 since row 301-1000 contain formulas and numbers might appear. When extending the range I get value error. How do I solve this?

[/IMG]Hi Is this possible... I have a group of signatures on a worksheet (images) I would like to select an image and rename it to the name stored in a combobox by pressing a command button. Is there a way of changing the selected image? activeimage? Thanks Mark

Have created a few macros, which are currently store in my personal macro workbook. I want to make the macros available for many users in my company, but I keep updating the macros. Can I export the module from my personal macro workbook and store them on our shared drive. What is the best...

Hi, I've created a helpful Hyperlink+VLookUp formula that could really benefit from a small addition. But I just can't seem to figure out a solution. Here's my formula: =HYPERLINK(VLOOKUP(A1,Tab2!$A$1:$B$52,2,1),"Name") Basically, it returns a webpage stored another sheet that matches a...

Hello! Is there a formula that will read the numbers from a column that contains numbers but stored as text? Thanks!

I have inherited a spreadsheet which contains a look-up table and now need to update the text and figures in the table but can't see where the original data is stored, is there a simple way of finding it?

I wish to link the information from a sheet in one workbook stored on sharepoint to another sheet in another workbook stored on sharepoint , I wish the whole cell contents to link including the colour and comments but using the paste special link function only the data links across. I have also...

Hi everyone hope you can help. I have a master spread sheet that is copied into different files that gets stored in say in G drive. So this master spread sheet over time can be copied and stored up to 200 times. Thus 200 copies with different names stored in 200 files under G drive. Eg master1...

I have a pivot table that has two filters. the month "2018-11"- stored in cell F6 the date "11-04-2018" - stored in cell F3 I am using the code below to sort my pivot by these values ActiveSheet.PivotTables("PivotTable2").PivotFields("Month").CurrentPage = Range("g6").Value...

Hello, I was working on a formula and when I released INDIRECT does not work when workbooks are closed. The reason I need to use indirect is because I do not have control over the source workbook and sometimes columns are added/removed. Here is a section on my formula...

Hi there, I have copied and pasted number, but Excel changed it to another number. How can I retrieve the old value? The original value is: 2:2124 I should have copied it as Text. When I pasted straight into excel (actually google sheets on my iPhone), this value was stored as 37:24:00...