i want to provide empty row in excel after the end each different product category.  can anyone pls help me.?
406021
Since I dont know what determine the boundary of your category, so I can only offer this solution...\n1. click a Cell on the top row of 1st cat.\n2. hold down Ctrl key and click a Cell on top row of 2nd cat.\n3. hold down Ctrl key and click a Cell on top row of 3rd cat.\n4. until you think is enough, release Ctrl, click Menu, Insert, Row, Done
613256
I didn't get you well,\nExcel already can open csv files (Comma separated values) if ther were seperated with commas.\nWhy you need to convert it to columns?\nany way...\n\nsend me more info.\n\n\nXLMan
630142
Set up a loop like this:\n\nExitFlag=false\nDo\n   Range("B8") = Format(Now(), "HH:MM:SS")\n   DoEvents\nLoop Until ExitFlag=true\n\nThe point of my variable ExitFlag is that you might want to break out of this loop at some point.  You could set this variable in a macro for pushing a Cancel button - if needed.  You don't have to have it though, you could just use Do... Loop\n\n(A more efficient way is to link this to some kind of system timer event, but I don't know how to do that in Excel.)
569995
Are you trying to get rid of the blanks?\n\nOne way is just to sort the column--that will pull all the blanks to the top or bottom, where they are easy to delete.\n\nIf you need to keep the order that values are in, try this:\n\n1. Select the entire column.\n2. On the edit menu, choose "Go to..." then click "Special..."\n3. In the box that comes up, choose "Blanks" and hit OK.\n\nYou should now be back in the sheet, with all the blank cells selected.  Right click, choose "Delete...", then choose "Shift cells up" and hit OK.\n\nThis is for excel 2002, it might be a little different in other versions.
543882
#1.  You are assuming that the active worksheet is the first one in the book .. if it's not, it will bomb ... see ActiveSheet property\n\n#2.  You are assuming that the macro/VBA is running in this book, but if the user has multiple workbooks open, this may not be the case ... see ActiveWorkbook object.  Better?  Select Workbooks by name (see Tag values independent of filenames)\n\n#3.  Font, color, bold are meaningless for a programming problem.  Omit them for future clarity in asking a question.  Less meaningless stuff we have to wade through.\n\n#4.  Cells(1,1) depends on where the active cell is, the user or your macro may be jumping to a different place than you think it is.  Has someone inserted a row or column ?\n\nI've been doing VBA for 15 years and I have no clue what you mean by "The server threw an exception" ... you mean what ?\n\nClues as to how to fix ... use named ranges and offsets.  Name a range (always relative to the range).  Offset from there.  Always select the correct window, workbook and sheet by name, not index value.  Omit needless code from your recorded macros such as "Transpose=False" ...\n\nStop recording macros and trying to make them work.  Recording is good to get you started, not for real code.\n\nAll in all, it's a very nice semi-adjusted recorded macro.\n\nI'm not dissin' on ya Partner !   ;-)\n\nThere are good habbits and there are bad.  Learn the good habbits and life will be a cake-walk.\n\nAlways define a marker cell ... typically the top/right corner of your range or table or whatever.\n\nAlways reference everything from that point.\n\nLock the worksheet to prevent users from inserting/deleting rows/columns.\n\nUsed named sheets ... not index values.  All one has to do is insert a sheet and you're hosed.\n\nSuspenders and a belt ... this is Visual Basic here ... anything can happen.\n\nHere's a useful link for you ... just understand that here, you're pretty much expected to know your stuff or be very, very concise and specific in your inquiries and responses ...\n\nhttp://www.tek-tips.com\n\nI would encourage you to look through the forums and judge for yourself before you post.\n\nGood luck.  If I can help you out, my contact info is in the Bio.  There is always more than one way to do things ... collect the best, chuck the rest !   ;-)
366534
It completely depends on where you are using this formula, is it in Excel? A program? What language?\n\nWe need more info.
1005206
the same way you do it with excel...
1097486
A pivot table is a great reporting tool that sorts and sums independent of the original data layout in the spreadsheet.\n\n\nBelow is a webpage that has a great example...seems to make it easy to understand.
661261
You could use conditional formatting on the cells where you are entering your data.  But you actually don't need to do conditional formatting, it's just that you can get smoother more interesting effects if you do.  An easier way might be a simple formula.\n\nIt sounds like you are entering data that uses Case numbers, but if you have already entered a case, you don't want to do it again.  Obviously you could just search the case number column to see if it already exists and if so, then skip entering it.  But a more automated way would be easier.\n\nThe essence of what you need to do is use a formula to tell you if what you just entered already exists in the rows above. (To use your example, does case 24 exist already in the rows above A27?)\n\nYou could insert a (temporary) column to the left of what you are typing in.  In that column you would enter a formula to count the number of instances where the case number you just entered already exists above.  Usually the result would be 1, sometimes 2.\n\nLets say you are on row 27 and your case numbers are in column B, and your counting column is column A.  Lets assume your data starts on row 2 at the top of the spreadsheet.  Your formula for cell A27 would be:\n=IF(COUNTIF($B$2:B27,B27)>1, "Exists Already!", "")\n\nNotice the $ signs in the Countif formula.  The formula range will adjust as appropriately as you copy it around.  You want to get this formula on every line next to every case number so that it can alert you if it seen there is more than once instance.\n\n(Actually the Data Validation mentioned below is a better solution because it will prohibit you from entering the data.  But it's all the same principle. Just more elegant because you don't need to insert a new column.)
729280
you can sum a row or column of cells by typing =sum(a1:a5)\n\nReplacing a1 and a5 with appropriate cells.  you can also use this with difference or average in place of sum
995507
A cell can either contain data or a formula, not both.\n\nYou will need to create a macro and assign it to the onChange event for that cell.
775038
Nope, sorry.  What you're describing is a query.  Only Access can do that.  It's a pretty simple one, and exporting back and forth between Access and Excel is pretty easy.  If you want some help in how to do it, send me a message.
1121474
Well there are a few ways.... the easiest way is.........\n\nLets say you want to get rid of everything in row 5, you can move your mouse over the letter 5 at the very left and highlight that row by left clicking once, then right click your mouse and select delete. This however will only delete information you entered like letters or numbers. If you applied any borders or the like you will need to highlight the row as stated above, right click and go to "Format cells" then to the  borders tab and choose "none".\n\nThis will work for deleting entire columns also.
521317
Doing this is a little tedious but can be done. The tedious part is the first part.\n\n1- Let's assume that each sheet has a name with no spaces (i.e. sheet1, sheet2, etc) AND each of the 134 sheets has the same number of rows and columns. Copy the data area from sheet1 into a new sheet and 'paste link'. You'll have to do a find/replace and change each column letter to have a $ before it (i.e. d to $d$). Add the second $ to take care of the rows at the same time.\n\nCopy the data area in this new sheet under itself so now you have two identical sets. Do the same copy paste under operation 134 times (or until you run out of rows).\n\nOnce you have this done, you are going to have to do 133 find/replace operations and you are searching for sheet1 and replacing with the next sheet. Make sure you highlight the areas of interest. For example, on your second find/replace, highlight all the data under the first section. On your third, select all areas under the thinrd section. That way you aren't replacing the stuff you already did. example, your first set ends at row 100. Highlight row 101 to row 65,536, replace sheet1 with sheet2. Third set, also 100 rows. Highlight row 201 to 65,536 find/replace sheet2 with sheet3, etc.\n\nTedious & time consuming but if you aren't willing or don't know how to code in VBA, the easiest way to do it.
760528
1) Left click on first cell in row.\n2) Hold down the shift key and Left click the cell AFTER the last grade\n3) Sum button
763704
There are two options to handle the situation -\n\n1) Use Format > Cells > Alignment > Set Text alignment in vertical to Top & Text control to Wrap text, then readjust the row height to the normal height (instead of showing the whole contents)\n\n2) Create a column that only shows the first 5 characters of the A column - in B column enter formula =left(A1,5), then hide the whole A column now use the B column as the original A
659348
next to insert table button on the standard toolbar you have insert microsoft excel sheet button. click and drag the number of rows and columns you need.