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 Training and help » Excel macro
Excel macro
Resolved · Low Priority · Version 2003
Fri 19 Mar 2010, 11:50Delegate Bruce said...
Bruce has attended:
Excel Advanced course
Excel macro
I have a spreadsheet with formulae in some cells of each row, and data in all cells of each row. I want a macro to select all the formulae in the row where the cursor is, insert a new row below the cursor location, and copy the formulae, but not the data to the new row.
Is this feasible please?
Tue 23 Mar 2010, 12:20
Edited on Tue 23 Mar 2010, 12:21Trainer Jacob said...
RE: Excel macro
Hello Bruce
After reviewing your post there are two courses of action to follow:
1) Consultative route, we work on your files to derive a solution then show you how to do it. We will prepare a scope of work with durations and costs which you decide on before any work starts.
2) Attend our 2 day Excel VBA Introduction course and pick up the skills necessary to complete the work yourself.
If you are interested in progressing this please do let us know
Regards
Jacob
Training information:
See also:
|
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:Page Break Preview in Excel 2010 (Hint/tip)If you select View then Workbook Views then Page Break Preview, you will be able to view how your Excel spreadsheet will be split across multiple pages when printed. Even better, you can also drag a page break to a new place. Excel will then scale down your entire worksheet to fit the information you want on the pages you want. |
