98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA statement for Excel 2003 - To copy information by different
VBA statement for Excel 2003 - To copy information by different
Resolved · Low Priority · Version 2003
Sat 20 Feb 2010, 10:18Delegate Gary said...
Gary has attended:
Access VBA course
Excel VBA Advanced course
VBA statement for Excel 2003 - To copy information by different
Good morning,
I have an offence code spreadsheet, these are grouped by an Integer value in the Offence Group column on the spreadsheet. I would like a bit of code that basically knows which group it is sorted by on the column and then if there is a new offence it inserts a new cell and updates a linked spreadsheet that I have namely G20 offences codes.
I have tried a few different ways but I have multiple debugging errors.
So, basically it recognises the integer value i.e. 15 and then if there is a new offence it inserts a new row underneath the group and then transfers this information to a new spreadsheet.
If you could help me on this urgently that would be greatly appreciated.
Thanks,
Gary
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Autofit column width – Excel (all versions)a. Highlight the column or columns you wish to alter the width of. You do this by clicking on the grey button at the top of the column showing the column letter. Click and drag on these letters to select more than one column. |
