+ Reply to Thread
Results 1 to 1 of 1

copy formula and paste for new data added and autofill.....and paste special values

  1. #1
    Forum Contributor prabhuduraraj09's Avatar
    Join Date
    05-19-2012
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    330

    copy formula and paste for new data added and autofill.....and paste special values

    Hi all,

    please help me for the below,

    In a spreadsheets There is a formula in cell "D1" and "E2".

    i have a data in the same sheet from 3rd row, every time i add data and copy formula from "D1" and paste for new data which is added last and i will double click autofill so this formula reflect to all data.

    simiarly i copy Formula from E2 and i past this formula in E column only to the newly added data.

    And since now i have pasted the formula and autofilled so to reflect to all newly added data. i do copy paste special so to retain values

    Anyone could help me to obtain this via vba code.

    i have attached example spreadsheets.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 10-01-2012, 11:11 PM
  2. [SOLVED] Macro to find SKU in column; then copy data in row and paste special (values)
    By Starkey in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-13-2012, 06:05 AM
  3. Copy, Paste Special Values
    By Ikeeptring in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-22-2009, 09:11 AM
  4. Copy Paste Special Values
    By Lotus123 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-21-2008, 02:11 PM
  5. copy and paste special values
    By gregvb in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-09-2007, 01:54 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1