+ Reply to Thread
Results 1 to 2 of 2

in Sheet `inputs' Clear Cell D1 and copy from F1 before running the macro.

  1. #1
    Forum Contributor
    Join Date
    02-25-2012
    Location
    Coimbatore, India
    MS-Off Ver
    Excel 2010
    Posts
    445

    in Sheet `inputs' Clear Cell D1 and copy from F1 before running the macro.

    Hello Friends

    Please refer the attached file (New Macro3-100316.xlsm).

    My requirement is very simple.

    While running macros (Before running macros) In sheet `inputs' the cell D1 should be clearing and it should be F1 (By Formula in D1 =F1 like that).

    thanks in advance
    Attached Files Attached Files
    regards

    thilag

  2. #2
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

    Re: in Sheet `inputs' Clear Cell D1 and copy from F1 before running the macro.

    You have answered the question yourself.
    If you use macros you should be able to do this unless you just copy somebody else's macros and want other to solve the problems for you.

    Please Login or Register  to view this content.
    If F1 is empty then you can think of a solution yourself
    ---
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you

+ 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. Looping thru rows and copy cell values from "Inputs" sheet to "Output" sheet
    By hariexcel1987 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-02-2015, 11:32 PM
  2. [SOLVED] Using command button to copy cell contents and paste to different sheet, then clear cells
    By Ethanrholt in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-24-2015, 10:20 AM
  3. [SOLVED] Help with a macro to copy data to other sheet and clear cells
    By bazofio in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-17-2014, 07:59 PM
  4. Replies: 5
    Last Post: 09-08-2013, 10:09 AM
  5. Macro to copy Dyanmic lists then copy sheet and clear the original data
    By twiggywales in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-30-2012, 01:06 PM
  6. Macro to copy data from one sheet to a master sheet with running totals
    By gmi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-14-2012, 10:53 AM
  7. Macro/Module running as background process, copy data from sheet to sheet
    By ctor in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-05-2009, 05:48 AM

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