+ Reply to Thread
Results 1 to 2 of 2

Find empty cell in one spreadsheet and then paste information from another

  1. 02-07-2018, 09:50 AM #1
    LePig
    LePig is offline
    Registered User
    Join Date
    08-26-2016
    Location
    england
    MS-Off Ver
    ms office
    Posts
    26

    Find empty cell in one spreadsheet and then paste information from another

    Hi,

    I have various suppliers who sell us various products.

    Each supplier has its own sheet.

    Our purchaser inputs the amount ordered and then the amount delivered on said day. Our grading team then inputs the amount out of spec. We then send reports out with the information.

    I am trying to based upon if a parameter is met send information from one spreadsheet and paste it into another. So we can send out the reports in PDF format. 

    Please Login or Register  to view this content.
    I can find the last used cell but how do it paste the information from the cell required into the blank cell?
    Reply With QuoteRegister To Reply
  2. 02-07-2018, 02:54 PM #2
    kev_
    kev_ is offline
    Forum Expert
    Join Date
    11-22-2016
    Location
    Cornwall,UK
    MS-Off Ver
    office 365
    Posts
    4,240

    Re: Find empty cell in one spreadsheet and then paste information from another

    You are selecting a cell with:
    Please Login or Register  to view this content.
    To copy the value from cell E1 in your other sheet to that cell (modify the range to suit your needs)
    Please Login or Register  to view this content.
    or without selecting
    Please Login or Register  to view this content.
    Unless your sheet name is a variable, I would expect it to be included in quote marks. Is LeleinValue a variable?


    Why you are using 65536 rows when there are now over a million rows? Are you still using Excel 2003?
    Please Login or Register  to view this content.
    Last edited by kev_; 02-07-2018 at 04:43 PM.
    Click *Add Reputation to thank those who helped you. Ask if anything is not clear
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. how to copy a range of cells, paste them and then find next empty cell
    By comp23 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-01-2013, 03:34 PM
  2. Find first non empty cell and then cut and paste that value into a different workbook
    By richyk in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-25-2013, 11:28 PM
  3. Find first non-empty cell in a spreadsheet row and copy the content to a separate column
    By karl.igniter in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-14-2013, 04:07 AM
  4. Find next empty cell in range and paste
    By Friday in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-16-2011, 12:51 AM
  5. Find next empty row and copy and paste information
    By Gavin Ling in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-20-2009, 03:50 AM
  6. Find first empty cell and paste a value
    By karinos57 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-03-2009, 06:59 PM
  7. [SOLVED] Find Empty Cell and Paste
    By RigasMinho in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-20-2006, 10:05 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1