| Subject | Date Asked | Expert |
|
| lotus 123 | 1/16/2006 | Jerry |
Q: We are using Lotus 123 from a server installed system. We use to be able to change are colors but ...
A: I have Lotus 5, Lotus 97, and Lotus 9.5 on an XP machine. Lotus 5 does not display the dropdown box ...
|
| Linking Work Books in Lotus | 1/9/2006 | Jerry |
Q: Can you please tell me how I may link up workbooks in Lotus. In Excel this is a snap. But in Lotus ...
A: The easiest way is to open the files you want to link and arrange the windows so you can see the ...
|
| Combining columns | 1/4/2006 | Jerry |
Q: Once again thanks for your 'EXPERT' help. The macro is working perfectecly. I have a question about ...
A: I'm glad it's working for you. You can copy and paste the macro in any spreadsheet anywhere, you ...
|
| Combining columns | 1/3/2006 | Jerry |
Q: probably because I have emade a mistake somewhere. I actually got 'joinmachome' in E5, nothing else. ...
A: You probably have the labels for the macro mixed up with the macro code. It is very difficult to ...
|
| Combining columns | 1/2/2006 | Jerry |
Q: I have a problem with some tedious data entry. I have two long columns. In Column 1A, I have: DK- ...
A: Here is the macro I would use, assuming that your data is in Sheet A, there is no other data ...
|
| Lotus 1-2-3 formula problems | 12/16/2005 | Jerry |
Q: ------------------------- Hi Jerry, Unfortunately there was no Macro code enclosed in your ...
A: I'm sorry Paul, I guess that message didn't get through for some reason. I'll paste it below for ...
|
| Lotus 1-2-3 formula problems | 12/14/2005 | Jerry |
Q: Did you send the pricemac.macro or is it to follow? regards, Paul
A: I'm not able to attach files here, the intent of the last email was for you to type the macro code ...
|
| Lotus 1-2-3 formula problems | 12/13/2005 | Jerry |
Q: Jerry, Many thanks for your prompt reply. Unfortunately it didn't resolve the problem,probably I ...
A: The formula would be similar, but you still need a reference to a current low and high price. Those ...
|
| Lotus 1-2-3 formula problems | 12/12/2005 | Jerry |
Q: I'm trying in vain to enter a formula in Lotus 1-2-3 '97 edition, so I can enter a share price into ...
A: Are you keeping track of the lowest and highest prices for a given stock in separate cells ...
|
| pasting in a macro | 12/2/2005 | Jerry |
Q: I am attempting to combine names in columns to create email address. a sample of the current format ...
A: I'm going to recommend a different approach I think you will be happier with. I also recommend ...
|
| SCV Files | 11/28/2005 | Jerry |
Q: I am actually trying to list postage stamps on a web site. Just to be clear I have included their ...
A: The solution I gave you before was for Lotus. Excel formulas are different. The values should be ...
|
| SCV Files | 11/28/2005 | Jerry |
Q: I got the acronym mixed up sorry I'm not able to upgrade my lotus right now but I do have Excel 2000 ...
A: I would have the separate fields in individual columns, with no commas in the cells themselves. I ...
|
| SCV Files | 11/24/2005 | Jerry |
Q: I have Lotus 5.01 software for windows. I need to create a SCV file. I know that it can be done in ...
A: I think you mean CSV files, which stands for Comma Separated Value. These are text files with ...
|
| lotus | 11/18/2005 | Jerry |
Q: iam using lotus smartsuite 123. for some reason the /ppr~ag~q will not print the range. instead, ...
A: I have the same problem if I try to use the / commands to print the way you describe. When printing ...
|
| linking and working by extracting data | 11/10/2005 | Jerry |
Q: That was a great help jerry , it worked really well. Jerry I have three questions can you help me ...
A: There is no way to link a Lotus and Excel file together directly, the best way to get the data from ...
|
| asignn function to a button on lotus123 | 11/3/2005 | Jerry |
Q: I can help you with this, but I will need a little more information. What version of Lotus are you ...
A: Create a name for your cell that you want to use as a counter. Go to the cell and click "Range", ...
|
| asignn function to a button on lotus123 | 11/2/2005 | Jerry |
Q: I have just started with basics of lotus123, can you please guide me on how to get counter on ...
A: I can help you with this, but I will need a little more information. What version of Lotus are you ...
|
| Date formula? | 10/25/2005 | Jerry |
Q: I have a column of dates in a Lotus spreadsheet where I only want to show Wednesday, Friday and ...
A: Lotus has some very powerful date tools that you can use along with other @functions to give you ...
|
| Lotus spreadsheet problem | 10/19/2005 | Jerry |
Q: “IF” I followed your instructions correctly this is what I get. (I have changed the cell addresses ...
A: Ben, The below formula should work for you, but you have to edit the cell references appropriately. ...
|
| Lotus spreadsheet problem | 10/18/2005 | Jerry |
Q: I'll try to be more specific You gave me the following table and formula previously, which works ...
A: You should reserve a cell somewhere in your data for the amount of the drop off charge returned, ...
|
| Lotus spreadsheet problem | 10/13/2005 | Jerry |
Q: You gave me the following table and formula previously, which works great. 0 0.3 5 ...
A: I'm not sure exactly what you're trying to do, but try this: Do you want the refund amount ...
|
| Range table problem | 10/11/2005 | Jerry |
Q: You solved this problem for me and it worked great. The only problem I have now is that I can't ...
A: I appreciate it. You should be able to change the values in the table after you entered them. Did ...
|
| Lotus Spreadsheet formula | 10/11/2005 | Jerry |
Q: Sometimes my brain won't work right Jerry Let me try it this way: If an item cost $30 or less I ...
A: Create a table in 3 columns like this: 0 0.3 5 30 0.3 ...
|
| Lotus Spreadsheet formula | 10/11/2005 | Jerry |
Q: Now I have another problem related to the first. Your formula @IF(C10<20,5,C10*.15) If I have D10 ...
A: Let me break this into 2 parts, to address your 2 separate issues. As to the first question, if I ...
|
| Lotus Spreadsheet formula | 10/8/2005 | Jerry |
Q: I'm using Lotus 123 release 5.01 for windows. If I have a cell with value $20.00 or larger and I ...
A: I have a formula that will work for you. Let's say you have a list of numbers in column C, starting ...
|
| Lotus @if and @countif fomulas | 9/15/2005 | Jerry |
Q: Followup To Question -am trying to figure out how to do a sheet summary. What I am trying to do ...
A: After you have completed the instructions in my last response, find an empty area of your ...
|
| Lotus @if and @countif fomulas | 9/13/2005 | Jerry |
Q: Followup To Question - am trying to figure out how to do a sheet summary. What I am trying to ...
A: OK, I have a macro solution for you that will work. I do need to know what version of Lotus you are ...
|
| Lotus @if and @countif fomulas | 9/13/2005 | Jerry |
Q: am trying to figure out how to do a sheet summary. What I am trying to do is figure out the fomula ...
A: You said you wanted to move data into separate folders, do you mean separate tabs or sheets within ...
|
| Lotus @if and @countif fomulas | 9/9/2005 | Jerry |
Q: am trying to figure out how to do a sheet summary. What I am trying to do is figure out the ...
A: What you need is a @DCOUNT formula. The D stands for data, or database. Here's an example of how ...
|
| Lotus 123 Print range | 8/6/2005 | Jerry |
Q: I understand that I can highlight a larger given area - however when I do that and print - it will ...
A: If you want to reset your print settings click on "File", "Preview and Page Setup", and click on the ...
|
| macros/scripts | 7/22/2005 | Jerry |
Q: I hope this doesn't sound too silly, but how do I run a macro/script? I am using version 9.7 and I ...
A: I have Lotus 9.5, and I access scripts through the Lotus menu options "Edit", "Scripts and Macros". ...
|
| Lotus Classic Macro | 6/14/2005 | Jerry |
Q: I am trying to use a lengthy macro in a lotus spreadsheet. using the old 'Classic' macro language. ...
A: First, {f9} will not recalculate your spreadsheet. Use {calc} to recalculate. {f9} will literally ...
|
| 123 Font - Cell displays with rectangle | 6/8/2005 | Jerry |
Q: Jerry: The file-save part gave errors. I tried fixing it but it does not like the types. So I ...
A: Try this as a test: {file-save "X.WK4";"1-2-3 (WK4)"} That's the format that worked for me. If ...
|
| 123 Font - Cell displays with rectangle | 5/25/2005 | Jerry |
Q: (see answer under your question) Thanks Jerry. Hi: The ss looks fine in one computer. When I ...
A: Here's a way to run a macro to convert all your .123 files to .wk4. First, you'll need a list of ...
|
| @IF formula | 5/25/2005 | Jerry |
Q: I'm trying to get a formula for years to work. I'm using this for tax calculation. I have a number ...
A: If I understand you correctly, I think the following setup will work. This is my example, you can ...
|
| Lotus Installation | 5/24/2005 | Jerry |
Q: Followup To Question - Hi, I have an important worksheet that was created with lotus 1-2-3 version ...
A: I recommend you start Lotus 96 on the XP machine, select File Open from the menu, and select your ...
|
| Lotus Installation | 5/24/2005 | Jerry |
Q: I have an important worksheet that was created with lotus 1-2-3 version 96. I have lotus millenium ...
A: Unfortunately, I do not have Lotus 96, so I can't try to install it on XP. I don't know why it's ...
|
| 123 Font - Cell displays with rectangle | 5/23/2005 | Jerry |
Q: The ss looks fine in one computer. When I tried to open in other computers the cells with alphabets ...
A: I'll need a little more information before I can help you with this. What operating system and ...
|
| Lotus Installation | 5/23/2005 | Jerry |
Q: I have an important worksheet that was created with lotus 1-2-3 version 96. I have lotus millenium ...
A: I have Lotus 5, Lotus 97, and Lotus Millenium installed on my XP machine, and I did not have a ...
|
| Lotus 123 conditional Cell background color change | 5/6/2005 | Jerry |
Q: Can you tell me if an @If command can be used to to change the background color of that cell ...
A: The formula task you describe is called "conditional formatting". This is a popular feature of ...
|
