+ Reply to Thread
Results 1 to 2 of 2

Copying formula from new month but not input data using fill

  1. #1
    Registered User
    Join Date
    10-20-2017
    Location
    Dublin, Ireland
    MS-Off Ver
    2202 (Build 14931.20858 Click-to-Run)
    Posts
    50

    Lightbulb Copying formula from new month but not input data using fill

    I've attached a file. I've used simpler explanation, but basically I've to input data into a report every month (column B), but use the same formula from the last month except referencing the new cells.

    There are multiple columns in the real world, so it's time-saving to drag them all the information down from the previous 2 months to form the new month but this throws in a supposed value.

    Is there anyway to copy data down from previous two rows, but leave data in one column blank?

  2. #2
    Forum Contributor
    Join Date
    01-09-2016
    Location
    Perth Western Australia
    MS-Off Ver
    Office 365
    Posts
    257

    Re: Copying formula from new month but not input data using fill

    Hi

    Without knowing what the formula is it is impossible to offer advice on how to solve your problem. Uploading a spreadsheet with the formula will assist.

    Cheers

+ 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. [SOLVED] Automatically fill in the date of the month based on the first input.
    By Richard_Thornton in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-28-2017, 11:10 AM
  2. [SOLVED] Fill Data to Appropriate Month Sheet
    By LewisJ in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 03-22-2017, 01:49 PM
  3. Replies: 1
    Last Post: 09-23-2016, 11:56 AM
  4. [SOLVED] need vba to fill formula and input box value into formula overwrite date
    By johnmacpro in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-15-2016, 12:55 AM
  5. Copying fill of month series but don't change formatting
    By ammartino44 in forum Excel General
    Replies: 1
    Last Post: 03-23-2015, 12:05 AM
  6. Fill Data -- Month and Date
    By beneesetas14 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-03-2014, 03:00 AM
  7. Auto Fill Pre Input Data
    By twhitworth in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-23-2013, 02:21 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