Hi Can you explain which data you want to put where? Or do you want
take all the details and paste in other sheet as it is?
On Feb 9, 4:52 pm, Karan Singh wrote:
> Dear all,
>
> I need your help in vba. I have to pick data from one work to another
> workbook's sheets. I'v attached format & the sa
Try this:
Below Code will popup an input box for you to enter the path of the
file and name and then it will automatically append the todays name
and save it as your given location.
-
ThisWorkbook.SaveAs InputBox("Enter the Path") & Day(Now) & "-" &
Month(N
gt; Would this be easier
> =A1 & 10 - MOD( SUMPRODUCT(MID(A1, {1,2,3,4,5,6,7,8,9,10,11}, 1) *
> {3,1,3,1,3,1,3,1,3,1,3}), 10)
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>
>
>
>
>
>
> -Original Message-
> From: Vishwamitra Mishra
> S
I have written a Formula and Macro to calculate all types of GTIN.
If you want that workbook, kindly let me know.
For more detail about the Formula and Macro kindly visit this link:
http://www.learnexcelmacro.com/2011/11/gtin-calculator-in-excel/
--
FORUM RULES (934+ members already BANNED for v
Hi All,
I have written a function to strip HTML from a String kept in a Cell.
How to use this UDF (User Defined Function), you can visit this link:
http://www.learnexcelmacro.com/2011/12/strip-html-how-to-remove-html-tags-from-a-string-in-vba/
-