Super User Asked by Brendan on November 5, 2020
I’ve searched all over, and I’m unable to find anything regarding copying multiple cells from different rows & columns to a single row in another sheet.
Eg, Copy Cells, A10, F2, F3 & F34 from Sheet 1, to A2 in Sheet 2 and start a new row.
The purpose is to copy certain information from an Invoice (Sheet 1)
to a single row in another sheet for reporting (Sheet 2)
When I complete a new invoice, I’m hoping to run the same macro to copy these cells onto the next empty row in Sheet 2.
To keep it simple and for easier debugging, use helper cells.
In an unused row, row 99 for example, link to your four source cells (A99=A10, B99=F2, C99=F3, D99=F34). Then the macro is straightforward. Hide row 99 to keep it clean.
Answered by StartupSpreadsheets on November 5, 2020
This VBA Macro will do it:
Public Sub resume_invoice()
Dim wkb As Workbook
Dim wks, wks1 As Worksheet
Set wkb = ThisWorkbook
Set wks = wkb.Sheets(1)
Set wks1 = wkb.Sheets(2)
use_row = wks1.Cells(wks1.Rows.Count, "A").End(xlUp).Row
use_row = use_row + 1
If wks.Cells(3, 6) <> wks1.Cells(use_row - 1, 3) Then
wks1.Cells(use_row, 1) = wks.Cells(10, 1)
wks1.Cells(use_row, 2) = wks.Cells(2, 6)
wks1.Cells(use_row, 3) = wks.Cells(3, 6)
wks1.Cells(use_row, 4) = wks.Cells(34, 6)
Set wkb = Nothing
Set wks = Nothing
Set wks1 = Nothing
End If
End Sub
Go to macro / VBA, under ThisWorkbook insert a module and paste the code.
To make it easy to use you can assign a button to execute it.
Answered by jcbermu on November 5, 2020
2 Asked on December 27, 2021 by hamed-mayahian
1 Asked on December 25, 2021 by ravi-kumar-rana
1 Asked on December 25, 2021 by flyto
3 Asked on December 25, 2021 by ez-riding
8 Asked on December 25, 2021 by aanrv
1 Asked on December 25, 2021 by etalon11
2 Asked on December 25, 2021 by iskar
3 Asked on December 25, 2021 by step
3 Asked on December 25, 2021 by alaind
3 Asked on December 25, 2021 by undry
1 Asked on December 25, 2021
1 Asked on December 25, 2021 by nitin-mehta
kali linux linux windows subsystem for linux windows terminal wsl2
1 Asked on December 25, 2021
0 Asked on December 25, 2021 by user185953
3 Asked on December 25, 2021
3 Asked on December 23, 2021
Get help from others!
Recent Answers
Recent Questions
© 2023 AnswerBun.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP