Re: $$Excel-Macros$$ Copying existing Address from column "B" to column "A" Using IF statement ( I think).

​​ Last line edited :) Now this will handle your requriement Sub Test() With Application .ScreenUpdating = False .DisplayAlerts = False End With Dim lr As Long lr = ActiveSheet.Cells(Rows.Count, 2).End(xlUp).Row Set Rng = Range("b1:b" & lr) Debug.Print Rng.Address For Each cell In Rng If Left(

Re: $$Excel-Macros$$ week based time-sheet Using master tracker

Hi Sandeep, Elaborate more. What kind of output you want...! Regards Ashish -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accu

RE: $$Excel-Macros$$ Copying existing Address from column "B" to column "A" Using IF statement ( I think).

Hi Pankaj Sharma, Thank you very much for your help and effort, your code works great! One additional thing is how do I get rid of the word “Establishment” in Column “A” just leaving the address without the word Establishment. If you can help with that I would really appreciate it. Tha

$$Excel-Macros$$ week based time-sheet Using master tracker

hello guys i have to create week based time-sheet from master attendance tracker Pls help.PFA for Week 1 Sample. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ Copying existing Address from column "B" to column "A" Using IF statement ( I think).

Hi MIke,,,check this!!! On Sat, May 2, 2015 at 1:12 AM, Mike B wrote: > I would like to copy this for each location and paste in front inventory > numbers in Column "A"(some begin with letters) and also in front of the > Establishment Totals: VC Count. > > Then I would like to Remove the Word "E

Re: $$Excel-Macros$$ Macro to Copy sheets and filter from on Workbook to multiple Workbook

Paul, I used Office 2010. I know basic of macros like recording the macro, editing the macros. that's it. regards, Sridhar On Friday, May 1, 2015 at 4:47:23 PM UTC+5:30, Paul Schreiner wrote: > Do you have any experience with macros? > > What version of Excel do you use? > (I notic

Re: $$Excel-Macros$$ Macro to Copy sheets and filter from on Workbook to multiple Workbook

Hi Paul, I don't know what answer you are expecting from me I can understand the written Macro codes but cant write on my own. What I attached is the ordinary excel files without macros. I need you experts to write the macro codes as illustrated in the file. I request your help here. Yo

$$Excel-Macros$$ Exact Search excluding fractions

Dear Experts, I am trying to use (SEARCH and Vlookup) formula to filter out selected data from large database. Sample is attached. When I want to Search 2” ( " means Inch ), current formula brings text items containing 2” and non-related items like 1/2", 1 1/2", 2 1/2", 12”, 22” etc. When I want