Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 29-08-2012
Member
 
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.
Reply With Quote
  #2  
Old 29-08-2012
Member
 
Join Date: Dec 2007
Posts: 1,728
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
Reply With Quote
  #3  
Old 29-08-2012
Member
 
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
File Type: doc Book1.doc (29.8 KB, 1 views)
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "excel spread sheet data transfer help"
Thread Thread Starter Forum Replies Last Post
Want to copy Excel Chart to another sheet without the Data LuniA MS Office Support 5 25-02-2012 11:09 AM
Is there a way to populate one sheet data from another in Excel M.N.S MS Office Support 2 23-02-2012 05:55 PM
How to insert HyperTerminal data into excel sheet. Shaina Na Microsoft Project 1 08-01-2012 07:44 PM
Parsing data in Excel Sheet Ossi Windows Software 4 04-02-2011 07:55 AM
Identifying common data in an excel sheet Hebrew Windows Software 5 25-12-2009 06:57 PM


All times are GMT +5.5. The time now is 05:22 AM.