Can data in Excel 2003 be set up to automatically move from one sheet to another in a workbook?
Is it possible to create a macro, or multiple macros to upon a button push move data from one sheet to another in the same workbook in Excel 2003? We have a workbook with three sheets, instead of having to manually copy and paste information once we have completed it from sheet one to the [...]
Answer Question
| July 22, 2008 6:22 AM
Excel 2003, Excel macros, Macros, Microsoft Excel
Is it possible to create a macro, or multiple macros to upon a button push move data from one sheet to another in the same workbook in Excel 2003? We have a workbook with three sheets, instead of having to manually copy and paste information once we have completed it from sheet one to the [...]
Answer Question
| July 22, 2008 6:22 AM
Excel 2003, Excel macros, Macros, Microsoft Excel
programming
Tag# 301-22-AB02-103, I want this Tag format in this formate XXX-XX-NNXX-XXX, it means in place of Numbers i want ‘X’ and in Place of alphabet i want ‘N’, do you know how can you we do that in Excel? i wana to change numeric values in ‘X’ and alphabet in ‘N’ form, and my friend [...]
Answer Question
| July 15, 2008 6:48 AM
Excel macros, Microsoft Excel, VBA, Visual Basic for Applications
Tag# 301-22-AB02-103, I want this Tag format in this formate XXX-XX-NNXX-XXX, it means in place of Numbers i want ‘X’ and in Place of alphabet i want ‘N’, do you know how can you we do that in Excel? i wana to change numeric values in ‘X’ and alphabet in ‘N’ form, and my friend [...]
Answer Question
| July 15, 2008 6:48 AM
Excel macros, Microsoft Excel, VBA, Visual Basic for Applications
Forms in Excel 2003
I have created a form in 2003 Excel that has drop-down menu from a list file created on multiple worksheet within the document. This works fine. What I need to do is create a drop-down menu on a field that will not only bring up a list of title to choose from but also when [...]
Answer Question
| February 16, 2010 12:59 AM
DropDownList, Excel 2003, Excel macros, Microsoft Excel
I have created a form in 2003 Excel that has drop-down menu from a list file created on multiple worksheet within the document. This works fine. What I need to do is create a drop-down menu on a field that will not only bring up a list of title to choose from but also when [...]
Answer Question
| February 16, 2010 12:59 AM
DropDownList, Excel 2003, Excel macros, Microsoft Excel
Recording cell value changes to another cell in excel using a macro
Is it possible to use a macro that will record the value changes I make in one cell and make it appear in another cell on the same worksheet? Example: On a worksheet the cell value of A:1 will change every week. As the value is updated, the previous value is copied to another cell [...]
Answer Question
| July 5, 2008 7:40 PM
Excel 2003, Excel macros
Is it possible to use a macro that will record the value changes I make in one cell and make it appear in another cell on the same worksheet? Example: On a worksheet the cell value of A:1 will change every week. As the value is updated, the previous value is copied to another cell [...]
Answer Question
| July 5, 2008 7:40 PM
Excel 2003, Excel macros
Copy past in excel using VB
i want to cut data in a colunm H and copy it in column B. i tried to record macro and run it. but i am not getting the values in column B. i am using excel macro and vb code to do this. i understand that the data in colum is cut and the [...]
Answer Question
| July 2, 2008 10:26 AM
Excel macros, Microsoft Excel, VB, VBA, Visual Basic for Applications
i want to cut data in a colunm H and copy it in column B. i tried to record macro and run it. but i am not getting the values in column B. i am using excel macro and vb code to do this. i understand that the data in colum is cut and the [...]
Answer Question
| July 2, 2008 10:26 AM
Excel macros, Microsoft Excel, VB, VBA, Visual Basic for Applications
Changing Color in a Cell
I am updating a spreadsheet each month which is automated. I have written a macro to update this spread. Each month I append four columns to the end of the spread sheet and update the data in the spreadsheet. The problem that I am having is trying to figure out how to update the heading [...]
Answer Question
| June 19, 2008 12:06 PM
Conditional formatting, Excel 2003, Excel macros, Microsoft Excel, VBA, Visual Basic for Applications
I am updating a spreadsheet each month which is automated. I have written a macro to update this spread. Each month I append four columns to the end of the spread sheet and update the data in the spreadsheet. The problem that I am having is trying to figure out how to update the heading [...]
Answer Question
| June 19, 2008 12:06 PM
Conditional formatting, Excel 2003, Excel macros, Microsoft Excel, VBA, Visual Basic for Applications
Executing a Stored procedure using Excel Macro
I am an amateur in SQL programming. Could you please tell me how to execute a Stored procedure using Excel Macro (VBA Programming) and then save the record set into different Excel sheets?
Answer Question
| June 13, 2008 6:36 PM
Excel macros, SQL, Stored Procedures, VBA
I am an amateur in SQL programming. Could you please tell me how to execute a Stored procedure using Excel Macro (VBA Programming) and then save the record set into different Excel sheets?
Answer Question
| June 13, 2008 6:36 PM
Excel macros, SQL, Stored Procedures, VBA
Editing exhisting macro
I have an exhisting macro but now I want to delete column’s E and H in one of the sheets and am unsure how to edit the macro to correspond to this change.
Answer Question
| June 9, 2008 7:08 PM
Excel macros, Macros, Microsoft Excel
I have an exhisting macro but now I want to delete column’s E and H in one of the sheets and am unsure how to edit the macro to correspond to this change.
Answer Question
| June 9, 2008 7:08 PM
Excel macros, Macros, Microsoft Excel
Writing excel RTD to a file
I have an excel spreadsheet set up using the RTD function to update a row of values every 2 seconds. How can I get excel to append a csv or xls file with the RTD values every time they change? Alternately, can some code make the RTD row be copied and pasted to a new [...]
Answer Question
| June 3, 2008 6:18 AM
Excel functions, Excel macros, Microsoft Excel, RealTimeData, RTD function
I have an excel spreadsheet set up using the RTD function to update a row of values every 2 seconds. How can I get excel to append a csv or xls file with the RTD values every time they change? Alternately, can some code make the RTD row be copied and pasted to a new [...]
Answer Question
| June 3, 2008 6:18 AM
Excel functions, Excel macros, Microsoft Excel, RealTimeData, RTD function
Cell Colors in Excel
I would like to have some code that will update the color of a cell based upon values in other cells. Even when the cells are on different worksheets within the same workbook.
Answer Question
| May 30, 2008 2:18 PM
Conditional formatting, Excel macros, Microsoft Excel
I would like to have some code that will update the color of a cell based upon values in other cells. Even when the cells are on different worksheets within the same workbook.
Answer Question
| May 30, 2008 2:18 PM
Conditional formatting, Excel macros, Microsoft Excel
Excel 2007 Macros problem
AOA, I am using office 2007 the Macros are disabled when we open password Protected Workbook.
Answer Question
| May 21, 2008 1:09 PM
Excel 2007, Excel macros, Microsoft Excel
AOA, I am using office 2007 the Macros are disabled when we open password Protected Workbook.
Answer Question
| May 21, 2008 1:09 PM
Excel 2007, Excel macros, Microsoft Excel
Overwrite previous record with VBA code
I am doing a training exercise. All works OK as per the notes with a new record being added when the OK button is clicked. Now I want a script that overwrites the previous record and not to add a new record / row on pressing OK. Pls help with code
Answer Question
| May 21, 2008 1:28 PM
Excel macros, Microsoft Excel, VBA, Visual Basic for Applications
I am doing a training exercise. All works OK as per the notes with a new record being added when the OK button is clicked. Now I want a script that overwrites the previous record and not to add a new record / row on pressing OK. Pls help with code
Answer Question
| May 21, 2008 1:28 PM
Excel macros, Microsoft Excel, VBA, Visual Basic for Applications
Search for duplicates in a collumn and delete the row on which it occurs
Hi, I have a spreadsheet with list of identifiers in collumn 1, this is auto generated and due to the source info some of them duplicated, what I want to do is find the duplicates and remove the entire row they appear on. I know this is possible using clipboard and filters but I would [...]
Answer Question
| May 12, 2008 1:47 PM
Excel formulas, Excel functions, Excel macros, Microsoft Excel
Hi, I have a spreadsheet with list of identifiers in collumn 1, this is auto generated and due to the source info some of them duplicated, what I want to do is find the duplicates and remove the entire row they appear on. I know this is possible using clipboard and filters but I would [...]
Answer Question
| May 12, 2008 1:47 PM
Excel formulas, Excel functions, Excel macros, Microsoft Excel
Printing the contents property of an EXCEL file
I have an Excel spreadsheet that has 92 macros and many queries with a Data Connection to Access. I can view the contents of the Excel file in a narrow window. Does anyone know how to print the contents so I can read the full contents?
Answer Question
| June 8, 2012 6:21 PM
Excel macros, Microsoft Access, Microsoft Excel
I have an Excel spreadsheet that has 92 macros and many queries with a Data Connection to Access. I can view the contents of the Excel file in a narrow window. Does anyone know how to print the contents so I can read the full contents?
Answer Question
| June 8, 2012 6:21 PM
Excel macros, Microsoft Access, Microsoft Excel
Retreiving data from within square brackets, there may be more than one in each cell (spreadsheet owner refuses to change it grrrr)
I have a spreadsheet with a column containing data in the following format Column G Row 1 [1T40131A] [GB50131A] [GB50131B] [GB50131C] [1T50131D] Row 2 [1T400133] Row 3 [303640]*VF Row 4 [240700]*RN I would like to create a UDF that will retrieve the data within the brackets and create a column on another worksheet with them [...]
Answer Question
| May 6, 2008 8:51 AM
Excel formulas, Excel functions, Excel macros, Microsoft Excel
I have a spreadsheet with a column containing data in the following format Column G Row 1 [1T40131A] [GB50131A] [GB50131B] [GB50131C] [1T50131D] Row 2 [1T400133] Row 3 [303640]*VF Row 4 [240700]*RN I would like to create a UDF that will retrieve the data within the brackets and create a column on another worksheet with them [...]
Answer Question
| May 6, 2008 8:51 AM
Excel formulas, Excel functions, Excel macros, Microsoft Excel
How to save a document as current date ?
I’m using VBA in excel 2000 to create a macro that saves out a spreadsheet with today’s current date. I cannot figure out the code that will achieve this function. Help Please
Answer Question
| April 22, 2008 7:15 PM
Excel 2000, Excel macros, Microsoft Excel, VBA, Visual Basic for Applications
I’m using VBA in excel 2000 to create a macro that saves out a spreadsheet with today’s current date. I cannot figure out the code that will achieve this function. Help Please
Answer Question
| April 22, 2008 7:15 PM
Excel 2000, Excel macros, Microsoft Excel, VBA, Visual Basic for Applications
Excel-Macro Help
I’m creating a spreadsheet for a business (for my uni work) and i need to create a booking form and from that be able to save the customers information. I’ve created the booking form, and created a button to save the customer information, using a macro for it to save. The problem is when the [...]
Answer Question
| April 7, 2008 3:02 PM
Excel macros, Microsoft Excel, VBA
I’m creating a spreadsheet for a business (for my uni work) and i need to create a booking form and from that be able to save the customers information. I’ve created the booking form, and created a button to save the customer information, using a macro for it to save. The problem is when the [...]
Answer Question
| April 7, 2008 3:02 PM
Excel macros, Microsoft Excel, VBA
easy way to automate uploading data from a word document to a spreadsheet?
I have a spreadsheet to verify datafields for. This needs to test for example state all the valid entries. I do not want to save off a spreadsheet form of the template i am testing one for each data value I need to test. Is there an easy way to create many spreadsheets off of [...]
Answer Question
| June 2, 2008 3:01 PM
Excel macros, Microsoft Excel, Microsoft Word, VBA, Visual Basic for Applications
I have a spreadsheet to verify datafields for. This needs to test for example state all the valid entries. I do not want to save off a spreadsheet form of the template i am testing one for each data value I need to test. Is there an easy way to create many spreadsheets off of [...]
Answer Question
| June 2, 2008 3:01 PM
Excel macros, Microsoft Excel, Microsoft Word, VBA, Visual Basic for Applications
Switching custom views in Excel when filtering
I have a very large spreadsheet that I navigate using custom views. I change views using macros because I have a couple of other commands that I want executed as well. I also commonly filter the rows of the spreadsheet. However, when I switch views, the filter is turned off, and I would like it [...]
Answer Question
| March 29, 2008 3:13 PM
Excel 2003, Excel macros, Microsoft Excel, VBA
I have a very large spreadsheet that I navigate using custom views. I change views using macros because I have a couple of other commands that I want executed as well. I also commonly filter the rows of the spreadsheet. However, when I switch views, the filter is turned off, and I would like it [...]
Answer Question
| March 29, 2008 3:13 PM
Excel 2003, Excel macros, Microsoft Excel, VBA
