Search results

Good Day Experts, Is it possible to use the text in a cell to refer to a Defined Name? Something like this: A1 = bwt B1 = 100 C1 = "bwt" * B1 Using Name Definition: "bwt" = 10 Is it possible to write: C1 = (some formula) A1 * B1? The formula would extract the value in A1 ("bwt") and look up its...

شكرا دبراج However, I'd like to simulate the funtionality of a PV without actually using one. Is there to a way to do that? It seems to me that a PV is the comfotable front-end to some complicated back-end formulas and operations. I wish to perform these operations manually without the PV...

Another related question: How could it done in VBA? How can I loop thru the data? I mean, how can I detect the change in the Month columns from for example Jan to Feb? And in Product column from A to B? All I can think of, would be comparing the value in a cell to the previous cell and if...

Thanks folks! This is what I was I looking for.

A very happy new Year to you all ( in case this IS your New Year!). I'd appreciate your help with the following problem: I've got a table similar to the attached file. I need to add the product sales for each product AND month. I can use Subtotal to add up sales for each month; but how do I...

Bull's Eye Narayan! Many many thanks. This is exactly the reason the links are still there. I removed them and thus got rid of the them annoying links. Much obliged. Saeed

Luke, here's the file. I deleted all the contents, but these 3 links remain. I tried changing the source, in one case it worked (link1.xls). It didn't however work with the other 2. I also called Data Validation and pressed Clear All button, just in case. As you can see, it didn't work either...

Hi Sajan, Thanks for the tip. How do I check this though? There are some 50 sheets in the workbook. How can I systematically sift thru them and look for Data Validations in all the cells of a sheet? I have "inherited" the file, so I don't know what might existed previously. Do you know of VBA...

Hi Luke, These are confidential documents, so I unfortunately cannot post it as is. I will however, delete the contents and then upload it, if the errors are still there!

Good Day, After getting great replies on my last question, I’m back again with a new one about the Connections. There are 3 Connections in many of our files, Excel 2003, which are not linked to any external files but can NOT be deleted over the menu (Edit -> Connections -> Delete Source")...

Come to think of it Sam, you are right! I can save the macro to the personal macro workbook file and run it on all my files. One last question though: for documentation purposes, is it possible to know where the links are? I mean which sheet has them? Our files could have as many as 60 sheets...

Hi Sam, It works, but it took me a while to figure out what the code does! I was just wondering, is it possible to save the subroutine as VB executable file? Similar to C or Java programs? Is there such a thing as VB executable? I could then invoke the file and let it run.

Much obliged Sam, it works! May I then ask for the next step(s)? There are quite a few connections in each file, each file with plenty of sheets. And there are few hundred files. The optimum solution would be to determine ALL connections in each Workbook automatically, ask the user for the new...

Good Day Dear Experts, I need your help with the following situation: We generate monthly reports for various departments. There are hundreds of interconnected Excel files in many different folders. Each month the files are updated and renamed to reflect the month (e.g. basic_report_08.xls for...

Thank you guys for your reply. Luke, By "semi-transparent rectangle" do yo mean a text field which could be placed on top of the graph object? Montrey, Do you mean not using the data table facility of the chart but rather placing the chart as an object in a sheet and then formatting the...

I have created a chart with 5 rows and multiple columns. On the dialog window “Chart Options” under the tab “Data Table”, I ticked the box “Show data table” to display these rows and columns. So far so good. Now, the boss wants to highlight just ONE of these rows. “Format Data table” formats...

Hello Hui, Sorry for taking a while to get back. This is excatly what I was looking for! Many Thanks. Saeed

Good Day, Is it possible to save VBA macros as independent, external files? There are many operations common to many files, many of them non-recurring; for instance performing certain formatting. For various reasons, file size etc, I wish to keep these macros outside of any particular Excel...