tblcosting

I have a spreadsheet that is used to generate quotes for clients. The worksheet (npss_quote_sheet) is used to generate 1 quote for one client at a time. There is a table (npss_quote) that lists the services in the quote for the one client. Once all services have been entered, the quote is...

I have a procedure to transfer some data from a table in one workbook to a table in another workbook. I want to be able to sort everything in the destination table by date in ascending order after the transfer but I am not sure of the vba code. The date is in column A of both workbooks The...

I have a complex spreadsheet that is used to generate a quote. The quote has information at the top: Caseworker, Organisation and Child/YP in 3 different cells. There is then a table under that called npss_quote. The table has rows relating to the information at the top. The quotes then...

I need some help. I am still learning to code and I don't yet fully understand vba. I have the following code and it is keeps giving me errors: Sub cmdCopyr() Application.ScreenUpdating = False 'declare variables Dim TableLastRow As Long Dim LastRow As Long Dim TableNumberRows As Long Dim...

I have some code that when I try and run it, I get an error message saying next without for and it has the next highlighted. What am I missing? Sub cmdCopyr() Application.ScreenUpdating = False 'declare variables Dim TableLastRow As Long Dim LastRow As Long Dim TableNumberRows As Long Dim...