LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 41
Default MACRO THAT BUILDS ON ANOTHER MACRO'S DATA

I have posted this 2ce but I think I did a very bad job of explaining what I
was looking for.. Hopefully I have done a better job now as I really need the
assistance!

Ron Bruin helped with a macro that combines data from several tabs into one
sheet and that macro works great..

I want to create a macro that runs Ron's macro and then with that resulting
data, does the following:

(Row 1 contains headers from Ron's macro and I can't find how to have the
Resulting Data Macro "Start"? on Row 2-also, Ron's macro seems to create 3
total header rows and I have to delete 2 of them in the "Resulting Data "
macro);

Columns A-H contain the data from the combo macro; Columns I:L would contain
formulas (each column has a unique formula and uses the data from Columns
D-H... BUT they only run IF Column C has text..

The formulas are as follows:

Column I has Column D + Column E - Column F..
Column J has Column D + Column E - Column H
Column K = Column G.
Column L has Column J - Column K.

And these formulas need to insert themselves in the respective rows in
Columns I-L as long as there is text in Column C from the already run combo
macro..

I appreciate your assistance!!!


 
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 FUNCTION conflict with other macro's MrDave Excel Discussion (Misc queries) 3 July 19th 09 12:25 PM
Does anyone know of a service/company that builds macros? punter Excel Discussion (Misc queries) 5 August 17th 06 02:43 PM
Hide Macro's in Toolbar / Macro's list sparx Excel Discussion (Misc queries) 2 May 6th 06 08:53 PM
How do I change the order of how excel builds a chart? big al Charts and Charting in Excel 2 May 26th 05 08:47 AM
automated macro's? and macro limitation to a worksheet FAM THEUWS Excel Programming 1 November 5th 03 10:23 PM


All times are GMT +1. The time now is 07:03 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"