$$Excel-Macros$$ Re: Make this total match to this other total by picking no.'s from list

2016-04-16 Thread 'Sleek' via MS EXCEL AND VBA MACROS
thanks, I saw your worksheet, but it will me some time to figure out exactly what you did as per your instructions above. On Wednesday, April 13, 2016 at 11:03:25 AM UTC+3, sleek wrote: > > > > Is it possible to have a solution to this or even multiple solutions ?? > > S.Lakhani > > -- Are you

$$Excel-Macros$$ how to add dynamic range

2016-04-16 Thread bruce rockes
how can I add more products (using dynamic range ) in attachment " bazz1" to make it like the attachment 'pellet1" where I can click on the color in G2 and it will add the right price? I want to be able to do that in bazz1 attachments. please help. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in

Re: $$Excel-Macros$$ Excel VBA - to transpose records in a row to a new sheet (in columns)

2016-04-16 Thread Victor Momoh
You can use this, change Sheet1 and Sheet2 to your source and destination sheets respectively Sub NewRearrangeMacro() Dim wks As Worksheet, wks2 As Worksheet Dim Lrow As Long, I As Long, j As Long, k As Long Dim Colcount As Long Set wks = Worksheets("Sheet1") Set wks2 = Worksh

Fwd: $$Excel-Macros$$ Formula for Sum of nearest target value

2016-04-16 Thread Dheeraj Bankoti
Dear Experts, Please advise if it is possible and I need your help in this regard. Regards Dheeraj -- Forwarded message -- From: Dheeraj Bankoti Date: Thu, Apr 14, 2016 at 11:24 AM Subject: $$Excel-Macros$$ Formula for Sum of nearest target value To: excel-macros@googlegroups.com