$$Excel-Macros$$ Re: automation of transfer of data from several sheets to one sheet

2017-06-20 Thread GENIUS
Hi Mr Pascal Thank you very much for you help, but there is slightly moving the row below the destination location, please see the attachment . -- 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 @

$$Excel-Macros$$ 达赖真的想回到中国吗?

2017-06-20 Thread 向天游
达赖真的想回到中国吗? 民智网 jackross 2015年5月,流亡藏人集团领袖之一第三世安曲活佛获得中国政府批准,返回四川阿坝定居。自此以后,一波又一波的流亡世界各地的藏人开始陆续申请回国。中国政府也对曾经从事分裂活动的藏人采取开放、包容的态度,对他们以往的罪恶既往不咎,让他们充分享受到伴随着中国改革开放后新藏区的富裕生活。

Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same workbook

2017-06-20 Thread Paul Schreiner
adjective: dynamic1. (of a process or system) characterized by constant change, activity, or progress. That's why I defined the meaning in my question: How "dynamic" is your data?Is the number of Products variable or fixed?is the number of Customers variable or fixed? Meaning, does the number

Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same workbook

2017-06-20 Thread Mustapha LMIDMANI
I have fixed N° of product and fixed N° of customers. It would be great if I can modify customer and product list in separated sheet if I want to add or remove something :) Many thanks Paul​ Regards *LMIDMANI Mustapha* *Industrial engineer* lmidmani.musta...@gmail.com P Be green – leave it on

Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same workbook

2017-06-20 Thread 'Kenyatta Freed' via MS EXCEL AND VBA MACROS
On Tue, 6/20/17, Mustapha LMIDMANI wrote: Subject: Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same workbook To: "excel-macros" Date: Tuesday, June 20, 2017, 1:19 PM

Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same workbook

2017-06-20 Thread Paul Schreiner
If you can give me a larger sample of data, I can try to work on something.Since it sounds like you have no background with VBA programming, I'll try to develop an Excel-Function solution.  Paul- “Do all the good you can, By all the means you can, In all

$$Excel-Macros$$ 皇帝的新衣:美国之音为何拉中国留学生给达赖站台?

2017-06-20 Thread 向天游
*皇帝的新衣:美国之音为何拉中国留学生给达赖站台?* *美国民主阵线评论员:曹青* 恶贯满盈的西藏前农奴主领袖、鼓吹封建农奴制的达赖喇嘛于 6月17日访问加州大学圣迭戈分校,并被校方邀请在台上发表了题为“你们有机会创造出一个更美好的世界,更快乐的世界”。 随即,美国之音欺世盗名的罔顾加州大学中国留学生联合会多次发表声明抗议校方邀请达赖喇嘛参与毕业典礼的事实,称中国留学生不认同但尊重达赖喇嘛的讲演。

Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same workbook

2017-06-20 Thread Mustapha LMIDMANI
Sorry Paul, I didn't get what you mean by "dynamic". Regards *LMIDMANI Mustapha* *Industrial engineer* lmidmani.musta...@gmail.com P Be green – leave it on the screen *NOTICE:* This privileged and confidential email is intended only for the individual or entity to whom it is addressed. With

$$Excel-Macros$$ Hot List Of R2Technologies

2017-06-20 Thread raju bakrewar
Hi Friends, Greetings for the day, Please find the list of skilled R2Technologies LLC consultants who are actively looking for new role and please share your requirements to ra...@r2techcorp.com S.No CANDIDATE SKILL SET EXPERIENCE LOCATION RELOCATION 1 Syed .Net Developer 8+ Plano,TX YES 2

Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same workbook

2017-06-20 Thread 'Kenyatta Freed' via MS EXCEL AND VBA MACROS
On Tue, 6/20/17, 'Liberty Stringer' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same workbook To: excel-macros@googlegroups.com Date: Tuesday, June

$$Excel-Macros$$ Re: automation of transfer of data from several sheets to one sheet

2017-06-20 Thread Pascal B
this needs to be changed: Range(ActiveCell, ActiveCell.End(xlUp).Offset(1, 0)).Value = SN and the macro needs to be changed to accomodate the change above, Sub CopyAll() Application.ScreenUpdating = False Dim cnt As Long Dim r As Range For i = 1 To Sheets.Count - 1 Sheets(i).Select SN =

$$Excel-Macros$$ Re: automation of transfer of data from several sheets to one sheet

2017-06-20 Thread GENIUS
HI FRIENDS AND BROTHERS PLEASE DO ME A FAVOR -- 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. Poor thread