Hi Team,
Need your help in formulating a macro in the attached file which will do
the following:-
1. there are many worksheets in the attached file
2. In the attached file, in each sheet data is coming from link in another
worksheet.
3. What I want to do is - I want one sheet to be inserted. In
Another Version:
Sub GenSN()
Dim Data, lRow As Long, lNum As Long, SrcData As Range
Set SrcData = ActiveSheet.Range(A:Z).Find(SNo).CurrentRegion
Data = SrcData.Value
For lRow = 1 To UBound(Data, 1)
lNum = lNum + 1
If Not IsNumeric(Data(lRow, 1)) Then lNum = 0
Wow !
It's epitome.
thank you so much De Premor.
On Wed, Oct 15, 2014 at 6:13 AM, De Premor d...@premor.net wrote:
Try this
=TRIM(MID(SUBSTITUTE($A15;|;REPT( ;99));(COLUMN(A1)*99)-98;99))
the idea is replacing a pipe char with 99 times white space using
SUBSTITUTE so we can trim it later
Hi,
PFA As Required.
Regards
Sanjai Kumar
On Saturday, October 11, 2014 10:19:47 AM UTC+5:30, Waseem Saifi wrote:
Hi Experts,
I have attached a file which contain text in cell A15. I want to split
this text by pipe sign [|] in cells next to cell A15.
Thanks in Advance.
Regards,
Technically, the sheets in your workbook don't contain links.
They're simple formulas.
If you have actual links (which is short for hyperlink) then the macro will
have to be modified.
There may be a better way of doing this, but this was the first that came to
mind.
Since I don't know what
Hi Experts,
Please suggest me best book for learning Microsoft Access.
I am good in Microsoft Excel, but 0 in Microsoft Access.
Thanks in advance.
Regards,
Waseem Saifi
--
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
Thank you very much Paul! Worked perfectly :-)
2014-10-14 16:39 GMT+02:00 Paul Schreiner schreiner_p...@att.net:
If you create a Public variable (in a Standard module, outside of any
macros)
Like:
public Cur_SysSep as boolean
then, in the beginning of workbook_open use:
cur_SysSep =
Hello Experts,
I have a query related to Google Doc Spreadsheet.
I have a Google Form whose data is saved in Online Google Docs Spreadsheet.
Data fields saved in Google Spread sheet are (column wise) : First Name,
Last Name, Email ID, Appointment Date.
I want to Automatically send Reminder email
Dear Paul,
Thanks for your formula. It worked everywhere except any day which worked
more than 12 hours. I have attached excel file after putting your formula.
Few days employee worked more than 12 hours. Eg. on 13rd February employee
came to office @ 9.00 am and returned next day of @ 5.00 am.
hey
check this..do let us know if you need any help further..
http://www.labnol.org/internet/auto-confirmation-emails/28386/
Cheers!!
+
*I did not do this for you. God is here working through me for you.*
On Wed, Oct 15, 2014 at 7:32 PM, Hasnain Basit smhasnai...@gmail.com
wrote:
Hello
hey
somehow not able to take time in preparing macro for you, emantime you can
use this code to consol your files do manually PVT.
Run macro select folder to import data directly...
Hope this helps // Cheers
+
*I did not do this for you. God is here working through me for you.*
On Tue,
The problem is with the way the times are entered.
We have a NUMBER that's being INTERPRETED as time.
But the same interpretation isn't always true.
In once case, 10.50 is interpreted as 10:50PM
in another case, 17.00 is interpreted as 5:00am of the next day.
Then there's a start time of
Attached is what I've done thus far.
Regards
On Wednesday, October 15, 2014 12:23:17 PM UTC-4, Awal wrote:
Hello,
With a Userform, I would like to search a database, display the result of
the search in the form and be able to print it out. See screen shot below.
I am attaching a sample
Paul,
I loaded all the available Begin Dates into the Begin Date combobox.
I created a change event in which when you select a begin date,
all the available dates AFTER that date are loaded into the End box
(no sense making it possible to select an end date that occurs BEFORE the
begin
I'm also new like you, and I'm doing the following for this purpose, I've
downloaded an ebook from torrent, the name of the book is MICROSOFT ACCESS
2013 BIBLE the following are the URL for downloading the book and exercise
files from the first one you may download the book and from the second
15 matches
Mail list logo