Recent IT Questions

1 - 20 of 20
<<PREVIOUS 1 NEXT>>

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


1 - 20 of 20
<<PREVIOUS 1 NEXT>>