Search results for query: *

I look and all formulas from excel are from seconds to hrs and mins. Is there any excel formula for HH:MM to Secs. ex. 1:00 = 360 seconds Thanks,

I have 3 sheets with 4 columns that is the same, but the data on 3 other column might or might not be the same. i need to combine all 3 sheets into 1 sheet. here is the data! sheet 1 sheet 2 id# | name | month | amt id# | name | month | amt 123 | jay |200601 | 2 111 |...

I'm trying to sum up the amounts only if the id# is the same. how can I do that? here is the data. col1 col2 col3 id# Amt1 | Amt2 1 1 | 1 1 2 | 1 1 1 | 2 2 2 | 1 3 -2 | -1 <- negative amt 1 -1 | -1 <- negative amt 2 2 | 2...

hello: I have a text file will continuous line without any line breaks with a box as a exclamation as a divider, ie. abcde!abced!abcde. Could I write a batch file that will open the text file and then loop thru the line and if there is an exclamation put a line break there? Any help will be...

I have a unix file and want to write a batch file that will convert the unix file to a windows file format, so I can open it in windows. Any help will be great.

Hi: I have 2 tables, A and B table A have 3 columns A1, B1, C1 table B have 3 columns C1, D1, E1 select A.A1, A.B1, set B.C1 = A.C1, A.D1, A.E1. from A, B where A.A1 = C.D1. how could I set the third column to table B instead of records from table A. I'm trying to get all the records from...

I have a worksheet, but I want only parts of the worksheet be able to add or delete rows. If I select the cell(1,1) the user can use macro to insert line. If I select (5,1) the user can not use macro to insert line . Example: A B C D E 1 2 3 4...

I have a worksheet, but I want only parts of the worksheet be able to add or delete rows. for example: A B C D E 1 2 3 4 protected from adding or deleting this row 5 protected from adding or deleting this row 6 protected from adding or deleting...

i have a saveas macro and when the user click the macro to run it, it will save a new file with the name provided and put in the same location, but file always save under my documents in my computer. ActiveWorkbook.SaveAs FileName:= _ finalname & &quot;.xls&quot;, FileFormat:=xlNormal...

When I have a sum function in my cell example b. is the sum of a + c i.e =sum(a1+c1) it suppose to calculate the total. once I enter a value in a, b should be calculated, but why is it not updating in column b. why! why? why?

I have a workbook with 3 macros A B C. I created a customized toolbar for my macros and assign a macro name with the macros in only this workbook. I save it. It runs, but If I create a duplicate workbook, just in case I trashed the workbook. I try to run the macros in the original one, it...

I have a spreadsheet A. A is expandable, therfore, there is no specific # of rows, but have 5 columns. A B C D E 1 A E I O U 2 E I O U A 3 J U S T A 4 T H A T S 5 P E T E E 6 Y O U C A 7 N H E L P But the row is not static, how can you search the spreadsheet to find S, which is in cell E4...

Let said I have sheetA and sheetB. sheetA have columns 1,2,3 sheetB have columns 1,2,3,4 I want to check if sheetA column 1,2 is the same as in SheetB column 1,2. If the same put the content from sheetA column3 to sheetB column4. how would you check that. I have a if function to test, but is...

can anyone help! I have a workbook with 3 worksheets, and 3 columns ie. A B & C on each worksheet. A is the current sum, B is the previous sum, and C is the newest sum. I want to use a macro to save the workbook and create a new one with all the 3 worksheet and 3 columns. A is the current sum...

I have a protected sheet. I written macros to add and delete rows. if a user accidentally deleted a row using the macro, how would you undo what he did. ie. Sub Delete() ActiveSheet.Unprotect password:=&quot;test&quot; ActiveCell.EntireRow.Delete ActiveSheet.Protect password:=&quot;test&quot...

I'm trying to adjust the row and column with a macro, but let the user move the desire height and width. Because the sheet is lock, they can't use the mouse to do it, is there another way to do it. ie. Columns(&quot;D:D&quot;).ColumnWidth = 9.71 rows(&quot;27:27&quot;).RowHeight = 36.75...