Results 1 to 3 of 3

Thread: excel spread sheet data transfer help

  1. #1
    Join Date
    Aug 2012
    Posts
    2

    excel spread sheet data transfer help

    Hi Guys,
    I need some help with a excel spread sheet data transfer. I will try to explain the best I can.

    Ok here goes, what I need to do is I have a spare parts list that has 4 columns and many rows. the columns are as follows:
    Part #, Description, Price and Quantity.
    And I have an order form on another sheet in the same workbook. what I want to do is to enter the quantity in the Quantity cloumn and have the sheet recognize only the rows that have 1 or more in the quan. and move them to the next sheet, into rows and add rows as needed to finish the order form. so in the end I have an order form that has all of the ordered parts and info. but only that info and none of the marked "0" Cells. Hope this is clear enough.
    Thanks for any help.

  2. #2
    Join Date
    Dec 2007
    Posts
    1,736

    Re: excel spread sheet data transfer help

    Can you try the below code and see if that helps you out:

    Code:
    Private Sub CommandButton1_Click() 
    
    Dim C As Long 
    Dim Cell As Range 
    Dim NextRow As Long 
    Dim Rng As Range 
    Dim EntryWks As Worksheet 
    Dim DBWks As Worksheet 
    C = 1 
    Set EntryWks = Worksheets("Sheet1") 
    Set DBWks = Worksheets("Sheet2") 
    Set Rng = EntryWks.Range("B6:ad6") 
    
    NextRow = DBWks.UsedRange.Rows.Count 
    NextRow = IIf(NextRow = 1, 1, NextRow + 1) 
    
    For Each RA In Rng.Areas 
    For Each Cell In RA 
    C = C + 1 
    DBWks.Cells(NextRow, C) = Cell 
    Next Cell 
    Next RA 
    End Sub

  3. #3
    Join Date
    Aug 2012
    Posts
    2

    Re: excel spread sheet data transfer help

    Thanks, it works partially, I am attaching a copy of what I am looking for to get a idea of what I need.
    Please change the extension to xlsm.
    Thanks,
    Mark
    Attached Files Attached Files

Similar Threads

  1. Replies: 5
    Last Post: 25-02-2012, 11:09 AM
  2. Replies: 2
    Last Post: 23-02-2012, 05:55 PM
  3. How to insert HyperTerminal data into excel sheet.
    By Shaina Na in forum Microsoft Project
    Replies: 1
    Last Post: 08-01-2012, 07:44 PM
  4. Parsing data in Excel Sheet
    By Ossi in forum Windows Software
    Replies: 4
    Last Post: 04-02-2011, 07:55 AM
  5. Identifying common data in an excel sheet
    By Hebrew in forum Windows Software
    Replies: 5
    Last Post: 25-12-2009, 06:57 PM

Tags for this Thread

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
  •  
Page generated in 1,711,692,828.25060 seconds with 18 queries