dearest paul,
Thanks a lot.U are really a friend in need.
aju
On Thu, Feb 11, 2010 at 9:32 PM, Paul Schreiner <schreiner_p...@att.net>wrote:
>
> What you've asked to do isn't difficult, but it IS time-consuming.
> This forum isn't designed to be a "free programming service" site.
> Most of the users here have jobs, and volunteer their time to help others
> at THEIR jobs.
>
> What you've asked to do looks simple enough, on the surface.
> But it can get complicated.
> For instance, in your macro, you're copying the SAP data to the new sheet
> and adding the PHY values.
> but you want to be able to SELECT which column in the SAP data has the
> quantity.
> what happens to the rest?
>
> I put together a userform that allows the user to select the sheet IN THE
> CURRENT workbook.
> it then populates the comboboxes with the sheets so that the user can
> select the
> material and quantity columns.
>
> it then runs a simplified consolidation script.
>
> You can try it using the Show_Form macro.
>
>
> Paul
>
>
>
> ------------------------------
> *From:* aju chacko <ajuvcha...@gmail.com>
> *To:* excel-macros@googlegroups.com
> *Sent:* Thu, February 11, 2010 5:06:14 AM
> *Subject:* Fwd: $$Excel-Macros$$ kindly help in modifying attached macro
>
> Any body in the group ,please help it's urgent OR give some guidelines in
> accepting inputs from users so that existing code can be used
>
> aju v chacko
>
>
>
> ---------- Forwarded message ----------
> From: aju chacko <ajuvcha...@gmail.com>
> Date: Feb 10, 2010 5:44 PM
> Subject: $$Excel-Macros$$ kindly help in modifying attached macro
> To: excel-macros@googlegroups.com
>
>
> *Dear vba gurus*,
> Attached herewith a macro that made by friend to
> compare two excel work sheets (SAP & PHY) in workbook,both are arranged as
> table & *one common field (MATERIAL) *available in both sheets .What the
> macro is doing that it create w.sheet named consolidated & then tabulate
> *'quantity' field from sheet phy *against *'unrestricted' field* *in
> w.sheet SAP* for the same *material* in two sheets.Similarly if a item in
> *MATERIAL* item is not available in w.sheet *SAP*,but available in
> w.sheet *PHY* that also will be brought to consolidated worksheet with
> sap qty '*0'*.The difference of these two fields ( *unrestricted-**quantity)
> in final column with heading 'difference'.Now this macro is HARD CODED so
> that it work only when specified worksheets,specified column headers etc.
> in specified order,What i required is a macro when it is executed ,accepts
> some inputs from the user as shown belo**w *
>
>
>>
>> 1] User will be prompted to *select first & second work sheets to be
>> compared* among the w.sheets in the active work book
>>
>> 2] Once he selected the w.book(s),he will be prompted to select *the
>> common field from both the sheets* on which comparison to be made.
>>
>> 3] Finally he will be prompted to *select numerical fileds from both
>> sheets* which is to be compared side by side
>>
>> Once he made these selections remaining process is same as what the
>> attached macro is doing (summing numerical field for duplicate entries &
>> eliminate duplicate entries ,final using vlookup function to find matches)
>> *except the user selected values to be assigned against the hard coded
>> variable name used in the macro*.
>> Thanking you in advance,
>>
>> Aju v chacko
>>
>>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com/
> 3. Excel tutorials at http://www.excel-macros.blogspot.com/
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com/
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com/
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,700 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,700 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>
> To post to this group, send email to excel-macros@googlegroups.com
> If you find any spam message in the group, please send an email to:
> Ayush Jain @ jainayus...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,700 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,700 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
