Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default I have a complex task that I think could be easy with a macro

The problem with that is I do not know the first thing about them. I am
trying to format about 250 cost sheets for my company, all with varied lines
of text/code I was wondering if someone knew or could create and outlined
macro that would allow me to do the following:
I would like to move a date string 3cells over and merge the cells so that
it will display properly
I was also wondering if I would be able to have the macro search for
specific strings and then modify them. I have tried the record macro method
which works ok if all the following costs sheets have the same data on the
same lines. If the macro could search for the string and then move it and
format it when found that would be ideal. like I said an outlined macro will
do just fine I could research and fill in the blanks (I think).I am basicly
looking for something that will give all of my cost sheets the same format by
moving the info around in a manner which my company has agreed on and not
deleting anything (which the record macro function does)

Thanks for all your help.
Reply
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
easy use 12 month planner, complex elements, basic user, help A cry for help Excel Worksheet Functions 1 February 12th 07 12:10 AM
a complex task TUNGANA KURMA RAJU Excel Discussion (Misc queries) 0 January 8th 06 07:07 AM
Event macro for a task TUNGANA KURMA RAJU Excel Discussion (Misc queries) 8 January 6th 06 10:43 AM
macro to automise the task TUNGANA KURMA RAJU Excel Discussion (Misc queries) 3 December 7th 05 07:42 PM
Complex lookup task for a newbies nhwong Excel Worksheet Functions 5 November 9th 04 04:05 PM


All times are GMT +1. The time now is 07:45 AM.

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"