s anyone tried to do something like this?
2. Are my assumtions correct or should I try something different? In Excel
that is. I know some might say I need to transfer this to proper
application as it is too complex, but I ran out of time for 2014:(
Thank you for your help. Any ideas are most we
Actually no, because I want the copied values in a list w/o blanks.
regards
seba
Dne petek, 21. junij 2013 13:15:16 UTC+2 je oseba Vabz napisala:
>
> Superb!!
>
> I assume you need to increment target by 5 too, coz u r copying 5 rows.
>
> Thanks
>
>
> On Fri, Ju
ection.Copy
Range("C" & target).Activate
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone,
SkipBlanks _
:=False, Transpose:=True
coordS = coordS + 5
coordF = coordF + 5
target = target + 1
Next
End Sub
kind regards
Hi,
can someone please advise how to parse a column in excel, so that every 5
rows would be a selection, which I can then copy and further manipulate?
Thank you.
Kind regards,
Seba
--
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
I can't thank you enough:)
It works like a charm!
best regards,
seba
On 5 jan., 14:07, NOORAIN ANSARI wrote:
> Dear Seba,
>
> Please see attached sheet, Hope it will help you
> otherwise pls share your workbook with group.
>
>
>
>
>
>
>
>
>
> On T
em User
---
So, I would like to enter the sistem in the inputbox and get the
corresponding user back in the msgbox.
Thank you for your help.
regards,
seba
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Pleas
Hi guys,
thank you very much for your help.
You solved my problem and thank you for different posibilities from
which I can learn.
Best regards,
seba
On 10 nov., 18:21, Sam Mathai Chacko wrote:
> Two options try
>
> If Not IsEmpty(Range("A1")) Then
>
e = 8
End If
End Sub
I also tried
Sub testPogoja()
If IsEmpty("A1") = True Then
Exit Sub
Else
Range("B5").Value = 8
End If
End Sub
and no luck.
What am
How can I fix this formatting issue or maybe in a more efficient way
select the required range for desired month?
Thank you for your help.
seba
--
--
Some important links for excel users:
1. Follow us on TWITT
I decided to go with Sam's suggestion, it suites me more. I would like
to thank you both on such prompt help.
Regards,
seba
On 5 okt., 19:37, Sam Mathai Chacko wrote:
> If you need prompts, and if the files are in different folders, then
> Application.GetOpenFileName (my earlier c
ot;sourcesheet").QueryTables.Add(Connection:= _
> "TEXT;Path to my file" & I &".csv", Destination:=
> sheets("sourcesheet).range("a1")
> 'etc
> copy range("a2:z4") sheets("destinationsheet").range("a1"
Hi all,
I have to import data from 3 different files into 1 and format the
data. Since everything is more or less fixed, I have recorded the
macro below and removed the code for scrolling and such. The only
problem for me is that each month the locations and filenames of the
files to import are ch
Hi Paul,
thank you again!!! It works perfectly:)
Best regards,
seba
On 29 sep., 15:32, Paul Schreiner wrote:
> Evidently, the Target array doesn't start at '0' like normal arrays!
>
> change the loop to:
> For inx = 1 To Target.Count
>
> and it
you can.” - John Wesley
> -
>
>
> From: Amresh Maurya
> To: excel-macros@googlegroups.com
> Sent: Thu, September 29, 2011 8:42:48 AM
> Subject: Re: $$Excel-Macros$$ Audit Trail
>
> Guys,
>
> you have
Hi Paul,
thank you very much for aour effort. There is just one thing: I paste
2 values in S14 and S15 and the macro records values in S13 and S14.
Cold you please help.
regards,
seba
On 29 sep., 14:15, Paul Schreiner wrote:
> The trick here is knowing that when target.count > 1, th
End If
Close #1
End Sub
This does the job, but I would like to have all values logged when
multiple cells are changed.
Lets say I paste a range. In the log file
Hi, I should have written thank you both!
regards,
seba
On 11 sep., 23:04, Seba wrote:
> Sam, thank you very much for your help and efforts.
>
> Works like a charm. You just made my monday easier:)
>
> regards,
> seba
>
> On 11 sep., 22:55, Sam Mathai Chacko wrote:
&g
Sam, thank you very much for your help and efforts.
Works like a charm. You just made my monday easier:)
regards,
seba
On 11 sep., 22:55, Sam Mathai Chacko wrote:
> Solution already posted D. Could you confirm this was not visible in the
> forum? If so, then I'd like the moderator
d paste this a thousand times:)
And if possible, I would only like to enter the last three digits as a
value: just 001 and not the full name 2011_001.
Thank you and best regards,
seba
--
--
Some important links for e
to G56:66
---
thx and regards,
seba
On 11 avg., 17:10, "Rajan_Verma" wrote:
> See if it helps
> After select the Range which need to be Copies Press Alt+F8 and Run the
> Macro Show,
>
>
>
>
>
>
>
> -Original Message
es are not overwritten.
Example for target range LEGAL:
columns from A56:66 to G56:66
the problem for me is to get the excel to prompt me to select the
target workbook and gather the parameters for pasting.
Thx a lot,
seba
On 10 avg., 20:53, "dguillett1" wrote:
> Post a file with a mo
hi,
I need help with writing a macro which would copy selected range and
prompt me for target workbook, sheet and range. It would need to copy
only values and transpose them.
any help is greatly appreciated.
Regards,
seba
heet.Range("D100").End(xlUp))
Do
Set a = SrchRnga.Find("0", LookIn:=xlValues)
If Not a Is Nothing Then a.EntireRow.Delete
Loop While Not a Is Nothing
End Sub
--
regards
seba
On 2
Hi,
I need further assistance on this matter.
After I create a database, how can I delete entire rows where cell in
column C (C2, C3,) equals 0?
thank you in advance,
seba
On 28 jan., 15:33, ashish koul wrote:
> alright let us know if you require any help
>
> On Fri, Jan 28, 201
("A" & z).Select
***Selection.PasteSpecial
Paste:=xlPasteValues**
ActiveWorkbook.Save
ask2.Activate
ask2.Close
End If
Next i
'abc:
'Exit Sub
Application.DisplayAlerts = True
End Sub
.Select
Range("A1").Select
ActiveCell.SpecialCells(xlLastCell).Select
z = ActiveCell.Row + 1
Range("A" & z).Select
ActiveSheet.Paste
ActiveWorkbook.Save
ask2.Activate
ask2.Close
End If
Next i
'abc:
'Exit Sub
Application.DisplayAlerts = True
End Sub
--
macro with removing duplicates and I should
have database setup in no time:) thanks to you.
regards
seba
On 27 jan., 11:40, ashish koul wrote:
> hi
>
> try this code if the sheets postion or names are fixed from which data is to
> be merged in all workbooks
> then simply change
this macro once per month I guess there would be double
or triple entries and so forth for the same workbook in the database.
I guess one workaround is to manually delete the files that have
already been merged from the list the macro makes.
But can this be done automatically?
Thank you.
regards,
Thank you very much. This is a lifesavior for me.
And I would be very grateful if someone could explain how to attach a
sample workbook or any file for that matter. I don't see any option
for that.
regards,
seba
On 26 jan., 17:12, roberto mensa wrote:
> try
>
> Sub test(
are named for example: year_sequence_number: 2011_001;
2011_002, ...
Thank you all for your help.
regards,
seba
On 26 jan., 17:03, Paul Schreiner wrote:
> There are a several ways to accomplish this...
>
> Are all of the files in a single folder?
> Are there other files there?
>
eCell.FormulaR1C1 = "asdasda"
Range("F14").Comment.Shape.Select True
Range("F14").Comment.Text Text:="User:" & Chr(10) & "asdasda"
Range("G21").Select
End Sub
-
all this workbooks (and all new
ones I create) to a new workbook serving as a database.
However all columns allways contain some data, whereas the rows may
not. It could be the case that only the 1st row contains any data.
I hope this helps a bit.
Thank you for the help.
Best regards,
seba
On 17
you in advance.
Best regards,
seba
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com
33 matches
Mail list logo
