$$Excel-Macros$$

Dear Board Members This is my first question on this board, I need a help in capturing data from three sheet into one (RESULT) sheet based on the CATCODE Can anybody help me to sort this out as per the attached file. Please read the notes give in id sheet and result sheet. Best Rega

Re: $$Excel-Macros$$ =Now() Keep from changing

instead of writing =NOW() or =TODAY() in a cell select a cell then press Ctrl + ;(for FIXED today's date ) press Ctrl + Shift + :(for Fixed Now time ) On Sun, May 8, 2011 at 2:12 AM, Bob wrote: > If I enter the Customer in B27 I'd like for todays date to be entered > in F27 automat

$$Excel-Macros$$ =Now() Keep from changing

If I enter the Customer in B27 I'd like for todays date to be entered in F27 automatically. How would you keep the date from changing the next day, each time the workbook is opened? Thanks in advance!!! -- -- Some imp

Re: $$Excel-Macros$$ Please Help

try to use this UDF (user defined function) Function UniqueList(Dat As Range) ' List of UnSorted Unique Values ' '-' Dim Cel As Range, vArr(), n As Long, Tx As String Tx = ", " For Each Cel In Dat If InStr(1, Tx, ", " & Cel & ", ") = 0 T

Re: $$Excel-Macros$$ How to use Vlookup in macro

It would be easy for anyone in the group to respond, if you can send a set of sample data. On Sat, May 7, 2011 at 1:47 PM, maulik desai wrote: > Hi All, > > I have excel database sheet > I have created some excel output sheets (around 35 excel sheets) which > gives me output data with the help

Re: $$Excel-Macros$$ A small query, need your help in vba coding.

Your code looks like to be run in excel 2003 only (1) In both excel 2003 / excel 2007 Range("A65000") ' last row in A column can be coded as Cells(*Rows.Count*,1) or Range("A" & *Rows.Count*) (2) *Value* property of a Range Object is a *DEFAULT Property* so you can ignore it For example Range

Re: $$Excel-Macros$$ How to use Vlookup in macro

Hai Will you send a copy of worksheet... Thanks On Sat, May 7, 2011 at 12:17 PM, maulik desai wrote: > Hi All, > > I have excel database sheet > I have created some excel output sheets (around 35 excel sheets) which > gives me output data with the help of Vlookup fuction. > But the problem is i

Re: $$Excel-Macros$$ A small query, need your help in vba coding.

Thanks a lot to all of you. -- Indrajit -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linked

Re: $$Excel-Macros$$ Macro to send email automatically.

When copying excel files, the following problems: PROBLEM 1 1). The settings of the Margins are getting disturbed PROBLEM 2 Also when you take a print out, the @age of the page fluctuates Do you or your friends have any solution Please revert Thanks & regards On 5/6/11, ashish koul wrote:

Re: $$Excel-Macros$$ A small query, need your help in vba coding.

When copying excel files, the following problems: PROBLEM 1 1). The settings of the Margins are getting disturbed PROBLEM 2 Also when you take a print out, the @age of the page fluctuates Do you or your friends have any solution Please revert Thanks & regards On 5/7/11, STDEV(i) wrote: >

Re: $$Excel-Macros$$ Please Help

try the attachment On Sat, May 7, 2011 at 2:20 PM, karan 1237 wrote: > * > LIST1* *LIST1* *LIST1* *RESULT* BACK SIDE FRONT BACK, SIDE, FRONT FRONT > SIDE FRONT FRONT, SIDE BACK FRONT BACK BACK, FRONT FRONT FRONT FRONT FRONT > *Hi Experts, > > I want like this. Please help. > > Thnx in Adva

Re: $$Excel-Macros$$ NEED HELP - GET PIVOT

When copying excel files, the following problems: PROBLEM 1 1). The settings of the Margins are getting disturbed PROBLEM 2 Also when you take a print out, the @age of the page fluctuates Do you or your friends have any solution Please revert Thanks & regards On 5/6/11, mayur wrote: > Tha

Re: $$Excel-Macros$$ Solution plse

When copying excel files, the following problems: PROBLEM 1 1). The settings of the Margins are getting disturbed PROBLEM 2 Also when you take a print out, the @age of the page fluctuates Do you or your friends have any solution Please revert Thanks & regards -- ---

$$Excel-Macros$$ Please Help

* LIST1* *LIST1* *LIST1* *RESULT* BACK SIDE FRONT BACK, SIDE, FRONT FRONT SIDE FRONT FRONT, SIDE BACK FRONT BACK BACK, FRONT FRONT FRONT FRONT FRONT *Hi Experts, I want like this. Please help. Thnx in Advance. * ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı -- ---

Re: $$Excel-Macros$$ MkDir (ThisWorkbook.Path & "\33")

thanks Ranjan. one more query.. is there a way if there is any folder with the same name..it will go into the folder.. and if the file is in the same name it will replace the file with the new one. Application.ScreenUpdating = False Sheet1.Visible = xlSheetVisible Sheet1.Activate ActiveSheet.Cop

$$Excel-Macros$$ How to use Vlookup in macro

Hi All, I have excel database sheet I have created some excel output sheets (around 35 excel sheets) which gives me output data with the help of Vlookup fuction. But the problem is in every 3 months I have to change the database month name & because of that I need to change the vlookup range also

Re: $$Excel-Macros$$ A small query, need your help in vba coding.

Private Sub CommandButton1_Click() Range("A65000").End(xlUp).Cells(2, 1) = Range("C1").Value: Range("A65000").End(xlUp).Cells(1, 2) = Range("D1").Value: End Sub On Sat, May 7, 2011 at 1:56 AM, Indrajit $nai wrote: > Hi All, > > I have a little query in vba coding, please see the attached file.

$$Excel-Macros$$ Need Help

Hi, I need help in VBA code. I have excel sheet on which data is write as below mention Input A BC D 1 X1 1.511/11/2008 01/11/2010 2 X2 2.511/12/2009 01/11/2010 3 X3 3.511/01/2010 01/11/2010 I want O

Re: $$Excel-Macros$$ Calculate Due dates

change "dd-mmm-" to "dd-mmm'" in formula On Sat, May 7, 2011 at 7:47 AM, Mr excel wrote: > dear ashish,, > >That is excellent & great.Thanks a lot .The formula u provided is > very nearer to the solution i wanted.everthing is same except in the month > column of the sheet.Name