Trying to copy a value created within a subroutine to another cell in the same worksheet
I have a string of cells that are populated by my macro. what i need to do is: each time the value populates, i need to copy just the value to another cell so i can record the results of the macro for a long string of numbers. heres what i have, this is not [...]
Answer Question
| October 14, 2008 3:51 PM
Excel macros, Microsoft Excel, VBA
I have a string of cells that are populated by my macro. what i need to do is: each time the value populates, i need to copy just the value to another cell so i can record the results of the macro for a long string of numbers. heres what i have, this is not [...]
Answer Question
| October 14, 2008 3:51 PM
Excel macros, Microsoft Excel, VBA
Switching Excel Custom Views Based on Selection
I have two saved Custom Views for a protected worksheet that I use as an input and summer page for an estimating spreadsheet. I want to include a validated cell on the front page which would select one of these two custom views based on which answer the user selects. Unfortunately I am very limited [...]
Answer Question
| October 14, 2008 2:09 AM
Excel 2003, Excel Custom Views, Microsoft Excel, VBA, Visual Basic for Applications
I have two saved Custom Views for a protected worksheet that I use as an input and summer page for an estimating spreadsheet. I want to include a validated cell on the front page which would select one of these two custom views based on which answer the user selects. Unfortunately I am very limited [...]
Answer Question
| October 14, 2008 2:09 AM
Excel 2003, Excel Custom Views, Microsoft Excel, VBA, Visual Basic for Applications
Office 2007
I have been having problems opening Excel documents. I have to use Internet Explorer to open these files. I have uninstalled office 2007 and re-installed it but it still hasnt made any difference. Any headway on this would really be helpful. Cheers.
Answer Question
| October 14, 2008 4:09 PM
Excel 2007, Microsoft Excel, Office 2007
I have been having problems opening Excel documents. I have to use Internet Explorer to open these files. I have uninstalled office 2007 and re-installed it but it still hasnt made any difference. Any headway on this would really be helpful. Cheers.
Answer Question
| October 14, 2008 4:09 PM
Excel 2007, Microsoft Excel, Office 2007
Data Label Help
Hi I have made a stacked column graph comparing three types of presenters by percentage. I am trying to make a data label appear at the top of each three stacked bars that shows the total percentage for all three. I know I can do this by way of a text box but I would [...]
Answer Question
| October 13, 2008 11:30 PM
Excel 2007, Excel Charts, Microsoft Excel
Hi I have made a stacked column graph comparing three types of presenters by percentage. I am trying to make a data label appear at the top of each three stacked bars that shows the total percentage for all three. I know I can do this by way of a text box but I would [...]
Answer Question
| October 13, 2008 11:30 PM
Excel 2007, Excel Charts, Microsoft Excel
Excel Macro to parse list of excel files and move them depending on a single cells value
Does anyone know how to creat an Excel macro that I can run on a directory of excel files that will look for a value of cell B47 and if it’s > 600 move it to another directory and if it’s < 600 move it to another one?
Answer Question
| November 16, 2008 8:26 PM
Excel macros, Microsoft Excel
Does anyone know how to creat an Excel macro that I can run on a directory of excel files that will look for a value of cell B47 and if it’s > 600 move it to another directory and if it’s < 600 move it to another one?
Answer Question
| November 16, 2008 8:26 PM
Excel macros, Microsoft Excel
excel formula
i am working on a worksheet and need totals from a prior worksheet, for one cell i use =sheet2!A3, when i try to get the total from A3 and A4 i do not get the total, i have tried =sheet2!A3+A4, but that does not work, please help
Answer Question
| October 14, 2008 6:36 PM
Excel 2003, Microsoft Excel
i am working on a worksheet and need totals from a prior worksheet, for one cell i use =sheet2!A3, when i try to get the total from A3 and A4 i do not get the total, i have tried =sheet2!A3+A4, but that does not work, please help
Answer Question
| October 14, 2008 6:36 PM
Excel 2003, Microsoft Excel
how to get the check boxes data in to excel sheet
i am using lotus notes. in which i write an agent to export the excel and in that i have a option of one column in which i have check boxes and out of that any number of check boxes can be checked. but all the checked items have to in to the one cell [...]
Answer Question
| October 10, 2008 4:51 PM
Lotus Notes, Microsoft Excel
i am using lotus notes. in which i write an agent to export the excel and in that i have a option of one column in which i have check boxes and out of that any number of check boxes can be checked. but all the checked items have to in to the one cell [...]
Answer Question
| October 10, 2008 4:51 PM
Lotus Notes, Microsoft Excel
Excel cell contents change when performing Word mail merge.
I routinely use Word Mail Merge Wizard to produce mailing labels, extracting the address data from an Excel spreadsheet. When performing this operation today, the zip codes of the last five additions to the spreadsheet, while appearing completely normal in the spreadsheet, change to 0 (zero) in the mail merge. I’ve tried reentering these address [...]
Answer Question
| October 8, 2008 8:09 PM
Mail merge, Microsoft Excel, Microsoft Word
I routinely use Word Mail Merge Wizard to produce mailing labels, extracting the address data from an Excel spreadsheet. When performing this operation today, the zip codes of the last five additions to the spreadsheet, while appearing completely normal in the spreadsheet, change to 0 (zero) in the mail merge. I’ve tried reentering these address [...]
Answer Question
| October 8, 2008 8:09 PM
Mail merge, Microsoft Excel, Microsoft Word
Lonking worksheets in Excel.
I am trying to link an Excel sheet from one workbook to another and it is working, but it does not look the same. I want the linked sheet to look exactly like the original sheet, but it doesnt work. I think it may be because the original sheet was manually inputted and i created [...]
Answer Question
| October 8, 2008 6:47 PM
Linking workbooks, Microsoft Excel
I am trying to link an Excel sheet from one workbook to another and it is working, but it does not look the same. I want the linked sheet to look exactly like the original sheet, but it doesnt work. I think it may be because the original sheet was manually inputted and i created [...]
Answer Question
| October 8, 2008 6:47 PM
Linking workbooks, Microsoft Excel
Excel graph gaps
I would like to create an “x,y” type plot (“scatter graph” in Excel terms) in which the “x” array is continuous, but some of the “y” values are invalid because the formula has a limited valid range. I can use an IF to substitute “” or “nil” “invalid” or something for the invalid “y” values. [...]
Answer Question
| October 8, 2008 6:15 AM
Excel Charts, Microsoft Excel
I would like to create an “x,y” type plot (“scatter graph” in Excel terms) in which the “x” array is continuous, but some of the “y” values are invalid because the formula has a limited valid range. I can use an IF to substitute “” or “nil” “invalid” or something for the invalid “y” values. [...]
Answer Question
| October 8, 2008 6:15 AM
Excel Charts, Microsoft Excel
coordinate file import
can I import cartesian coords into acad from wordpad or exel
Answer Question
| October 7, 2008 8:54 PM
Data management and storage, Microsoft Excel, WordPad
can I import cartesian coords into acad from wordpad or exel
Answer Question
| October 7, 2008 8:54 PM
Data management and storage, Microsoft Excel, WordPad
Excel Macro to Create additional Sheets, based upon cell values
I have a spreadsheet that contains a report of which department has an item entered. what I want to accomplish is to move the individual ‘department’ data to thier own sheets. I have one case where I will have 4 different departments combind on one sheet, the remaining will occupy thier own sheets. How can [...]
Answer Question
| October 7, 2008 2:49 AM
Excel macros, Microsoft Excel
I have a spreadsheet that contains a report of which department has an item entered. what I want to accomplish is to move the individual ‘department’ data to thier own sheets. I have one case where I will have 4 different departments combind on one sheet, the remaining will occupy thier own sheets. How can [...]
Answer Question
| October 7, 2008 2:49 AM
Excel macros, Microsoft Excel
MAXIF formula
Excel has SUMIF and COUNTIF functions, but I don’t find a comparable MAXIF funciton. Can such a function be added into Excel? Any suggestions for sources?
Answer Question
| October 7, 2008 7:39 AM
Excel functions, Microsoft Excel
Excel has SUMIF and COUNTIF functions, but I don’t find a comparable MAXIF funciton. Can such a function be added into Excel? Any suggestions for sources?
Answer Question
| October 7, 2008 7:39 AM
Excel functions, Microsoft Excel
Trying to run remote command to view AS/400 UNC and failing!
I need some ideas here…I’m stuck. I’m running an RPG program that builds some CSV files for our accounting department. Because they love Excel, I had to make it so that the program breaks the data up into separate CSV files so as not to exceed 65,535 rows. Anyway, I am saving the stream files [...]
Answer Question
| August 15, 2010 7:54 PM
CSV, Microsoft Excel, RPG, UNC, UNC path
I need some ideas here…I’m stuck. I’m running an RPG program that builds some CSV files for our accounting department. Because they love Excel, I had to make it so that the program breaks the data up into separate CSV files so as not to exceed 65,535 rows. Anyway, I am saving the stream files [...]
Answer Question
| August 15, 2010 7:54 PM
CSV, Microsoft Excel, RPG, UNC, UNC path
Having problem opening Excel files on Zip drive results
A reader asks: Hi There. My question relates to opening a file in Excel 2007. Briefly, files were created on another computer using Excel 2007, put on zip drive which I have been able to open print, update, etc. previously. Now it allows me to open the files, however, no data appears on screen once [...]
Answer Question
| October 3, 2008 4:46 PM
Excel 2007, Microsoft Excel, Zip drives
A reader asks: Hi There. My question relates to opening a file in Excel 2007. Briefly, files were created on another computer using Excel 2007, put on zip drive which I have been able to open print, update, etc. previously. Now it allows me to open the files, however, no data appears on screen once [...]
Answer Question
| October 3, 2008 4:46 PM
Excel 2007, Microsoft Excel, Zip drives
Help finding duplicate info in Excel in different columns
Hi, I have an excel spreadsheet that looks like below: Origin Store1 Store2 Percent Source Warren 12345 45678 2.45 b Warren 45678 12345 2.45 r I want to be able to recognize and delete one of these rows as a duplicate. The info is the same just in a different column whether it be Store1 [...]
Answer Question
| October 8, 2008 12:26 AM
Duplicate records, Excel functions, Excel macros, Functions, Microsoft Excel
Hi, I have an excel spreadsheet that looks like below: Origin Store1 Store2 Percent Source Warren 12345 45678 2.45 b Warren 45678 12345 2.45 r I want to be able to recognize and delete one of these rows as a duplicate. The info is the same just in a different column whether it be Store1 [...]
Answer Question
| October 8, 2008 12:26 AM
Duplicate records, Excel functions, Excel macros, Functions, Microsoft Excel
Cannot Open Older Excel Files with 2003
When trying to open older Excel files, i get this message: You are attempting to open a form that is blocked by your registry policy setting. How do I can my registery settings to access older Excel files???
Answer Question
| October 3, 2008 10:07 PM
Excel 2003, Microsoft Excel, Registry settings
When trying to open older Excel files, i get this message: You are attempting to open a form that is blocked by your registry policy setting. How do I can my registery settings to access older Excel files???
Answer Question
| October 3, 2008 10:07 PM
Excel 2003, Microsoft Excel, Registry settings
Place Holder
I have part numbers that are in the form of 12345678-001. I am trying to write a macro that will search through the 13000 lines of part numbers and enter a revision level next to it. I want it to only look at the first 8 numbers (before the “-”). This is what I currently [...]
Answer Question
| October 1, 2008 7:21 PM
Excel macros, Microsoft Excel
I have part numbers that are in the form of 12345678-001. I am trying to write a macro that will search through the 13000 lines of part numbers and enter a revision level next to it. I want it to only look at the first 8 numbers (before the “-”). This is what I currently [...]
Answer Question
| October 1, 2008 7:21 PM
Excel macros, Microsoft Excel
How to link a macro by clicking on a cell of an Excel sheet
I need to get the current time by clicking on the cell in excel.
Answer Question
| February 23, 2009 11:05 AM
Excel 2003, Excel macros, Microsoft Excel
I need to get the current time by clicking on the cell in excel.
Answer Question
| February 23, 2009 11:05 AM
Excel 2003, Excel macros, Microsoft Excel
Updating a shared list
I have 30 people in my group. I need a way that they can each document a problem with a particualr system we all use. I’ve been doing this with an excel file – everybody just opens the file and enters a new row of data when they find a new issue. Now, we need [...]
Answer Question
| October 27, 2008 8:20 PM
Microsoft Excel, SharePoint
I have 30 people in my group. I need a way that they can each document a problem with a particualr system we all use. I’ve been doing this with an excel file – everybody just opens the file and enters a new row of data when they find a new issue. Now, we need [...]
Answer Question
| October 27, 2008 8:20 PM
Microsoft Excel, SharePoint
