>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Tue, Nov 11, 2014 at 2:56 AM, ivavok > wrote:
>
>> Great, thank you, Vabz! Yes, could be;)
>>
>> Dne neděle, 9. listopadu 2014 20:05:10 UTC+1 Vabz napsal(a):
>>>
you.*
>
> On Sun, Nov 9, 2014 at 11:49 PM, ivavok > wrote:
>
>> Hi,
>>
>> that´s perfect! Thanks. Just the comma is decimal not between thousands.
>> So the first figure should be 15 750,00 and not 1 575 000,00...How should I
>> change the macro so that
gt; Hi
>
> Try this, Run macro by clicking blue button, select range containing
> number when prompted!!
>
> You will get output as desired without help of any helper sheet.
>
> Cheers!!
>
> +
> *I did not do this for you. God is here working through me for you.*
>
&
Hi,
thank you, that´s perfect!
Dne neděle, 9. listopadu 2014 5:08:16 UTC+1 pramodb35 napsal(a):
>
> Hi Dear,
>
>
> Please find the attached file. Hope this will be fine for you.
>
> Regards
> Pramod
>
> On Sun, Nov 9, 2014 at 1:05 AM, ivavok
ttached file as your reference...
>
> On Sat, Nov 8, 2014 at 1:46 PM, ivavok > wrote:
> > Hi,
> >
> > I have tried it before too but it does not work. It does not delete "Kč"
> at
> > all...When I run my macro, I get the data in the table atta
number and "Kč" so use " Kč" instead.
>
> Cheers !!
> On Nov 7, 2014 8:15 PM, "ivavok" >
> wrote:
>
>> Hi,
>>
>> I would appreciate if you could help me with this macro:
>>
>> *Columns("C:C").Select*
>>
Hi,
I would appreciate if you could help me with this macro:
*Columns("C:C").Select*
*Selection.Replace What:="Kč", Replacement:="", LookAt:=xlPart, _*
* SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _*
* ReplaceFormat:=False*
*Selection.Replace What:=" ", Replac
Great, thank you!!!
Dne středa, 5. listopadu 2014 6:14:55 UTC+1 Vabz napsal(a):
>
> here you go...
>
> Cheers!!
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Wed, Nov 5, 2014 at 2:00 AM, ivavok > wrote:
>
>> Gre
;
> Check this, do let us know for further help.
>
> Cheers!
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Mon, Nov 3, 2014 at 12:47 AM, ivavok > wrote:
>
>> Hello,
>>
>> I would appreciate if you could help me
Hello,
I would appreciate if you could help me with this macro:
The macro should copy a text from a cell which can be one of these:
typ(1) = "Home/Rent"
typ(2) = "Utilities"
typ(3) = "Food/Groceries"
typ(4) = "Departmental"
typ(5) = "Entertainment"
typ(6) = "Car/Auto"
typ(7) = "Insurance/Medical"
omma are
deleted and then the number becomes higher;) e.g. 3000,00 EUR is finally
30 EUR;)
I would be really grateful if you could help me with these updates too..
Thank you in advance!
Ivana
Dne sobota, 25. října 2014 10:08:50 UTC+2 pramodb35 napsal(a):
>
> Hi ivavok ,
>
>
Hello,
I would be grateful for help. I have had some break using VBA and I now
need to get the table attached adjusted in a certain way to be able to work
with it later on:
1/ keep the first row with headings
2/ insert a new column after the first column and name it: Type
3/ always take the cont
Hi,
I would like to ask you how to import excel file into Microsoft SQL
server via Microsoft SQL server management studio. I have an excel
file with one sheet containing data and I need to import it into SQL
server.
Could you please help me?
Thank you
Ivana
--
Hello,
I need your help with VBA code. In one column I have several different
objects and I need to copy only one of these (11,20,30,60,61) into
another column.
I have prepared this code:
For counter = 0 To not_empty_cells
For counter_dep = 1 To 5
position = InStr(1, (Cells(counter
Hello,
could somebody help me with this please? In one column I have
different objects separated by a comma. I need to select one of these:
11,20,30,60,61 and copy it into another column. I have used this code:
For counter = 0 To not_empty_cells
For counter_dep = 1 To 5
position = I
Hello,
I would appreciate if you could help me. I have a file with rows where
some of them need to be deleted when column E is empty. However, there
are several blocks of not empty rows. Therefore, I need the code to be
repeated until column A is empty.
row = 3
column = 5
number_of_notempty_rows
16 matches
Mail list logo
