how to increase no of rows of validation list (drop down list)???
hello,thanks for viewing this thread.i have one excel sheet. i have entered following data in 30 rows in one column and created the validation list for that data10:00 AM10:01 AM10:02 AM'''''''5:00 PMi want to show drop down list box with my own no of rows to be displayed not current validation's...
View Answer
| Jul 19 2008 1:46 PM GMT
| asked by
Abhikop
DropDownList, Microsoft Excel, Excel
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 others we...
View Answer
| Jul 19 2008 6:22 AM GMT
| asked by
Kaylee
Macros, Microsoft Excel, Excel 2003
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 did already, through...
View Answer
| Jul 10 2008 6:48 AM GMT
| asked by
071785
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 a title is selected it...
View Answer
| Jul 5 2008 0:59 AM GMT
| asked by
Mccuistionm
Microsoft Excel, DropDownList, Excel macros
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 on the same...
View Answer
| Jul 2 2008 7:40 PM GMT
| asked by
Sabrosasabor
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 data is not retrived while it paste in column B.Can Any one...
View Answer
| Jun 24 2008 10:26 AM GMT
| asked by
Krishsrikanth
VB, Excel macros, Microsoft Excel
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 color for...
View Answer
| Jun 19 2008 12:06 AM GMT
| asked by
Kioh46
Conditional formatting, Excel 2003, Microsoft Excel
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?
View Answer
| Jun 13 2008 6:36 PM GMT
| asked by
SQL Server Ask the Experts
SQL, Excel macros, Stored procedures
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.
View Answer
| Jun 7 2008 7:08 PM GMT
| asked by
Cadenthais
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 row so that all of the incoming...
View Answer
| Jun 3 2008 6:18 AM GMT
| asked by
Rtd guy
RTD function, Excel macros, Excel functions
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.
View Answer
| May 30 2008 2:18 PM GMT
| asked by
TweetyBird69
Excel macros, Microsoft Excel, Conditional formatting
Excel 2007 Macros problem
AOA,I am using office 2007 the Macros are disabled when we open password Protected Workbook.
View Answer
| May 21 2008 1:09 PM GMT
| asked by
Mobilink
Excel macros, Microsoft Excel, Excel 2007
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
View Answer
| May 13 2008 1:28 PM GMT
| asked by
Battler
VBA, Excel macros, Microsoft Excel
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 rather avoid...
View Answer
| May 6 2008 1:47 PM GMT
| asked by
Harleq
Excel formulas, Excel functions, Excel macros
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
| May 5 2008 6:21 PM GMT
| asked by
SharieL
Microsoft Excel, Microsoft Access, Excel macros
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 GRow 1 [1T40131A] [GB50131A] [GB50131B] [GB50131C] [1T50131D]Row 2 [1T400133]Row 3 [303640]*VFRow 4 [240700]*RNI would like to create a UDF that will retrieve the data within the...
View Answer
| May 2 2008 8:51 AM GMT
| asked by
Harleq
Excel formulas, Excel functions, Excel macros
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
View Answer
| Apr 22 2008 7:15 PM GMT
| asked by
Data Mgt
Microsoft Excel, VBA, Excel macros
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...
View Answer
| Apr 6 2008 3:02 PM GMT
| asked by
Forresterdanielle88
Microsoft Excel, VBA, Excel macros
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 a data file I create...
View Answer
| Apr 4 2008 3:01 PM GMT
| asked by
Juls
Microsoft Word, Microsoft Excel, Excel macros
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...
View Answer
| Mar 27 2008 3:13 PM GMT
| asked by
Tsbarr
Microsoft Excel, Excel 2003, Excel macros
