LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 9
Default Creating a Macro to autofill and save

Hi,

I am trying to create a macro that will complete the following.

Autofill column K with sequential numbers starting from cell K2 with 1 to
however many rows of data there are.

Then for the file to automatically save as a CSV (Comma Deliminated) format
so that the user just has to typr the name of the file in.


I am not a competent using visual script however should be abl to navigate
myself to the right place.

Thanks
Laura
 
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
Creating an autofill type function from a data validation box SethT Excel Discussion (Misc queries) 1 January 29th 10 10:44 PM
Creating controls to autofill a form wepstech Excel Discussion (Misc queries) 2 February 23rd 07 01:00 PM
Creating a macro to save only partial data Jparsons Excel Discussion (Misc queries) 0 September 24th 05 10:50 AM
creating a macro for a "Save As" box MysticMarley Excel Discussion (Misc queries) 2 August 9th 05 02:31 AM
autofill macro glee Excel Discussion (Misc queries) 1 February 14th 05 05:14 PM


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

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

About Us

"It's about Microsoft Excel"