Transferring data from one sheet to another

Solved/Closed
Report
Posts
6
Registration date
Tuesday January 22, 2013
Status
Member
Last seen
January 29, 2013
-
 Cuffy70 -
Hello,
I have been using Excel for a number of years but fairly new to formula etc.
I need a VBA code that can copy data from costing(raw data) to quote based on a certain condition matches.

Costing sheet
column---B(Description)-C(Quantity)-D(UOM)-E(Rate)-F(Total)

When a quantity is entered into column C i need the data from that row to transfer to :-

Quote sheet
column---B(Description)-E(Quantity)-F(UOM)-G(Rate)-H(Total)
But only the row that is relevent

2 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
what makes a row "relevant"
what about any existing info

may be post a sample workbook at some public file sharing site and post back here the link to the file itself back here would help in seeing what u want
Posts
6
Registration date
Tuesday January 22, 2013
Status
Member
Last seen
January 29, 2013

Hi rizvisa1
Apologies.
What i meant by relevant is i only want the row that has a quantity entered into it to transfer onto the next tab
Existing info should stay where it is

http://dl.dropbox.com/u/83123211/Maintenace%20costing%20sheet.xlsx
over that issue by installing a macro that runs by clicking on an area of the page.
The only problem i am now having is that whenever i click on that button or view your macro and click run it updates the quote page but shoots the costing page all the way to the bottom
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
"do i have to run the macro every time or should it work automatically"

No you have to run youself. My Idea was when you have entered all information, and ready to generate quote, you would run this macro

"shoots the costing page all the way to the bottom"
I am not 100% sure what you meant. But from what I understood. once you run the macro it is moving the Material cost area down. Could you post a book that shows that behaviour
Posts
6
Registration date
Tuesday January 22, 2013
Status
Member
Last seen
January 29, 2013

Please see link below
http://dl.dropbox.com/u/83123211/Maintenace%20costing%20sheet.xlsm
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
It did work for me. What is the issue ? could you show how it is with macro and how you expected it to be
Hi rizvisa1,
Yet again I must apologise. After much searching I have found a border down the bottom of the sheet which was causing the page to go to the bottom after I ran the macro. Now removed it works perfectly.
Thank you very much for your help