This is a file I came up with to help me in constructing a dead flat assembly table. A dead flat assembly table can improve the quality of a woodworking project by providing a surface that is completely flat. This is a torsion box construction based on a design by David J. Marks (an American woodworker/artist).
Enjoy.
Jim
Re: Update Cell From Another Sheet If Condition Met
Danny99,
QuoteBlue text is manual input. Aim is to just be able to change the manual input of the x,y,z values and then the same xyz values with the same CODE and only if has a non-fixed product next to it will update.
Seriously, you can't be thinking that this sentence makes sense, are you? I even went back to your original post thinking I missed something. The original post bears no resemblance to this latest post.
Can't you just tell us what you want without using long run-on sentences that are confusing. I really want to help but I can't!!!!
Jim
Re: Update Cell From Another Sheet If Condition Met
Danny99,
I think the reason you're not getting an answer is that the question is not clear. Try explaining your question more clearly and someone will answer it. It's not a difficult question given the talent on this site.
Jim
Re: Chart In A Macro
Rachit,
I'm sorry. I can't create a chart without data either.
Jim
Re: Chart In A Macro
Rachit,
I seriously recommend that you RECORD a macro of you creating the chart first. Then, after you review the code, post any questions regarding improvements, etc. because, how do you know that won't work if you don't try it first?
Jim
Re: Outputing A Text File
Sorry KYUNW00. I can't understand what you want. Your last post was not a chart. Don't be afraid to type many words to help the understanding. Short = confusing. Long = less confusing.
Jim
Re: Outputing A Text File
Post a sample chart so we can have a look at it. It doesn't have to include all the data, just a little bit.
Re: Outputing A Text File
Can you be more specific about what you want. You seem to have something you want that is not stated in your post. Do you want a macro in an Excel spreadsheet? Do you want a formula?
Jim
Re: Outputing A Text File
KYUNW00,
What is difficult?
Jim
Re: Matching An Approximate Number
Lil,
A plain VLOOKUP formula will return the number next to the percentage that is the next lowest in the lookup table.
Assuming the percentage you want to look up is in K1, the lookup table is in $K$7:$L$17, and the number you want returned is in column L of the lookup table and the following table values:
0 % 5
10 % 6
20 % 7
30 % 8
40 % 9
50 % 10
60 % 11
70 % 12
80 % 13
90 % 14
100 % 15
=VLOOKUP(K1,$K$7:$L$17,2)
will return 10% for all values in K1 < 20% >= 10%.
Jim
Re: Combine Multiple Worksheets In One Workbook
AndyD,
If you check the other posts that have to do with combining worksheets just above your post ("Possible Answers"), you can find some code to possible modify to do what you need.
I've found in situations like this that if the worksheets are layed out in a predictable format, there may not be any need for a macro. For example if all the worksheets have data only within the range A1:H100, you can just use a "Master" worksheet in the same workbook with formulas that refer to each worksheet and end up with a pretty nice summary of all the details or such. Another technique that I've found useful is the camera tool (add the icon to your toolbar from the customize dialogue box under tools). Just take a picture of the cells on the detail sheets you want to use in your summary sheet and paste them onto the summary sheet. The cells will be linked to the source data and automatically update. This is more useful when you don't necessarily want the whole sheet in the summary sheet.
Hope that helps,
Jim
Re: Code A1 To Blink When Calculation Is Manual
BorneoHornbill,
There is a way to start VBA code whenever certain events occur. Unfortunately, there is not an event called "On Change of Calculation" or such.
However, if you want to, you could use the "Before Save" event to start code that would, for example, always turn calculation back to automatic.
Hope that helps,
Jim
Re: Updating Cell Value
Danny99,
Yes. We'll need to see a sample to help you do it though.
Jim
Re: Pivot Table
Hi Dsuperc,
Welcome to the forum. The people who will answer your questions are mostly volunteers so we don't necessarily know what you downloaded or what code you're talking about. So, could you post the code or ask a more specific question?
On the off chance you're asking how to change a Pivot Table, try right clicking the Pivot Table and choose the Pivot Table Wizard. This should take you to a dialog box that can help you experiment with the Pivot Table. Don't be afraid to make changes because you can always use the undo button if you don't like the result.
Jim
Re: Minimum Temperature Between Two Dates
bradles,
Is it possible that there is a blank cell or labels in the range you're checking for the date? That would be a date of "0" and skew any minimum.
Jim
Re: Retaining Data From Worksheet Being Refreshed
How did the stuff in B-E get populated in the Before scenario in the first place? If someone just types it in, could you store the Before entries and just add the NEW After entries so someone can type stuff in for them?
Jim
Re: Retaining Data From Worksheet Being Refreshed
pukks,
With Excel and Ozgrid, there is almost certainly a way. First, we need to know what the relationship of B, C, D, and E is to the data in column A. For example, does B-E change? When, how, why? Can a list of the things in B-E be made and used as a lookup table for the things in column A? Sometimes the best thing is to post an example of the data before and after the changes.
Jim
Re: Change Pivot Table Source File
OK. After some experiments with file names and data, I can tell you what works for me. I can create a Pivot Table with data in another Excel file. I can rename the data file and try to refresh the Pivot Table and of course, Excel doesn't find the data, much as you describe. I can then rename the file back to the original file name, and refresh and Excel has no problem finding the data again.
That tells me that if you're having problems, it must be because you don't have all the same information in the data files. Either the sheet name or the file name or the data range is different.
Hope that helps,
Jim
Re: Change Pivot Table Source File
DWildman,
When you start the Pivot Table Wizard you can't change the data range?
Jim
