LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
jgray
 
Posts: n/a
Default trying to create an insert row macro

hey guys,

I'm trying to create a macro to streamline a process for one of our factory
guys. Right now, I'm going down and manually inserting rows into a database
and then dragging the needed formulas and information from the rows above
down. What I'm trying to do is make it so he can place his cursor, hit the
macro key stroke and have that done for him. When I record the macro, I
think I am making an absolute cell reference, because when I run the macro it
will only instert where I initially inserted the row. How do I create the
macro so he can select where he wants it and then have the row inserted and
formulas dropped down for him?

Thanks in advance for all your help!

James
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro Line Insert Frantic Excel-er Excel Discussion (Misc queries) 4 March 20th 06 11:08 PM
How do I create a macro to return drop down boxes to first item i. gaalseth Excel Discussion (Misc queries) 1 April 13th 05 09:09 PM
CREATE MACRO TO COPY MULTIPLE WORKSHEETS Bewilderd jim Excel Discussion (Misc queries) 5 March 3rd 05 10:00 PM
Is it possible to create a macro to group? Mike Piazza Excel Discussion (Misc queries) 1 January 8th 05 12:23 AM
How can I insert a vertical column break between data to create a. Mark Wisdom Excel Worksheet Functions 1 November 23rd 04 04:10 AM


All times are GMT +1. The time now is 04:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"