Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. zelgar

    Does this ram stick has 1 or 2 Gbs?

    Based upon a google search, it's only 1 gb. A site selling this with the same pic is at the following site: http://www.ascendtech.us/kingston-kcm633-elc-1gb-memory-666-12-d1_i_memkn1gb66612d1.aspx
  2. zelgar

    Gather data from a row and place it into another sheet

    Since the ActiveCell.Offset(6, -15).Select is outside of the loop, why do you need it? I have a feeling that you need to modify the ActiveCell.Offset(1, -12).Select with an IF statement or using CASE command for conditions when X = 16 & 17 when you're evaluating when the Account Number is 44902...
  3. zelgar

    Gather data from a row and place it into another sheet

    There is no reason to repeat the code 3 different times. You could do it once with the following changes (in Bold and Strikeout): For x = 1 To 15 17 If x < 15 Then AccountNumber = Range("A" & ActiveCell.Row).Value Else AccountNumber = 44903 + x - 15 Additionally, the line ActiveCell.Offset(1...
  4. zelgar

    Calculating pay days

    Additionally, depending on the version of Excel, the Weekday function has several options that may can make things easier: =IF(WEEKDAY(E3,16)<3,E3-WEEKDAY(E3,16),E3) The Option of 16 for Weekday results in a 1 or 2 for the weekend, making only 1 logic statement and calculating the date easier.
  5. zelgar

    Computer not staying on

    There's a lot of things that could be causing the problem. Have you checked the following: - turn off programs are running at Start-up - check out all of your vents & fans and clean them and make certain they're working properly - possibly download a motherboard monitor and see if there are...
  6. zelgar

    HP4700DN - prints differently between users on same computer

    The first thing I would check is to see if both computers are using the same printer driver (name and version). Next, I'd see if there is anything set up differently on the printer options and in the program. Also, you might check to see if the computers are up to date for the operating system.
  7. zelgar

    How to make the data row-wise?

    I didn't have a problem with your original code except it wouldn't get the info for the last item with the code being x, but you might try the following : Sub test2() Dim col As Integer, code_row As Integer, var_row As Integer var_row = 2 code_row = 2 col = 4 Do Until IsEmpty(Cells(var_row, 1))...
  8. zelgar

    HH:MM Time format calculations.. What Gives?

    Why don't you use the YEARFRAC function: =IF(MONTH(H3)=MONTH($K$3),IF(YEAR(H3)-6>=YEAR($K$4),(INT(YEARFRAC($K$4,H3))-5)*8,0),0)/24 If the number format is in DATE format, you need the /24 at the end to get the result in HH:MM format. If you want to see the result in the general or number...
  9. zelgar

    How to Copy a range X times, and then copy/paste a variable Y times, and index?

    Here's a macro to get you started: Sub bsurfn99() Dim T1start As Integer, T1col As Integer, T1row As Integer Dim T2start As Integer, T2col As Integer, T2row As Integer Dim T3col As Integer, T3row As Integer, i As Integer, j As Integer ' Step 1 - Determining Starting Positions of Tables...
  10. zelgar

    Excel AutoFill Macro

    if you want a macro... Sub SeisaT() Dim x As Integer, y As Integer, irow As Integer irow = 2 For x = 1 To 2000 For y = 0 To 1 Cells(irow, 1) = x irow = irow + 1 Next y Next x End Sub or Sub SeisaT2() Dim x As Integer For x = 2 To 4000 Step 2 Range(Cells(x, 2)...
  11. zelgar

    Conditional Data Validation

    Instead of you way, for the 2nd Data Validation use the INDIRECT command. For example, =Indirect(C3) instead of your IF(C3...
  12. zelgar

    Finding/Preventing External Links

    I've had this happen when I have a macro assigned to a run when you click a shape (e.g., circle, rounded rectangle). When I saved the spreadsheet under a new name (e.g., Something v2) it still associates the macro with the old spreadsheet. In order to stop the link, I would have to reassign...
  13. zelgar

    Thoughts on Excel for HR Vacation Time Tracking

    Here's an accrual time sheet I made years ago for myself. The biggest problem is the coding to add additional time due to different conditions. Where I work, you start out with 12 vacation days, and get bonus days after 5, 10 and 20 years of service (bonus days +3, +8 and +13) on your accrual...
  14. zelgar

    Do until loop not working

    The problem is the code doesn't revise einde2 after the offset. Modify the macro as follows: 'Select cell A22, *first line of data*. Dim einde2 As String Range("A22").Select If Range("B4") = "802" Then ' Set Do loop to stop when an empty cell is reached. Really???? einde2 = ActiveCell.Value Do...
  15. zelgar

    need to make a small project in vb for employee income and tax calculator

    Additionally, if you could upload a version of your spreadsheet with dummy data, it might help as well.
  16. zelgar

    Using IF and AND together

    Alternately if you want it all in 1 line: =IF(ISNA(E2),IF(D2="single", -996.6, IF(D2 = "couple", -1700, IF(D2 = "family", -2800, "ERROR"))),RESULT IF DATA IN E2 ISN'T N/A)
  17. zelgar

    Creating sequential count of transactions by Client ID in Excel

    Of course to make the formula from JV work, the data needs to be sorted by client first.
  18. zelgar

    Formula to Show 3 Significant Figures/Digits from calculated results regardless of trailing zero

    Here's a site that discusses how to do Banker Rounding in different ways: https://www.extendoffice.com/documents/excel/1145-excel-bankers-rounding.html I'm a little surprised that your new company is using banker's rounding since you indicate it's in a technical field.
  19. zelgar

    Excel 2010 Top 25 Patients Based On Number of Attendances

    In order to keep data integrity wouldn't a macro doing the following be best: 1. Make a new report sheet/delete the data on the report sheet 2. Copy the data onto the report sheet 3. Remove duplicates of the data 4. Insert the COUNTIF statement 5. Sort by the Column with the COUNTIF...
  20. zelgar

    Formula to Show 3 Significant Figures/Digits from calculated results regardless of trailing zero

    Probably the easiest and best way would be a combination of using the =Round(OrigValue, 2- Int(Log(OrigValue) formula and using a conditional formatting using a formula to determine which cells to format with a formula = Len(OrigValue)=2 and the Format using the number format with 1 decimal place.

Part and Inventory Search

Back
Top