OMG,
I saw your mail on my mobile and was excited to see the file. And happy to see
that the output is what I wanted…
Thanks a lot……… a lot…..
But can you please explain that how you did this??? I can see that you have
written some VB programming and macros, but have you also used the w
I have solved first problem of inserting values into rows.
However I am still looking for way to add value in date format.
Here is updated code:
function replaceStringDate(e) {
var sheet = SpreadsheetApp.getActiveSheet();
var startRow = 2;
var lastRow = SpreadsheetApp.getActiveSheet().getLastRow(
to run macro, click blue button, on prompt select range with TIN no. and
press OK
+
*I did not do this for you. God is here working through me for you.*
On Thu, Oct 30, 2014 at 12:11 AM, Vaibhav Joshi wrote:
> Check this
>
> you will need to press enter when error appears or just disble
Check this
you will need to press enter when error appears or just disble IE dialogues.
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Sat, Oct 25, 2014 at 2:17 PM, B Sharma wrote:
> Dear Excel Gurus,
> I am trying to update my excel sheet which con
In that case, I have no idea what type of functions it has available.
In Excel, you could always use string manipulation to reformat the string
in a "valid" date/time format and put the string value in the cell.
then, you need to do something that would cause Excel to "evaluate" the value.
I us
Thanks Paul, this is google scripting for automating google
docs/spreadsheets. It uses Java Script.
On Wed, Oct 29, 2014 at 5:48 PM, Paul Schreiner
wrote:
> What programming language are you using?
> This seems to be a C++ format?
>
> I'm not sure how you were planning to do this.
> your functi
What programming language are you using?
This seems to be a C++ format?
I'm not sure how you were planning to do this.
your function was passing a variable (e)
but I don't see where you were using it.
Using VBA in Excel, I created a function:
Public Function ReplaceStringDate(Str) As Date
I have a column in which dates are saved in string format like this:
*"Tuesday, 18th November(11:00)" *
I want to take this string date and save its equivalent date in *Date
format* corresponding to its row in* new column (first empty column in
sheet)*, so that I can later compare that date with cu
Your description is somewhat confusing.
Are you saying that you want the combination of columns D,G,H to be unique?
For instance, rows 24,25,26 have
Vendor Group: ZM01
Credit Check Information Number 552654477 and
Name1: ABDELHADI - INTELLECTUAL PROPERTY
Does that mean that rows 24,25,26 sho
Dear Amit Sir,
Try It.
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, accurate thread titles. Poor thread titles,
Hi Amit Sir,
HW r u.
How many sheets you have in folder..?
Approx.
Revert awaited.
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 RUL
Dear Friends,
I have few files in a folder & from each file there is a specific sheet. I need
data from each of that specific sheet & compile them at one place.
Is there any solution?
Best Regards,
Amit Desai
Disclaimer: This message and its attachments contain confidential information
and may
12 matches
Mail list logo
