cell.offset

Hello, I am trying to write some code that will calculate the days between two dates if cell in column "A" is populated. Currently i have this bit (if A is populated, Q(offset 16) should equal the difference between N(offset 13) and P(offset 15): Dim cell As Range For Each cell In...

Hi, I have two lists on two separate sheets and I am trying to append one list (ws6) to the other (ws). It should copy the relevant ranges per row in sheet ws6 and paste them into the relevant columns in sheet ws. Then it should add in two values on two columns to each appended row in sheet...

Hey, I need to grab the title of the first document from a search on 'https://infostore.saiglobal.com/en-au/Search/' For example; 'https://infostore.saiglobal.com/en-au/Search/All/?searchTerm=as%201400/' And paste it 2 cells to the right of the currently selected cell. From where i've found...

I have a code that searching for values and if match is found overwriting existing values, if not match found adding new records. The code does what I need except of one thing. I want to replace Sheet2 reference with an external user-selected workbook. I presume that I have to use...

I have the following Macro which generates multiple invoices and then creates a PDF for each one. Is it possible for it to generate them as separate excel sheets instead? Sub Invoice() Dim Month As String, FltRng As Range, cell As Range Application.ScreenUpdating = False With Sheet4 Month =...

Hello all.. learning this vba stuff one google search at a time is tough! I'm knee deep into a project that's well beyond my skill set.. but learning fast. The trouble I'm having is how to reference other cells in proper syntax.. and understanding how to specify a range... can someone get me...