+ Reply to Thread
Results 1 to 8 of 8

Filter and copy cell from 1 sheet to another

  1. #1
    Forum Contributor
    Join Date
    03-19-2020
    Location
    Greece
    MS-Off Ver
    office 365
    Posts
    123

    Filter and copy cell from 1 sheet to another

    Good morning to everyone,
    I need one more help as usual, this time i think is a little bit more difficult...
    I have some bookings in "sheet 1" and i need depending on the date, the data from sheet 1 to be copied in "sheet 2".
    Attached the excel file and also an image with the example.
    Thank you again for your help, as it will save me a lot of time to copy paste manually the daily report (I don't mind if i have to create different formulas for each column).
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    China Shanghai
    MS-Off Ver
    365 V2402 and WPS V2022
    Posts
    3,327

    Re: Filter and copy cell from 1 sheet to another

    welcome to Forum

    Would you pls to explained that the date of D1 is Arrival Date or Departure Date ?

  3. #3
    Forum Contributor
    Join Date
    03-19-2020
    Location
    Greece
    MS-Off Ver
    office 365
    Posts
    123

    Re: Filter and copy cell from 1 sheet to another

    Is the arrival date

  4. #4
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    China Shanghai
    MS-Off Ver
    365 V2402 and WPS V2022
    Posts
    3,327

    Re: Filter and copy cell from 1 sheet to another

    Worksheet name : Report

    Cell B4 formula , Drag down

    HTML Code: 
    Attached Files Attached Files
    Last edited by wk9128; 09-16-2021 at 04:17 AM.

  5. #5
    Forum Contributor
    Join Date
    03-19-2020
    Location
    Greece
    MS-Off Ver
    office 365
    Posts
    123

    Re: Filter and copy cell from 1 sheet to another

    It didnt worked, when i copy paste the formula in cell B4 i get it as in picture 1 and when i drag it down like in picture 22.jpg

  6. #6
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    China Shanghai
    MS-Off Ver
    365 V2402 and WPS V2022
    Posts
    3,327

    Re: Filter and copy cell from 1 sheet to another

    pls download POST#4 attachment (Just put the formula in)

  7. #7
    Forum Contributor
    Join Date
    03-19-2020
    Location
    Greece
    MS-Off Ver
    office 365
    Posts
    123

    Re: Filter and copy cell from 1 sheet to another

    wk9128 Thank you very much for your help

  8. #8
    Forum Expert wk9128's Avatar
    Join Date
    08-15-2020
    Location
    China Shanghai
    MS-Off Ver
    365 V2402 and WPS V2022
    Posts
    3,327

    Re: Filter and copy cell from 1 sheet to another

    @andsalex You're Welcome. Glad to help . Thank You for the feedback

+ 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. Filter, Copy data to new Sheet, Filter again and copy again
    By jharvey87 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-11-2021, 02:50 PM
  2. Excel VBA - Copy Data based on a cell value and filter to new sheet
    By scruz9 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-18-2016, 08:06 AM
  3. [SOLVED] Filter by ref cell Value and copy to new sheet. Compile Error: Sub or Function not Defined
    By moxman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-09-2013, 11:56 PM
  4. Replies: 1
    Last Post: 06-05-2013, 07:03 AM
  5. [SOLVED] Range Selection up to last visible adjacent cell,filter,copy paste to next sheet
    By kcube17 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-15-2013, 07:08 AM
  6. Loop through filter and copy subtotal from cell NOT in table to other sheet
    By MStaretorp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-28-2012, 02:41 PM
  7. filter and copy cell contents to another sheet
    By shoo002 in forum Excel General
    Replies: 8
    Last Post: 09-20-2010, 07:25 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