Summary: Well see, the CSV is from the university database. It's the info on all the classes for the semester. Currently the university has no was to make post...
Summary: I am new to Excel macro and I need your help. I have the following input data in Sheet 1: a1 b1 (a1 in cell A1, b1 in B2) a2 b2 (a2 in cell A2, b2 i...
Summary: Yes, i have another problem... the data i use is read from a text file and since its always different i have coded the Macro to search for the start a...
Summary: Hi, I've got a horrible problem with my Excel macro. When I my macro reads a value from a cell containing e.g. 1.33, he reads 1.38! The type of variab...
Summary: Excel macro A friend has a spread sheet he receives every week. He has to copy info from that sheet and past it into a new Excel sheet in a different ...
Summary: This sounds more like a job for a scheduled Windows batch file as opposed to an Excel macro. As per your last post, it sounds like you want to make a ...
Summary: Hi all, I need help with an excel macro problem. I am creating what I thought was a simple scheduling macro. Basically I need to take batch residence ...
Summary: I'm looking for some help running an excel macro as an automated task. The macro is supposed to create a data connection, import some data from a par...
Summary: Simple but not too simple to instruct. You want to use a VLOOKUP versus a macro. Create your table of numbers adjacent to their descriptions on Sheet2...
Summary: Hi Friends, I have a shee in which all dates of February month are written one below the another. I want help on following: I am entering figure as 20...
Summary: Hi All, With MS Word my VB macros are available in all my documents, not true with Excel Workbooks. Is there a way to make my Excel VB macros availabl...
Summary: I have written an excel macro to do some formatting. Can i save the macro on the server and make it available for other users to use it. Thanks ...
Summary: We are using an Excell spreadsheet to track Estimated Arrival Times. Is there a way, possibly using Conditional Formatting, to compare the time in a ...
Summary: Hi Steve. If you open Excel without selecting a file, and your PERSONAL.XLS opens up, simply select "Window->Hide" from the menu bar, and close Excel,...
Summary: HI there, Im just wondering if it is possible for excel to remember cells from workbook to workbook. What I mean is, when I type something in a cell o...
Summary: What did you try as far as troubleshooting the code to see why it was giving you the error? If you clicked Debug in the error window it would have hi...
Summary: I have a 100 different catagories in one collumn and I want an Excel macro to generate a abbreviation for each different catagorie in another collumn ...
Summary: I'm confused, but we'll get to that later. First, about your code: As far as I can tell, your code is supposed to prevent users from editing any cell ...
Summary: Absolutely....once you run a query, update query or whatever in Access, the displayed table could be entirely selected and copied and pasted onto a re...
Summary: I need to know if there is a way to do data checking on a cell as it is entered. What I need is for the cell to automatically change itself to a nega...
Summary: Hi all, This seems like something that should be built into Excel, but isn't, and I've always wanted to tackle it... Assume I'm in Cell A1 in TAB 1....
Summary: Hi, I want to create a macro in excel which will work as follows: 1. There will be a data file in excel like this Col1 Col2 Col3 Col4 Col5 Col6...
Summary: I am wondering if their is a way to do the working excel faster than write this stuff out cell by cell. What i am doing is, i have a column with a ran...
Summary: Hello, I am very new to this and was wondering if anyone knew how to do the following: In my excel Sheet1 I have a button that when clicked I want ...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
