(Intro):
I send invoices to a company to get compensated for work. These invoices contain 6 pieces of information. They can each come in multiple forms and are all uniquely wrongful in someway and need attention. I have working code to fetch one array of all six pieces of information separately( as in piece one, piece two, piece three, rather than (piece one ... piece six) ). However, there are potentially an indefinite number of rows of this information and I only have code to account for one row.
Here's my code to get all the information I need
Dim CellValue As String
Dim CellValueX As String
Dim CellValueY As String
Dim Value As String
Dim Result As String
Dim ErrorRange As String
Dim ErrorCells As String
Dim DateValue As Date
CellValueY = Range("B2").Value
'First Name
CellValueX = Range("A2").Value
'Last Name
'P1
'SHEET NAME
CellValue1 = Range("I2")
'Problem
CellValue2 = Range("J2")
'CC Paid?
CellValue3 = Range("K2")
'Billable?
CellValue4 = Range("L2")
'Billable Status
CellValue5 = Range("M2")
'Service Type
CellValue6 = Range("N2")
'F2F Date 1
CellValue7 = Range("O2")
'CONT Date 2
End Sub
(Problem)
This array of information goes into one row on an Email. I have that part working fine, I just need help getting more than one array.
TL;DR - Problem
I'm sending invoices back for another go over and I can't get more than one invoice at a time to come back. I need multiple cells/ranges of information at a time but I can only get one. Help!
Any guidance is deeply appreciated.
Bookmarks