Transfer data from worksheet to summary page
Solved/Closed
Related:
- Transfer data from worksheet to summary page
- Transfer data from one excel worksheet to another automatically - Guide
- Free fire transfer - Guide
- Copy data from one Excel sheet to another: automatically ✓ - Excel Forum
- Hosted app data ✓ - Google Chrome Forum
- International money transfer app - Guide
5 responses
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
15 Apr 2010 à 11:39
15 Apr 2010 à 11:39
You say you want to move rows, yet it seems that you are selectively moving data from one sheet to other. Could you please upload a sample file on some shared site like https://authentification.site and post back here the link to get a better understanding
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
15 Apr 2010 à 18:11
15 Apr 2010 à 18:11
Would each time previous summary would be wiped out ? I am presuming even the data is copied on other sheet, the original data would remain in place corect?
The workbook is used as a template with each quote "Save As' to a project pack, so each quote starts with a blank template. We would require the original data on the quoting tool work sheet to remain once it is transfered to the BOQ page.
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
16 Apr 2010 à 12:32
16 Apr 2010 à 12:32
Assumptions
1 The template sheet BOQ exists in the workbook
2. No addition or deletion or rows are needed in BOQ
3. Only those rows are to be copied over in which the dollar amount is NOT EQUAL to 0
1 The template sheet BOQ exists in the workbook
2. No addition or deletion or rows are needed in BOQ
3. Only those rows are to be copied over in which the dollar amount is NOT EQUAL to 0
Sub GenerateQuote()
Dim tSheet As String
Dim lMax_tRows As Long
Dim lStartA_tRow As Long
Dim itemID_tCol As String
Dim itemDes_tcCol As String
Dim totalItem_tCol As String
Dim totalCost_tCol As String
Dim qSheet As String
Dim lStart_qRow As Long
Dim lMax_qRows As Long
Dim itemID_qCol As String
Dim itemDes_qcCol As String
Dim totalItem_qCol As String
Dim totalCost_qCol As String
tSheet = "Quoting Tool"
itemID_tCol = "A"
itemDesc_tCol = "B"
totalItem_tCol = "N"
totalCost_tCol = "O"
lStartAt_tRow = 5
qSheet = "BOQ"
totalItem_qCol = "C"
itemID_qCol = "D"
itemDesc_qCol = "E"
totalCost_qCol = "F"
lStartAt_qRow = 4
Sheets(tSheet).Select
lMax_tRows = Cells(Rows.Count, "A").End(xlUp).Row
lMax_qRows = lStartAt_qRow
For lRowBeanCounter = lStartAt_tRow To lMax_tRows
If (Range(totalCost_tCol & lRowBeanCounter) <> 0) Then
With Sheets(qSheet)
.Range(itemID_qCol & lMax_qRows) = Range(itemID_tCol & lRowBeanCounter).Value
.Range(itemDesc_qCol & lMax_qRows) = Range(itemDesc_tCol & lRowBeanCounter).Value
.Range(totalItem_qCol & lMax_qRows) = Range(totalItem_tCol & lRowBeanCounter).Value
.Range(totalCost_qCol & lMax_qRows) = Range(totalCost_tCol & lRowBeanCounter).Value
End With
lMax_qRows = lMax_qRows + 1
End If
Next lRowBeanCounter
End Sub
All I can say is WOW! Your assumptions are right. I'm pretty much a novice at this, I hate to ask but I don't know exactly where I am suppose to type this. Is it possible for you to upload my sample file on https://authentification.site and post back here the link to help me better understand.
Thank you for your help, much appreciated.
Thank you for your help, much appreciated.
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
17 Apr 2010 à 20:53
17 Apr 2010 à 20:53
1. open your excel file
2. press ALT + F11 (both ALT key and F11 key at the same time). This will open VBE
3. In the VBE environment, click on insert and add a new module
4 Copy all the lines from (both lines including)
Sub GenerateQuote()
.....
End Sub
to run the macro, click on the RUN
https://authentification.site/files/21994583/Quoting_Workbook.xls
2. press ALT + F11 (both ALT key and F11 key at the same time). This will open VBE
3. In the VBE environment, click on insert and add a new module
4 Copy all the lines from (both lines including)
Sub GenerateQuote()
.....
End Sub
to run the macro, click on the RUN
https://authentification.site/files/21994583/Quoting_Workbook.xls