4 Visitor Messages

  1. patilsshree999
    View Conversation
    hi,
    need help on macro,
    how to reset cell value of d16 b16 d6 to zero after posting values to anotjer sheet


    Sub copydata()
    Dim rcnt As Long

    rcnt = Sheets("Sheet2").Range("H" & Rows.Count).End(xlUp).Row

    rcnt = rcnt + 1
    Sheets("Sheet1").Range("B4").Copy (Sheets("Sheet2").Range("H" & rcnt))
    Sheets("Sheet2").Range("J" & rcnt).Value = Sheets("Sheet1").Range("D16").Value
    Sheets("Sheet2").Range("I" & rcnt).Value = Sheets("Sheet1").Range("B16").Value
    Sheets("Sheet2").Range("L" & rcnt).Value = Sheets("Sheet1").Range("D6").Value
    Sheets("Sheet2").Range("K" & rcnt).Value = Sheets("Sheet1").Range("C6").Value
    Sheets("Sheet1").Range("D4").Copy (Sheets("Sheet2").Range("N" & rcnt))
    End Sub
  2. DGagnon
    View Conversation
    another note is that i noticed the OP had his dates in both text and date formats, so i used TEXT(DATA,"mmm") to make them match.
  3. DGagnon
    View Conversation
    you just need to double check the raw data and make sure there are no "#N/A" in there or it will return an error, if you want to PM me your sheet ill take a look see if i can see anything more specific.
  4. CELIA.NEFF
    View Conversation
    Thanks for your help today. i am new to this website and evdery little bit helps !
Showing Visitor Messages 1 to 4 of 4
About FDibbins

Basic Information


Date of Birth
January 21, 1958 (54)
About FDibbins
Biography:
love solving problems
Love Excel
Location:
Duncansville, PA USA
Interests:
Problem solving
Occupation:
Industrial Engineer
My Microsoft Office Version:
Excel 2007

Signature


Please

[1] Use code tags. Place "[ code ]" before the first line of code and "[/code]" after the last line of code. Exclude quotation marks
[2] Mark your post [SOLVED] if it has been answered satisfactorily, by editing your original post using advanced mode.
[3] Thank those that provided useful help, its nice and its very well appreciated...use the star on the lower left of the post

Statistics


Total Posts
Total Posts
1,050
Posts Per Day
6.94
Last Post
Finding trough points in a data series Yesterday 02:50 PM
Visitor Messages
Total Messages
4
Most Recent Message
05-05-2012 08:15 AM
General Information
Last Activity
Yesterday 02:52 PM
Join Date
12-29-2011

Search Engine Friendly URLs by vBSEO 3.2.0