Hi, I am new to the forum and am in need of some assistance!!
I have been asked to create a spreadsheet that fills out certain cells in a worksheet, with data in cells from another worksheet in the same workbook, and print out this sheet!!
I am not new to VBA but am far from being an expert!! Most of the VBA I create are done by the recording method, but this is over my head!
The date will be yesterday's date (Cell AA1 on Sheet2), and when activated the VBA will look at column A on sheet2024, until it finds yesterday's date, it then takes the data from that row and adds it to specific cells on sheet2, Date (Column A) to B4 (Sheet2), Model (Column B) to E4 (Sheet2), Serial number (Column D) to H4 (Sheet2), Dealer (Column E) to K4 (Sheet2), Returns Number (Column F) to N4 (Sheet2), Reason for Return (Column G) to Q4 (sheet2)
the Check in Factory and Check in Service need to be colour coded Green for Factory and Red for Service, this determined by the colour coding on Sheet 2024 in column B!
The VBA needs to then print out the completed card, and clear the data, it then needs to look at the next row with the same date, and do the above again, with the next row of data if there is anymore to do, if there is nothing more to do, then the VBA can just stop or show a text box stating it has completed?
I hope the above makes sense, and hope I've not broken any rules!!
Thanks in advance for any assistance...
I have been asked to create a spreadsheet that fills out certain cells in a worksheet, with data in cells from another worksheet in the same workbook, and print out this sheet!!
I am not new to VBA but am far from being an expert!! Most of the VBA I create are done by the recording method, but this is over my head!
The date will be yesterday's date (Cell AA1 on Sheet2), and when activated the VBA will look at column A on sheet2024, until it finds yesterday's date, it then takes the data from that row and adds it to specific cells on sheet2, Date (Column A) to B4 (Sheet2), Model (Column B) to E4 (Sheet2), Serial number (Column D) to H4 (Sheet2), Dealer (Column E) to K4 (Sheet2), Returns Number (Column F) to N4 (Sheet2), Reason for Return (Column G) to Q4 (sheet2)
the Check in Factory and Check in Service need to be colour coded Green for Factory and Red for Service, this determined by the colour coding on Sheet 2024 in column B!
The VBA needs to then print out the completed card, and clear the data, it then needs to look at the next row with the same date, and do the above again, with the next row of data if there is anymore to do, if there is nothing more to do, then the VBA can just stop or show a text box stating it has completed?
I hope the above makes sense, and hope I've not broken any rules!!
Thanks in advance for any assistance...
