Re: $$Excel-Macros$$ Copy values to other worksheet column even if other cells in row contains data

2013-09-11 Thread georgebeegle22
> > PERFECT!!!Thanks so much for your assistance the last 2 days. I > appreciate it very much. > -- 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 RULE

Re: $$Excel-Macros$$ Copy values to other worksheet column even if other cells in row contains data

2013-09-11 Thread georgebeegle22
> > Explanation written on attached worksheet. Thanks for your time and > assistance. > -- 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 con

Re: $$Excel-Macros$$ Copy values to other worksheet column even if other cells in row contains data

2013-09-11 Thread georgebeegle22
> > Hi De Premor, > Thanks so much for the accurate information yesterday. We are currently using that for one of our workbooks. Yesterday, you nailed putting the value into the TOTALS worksheet in A1 and then each time the values were cleared and the macro was run again it replaced that va

$$Excel-Macros$$ Copy values to other worksheet column even if other cells in row contains data

2013-09-11 Thread georgebeegle22
Hi All, Got some great help yesterday from De Premor using VBA to copy data to other worksheets and then using next available row to copy again etc. It works like a charm. But I need some tweaking that I hope is possible. Scenario of worksheet "TOTALS" A B

Re: $$Excel-Macros$$ Copy Formula Answer to new sheet (next available cell) and REMAIN

2013-09-10 Thread georgebeegle22
> > Thank You much De Premor. Very much appreciated > -- 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, accurate thread titles. P

$$Excel-Macros$$ Copy Formula Answer to new sheet (next available cell) and REMAIN

2013-09-10 Thread georgebeegle22
Hi All, I have say a worksheet that is calculating cells A1:A9 with the Total being displayed in cell A10 I want the answer of the Sum Function in cell "A10" to be copied to cell "A1" in a different worksheet named say "TOTALS" Easy enough but here is what I want to be able to do: When the d