Hi Friends,
Need help with Index Match for getting multiple values based on multiple
criteria.
Please see attached file.
Any help will be appreciated.
Regards,
AJ
--
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 o
Hi Team,
I need help on Percentage based on the condition.
Units Amount Rate Answer
851400 7821722 7.021,05,496.560 If A2 is >10 and up to 100 then
((A2-10)* 2%)*C2 discount on the amount
Now for next up to 500 units percentage will be 1.5% and for units in
excess of 500 u
Kindly help on the said issue.
Thanks!
On Mon, Sep 24, 2018 at 5:31 PM vikas khen wrote:
> Hi All,
>
>
>
> Kindly find the attached two sheets, based on the same I need Conditional
> formatting formula to highlight the cell value in color it the given
> criteria matches. I have mentioned the c
Hi All,
Kindly find the attached two sheets, based on the same I need Conditional
formatting formula to highlight the cell value in color it the given
criteria matches. I have mentioned the criteria in the Book 1.
Your help in the regards will be highly appreciated.
--
Are you =EXP(E:RT) or
*Regards,*
*For quick responds click here for Message *
On Mon, Feb 12, 2018 at 9:31 AM, Ruchin Gupta
wrote:
> I have a table where data changes continously (stock market data). I want
> to apply IF formula. please understand with given example.
>
> A1 = 10
> B1 = 20
> C1 = 5
> D1 = where i w
I have a table where data changes continously (stock market data). I want
to apply IF formula. please understand with given example.
A1 = 10
B1 = 20
C1 = 5
D1 = where i want to put formula.
Now the value of A1 keeps changing. I want that if A1>B1, it shld write
"Buy" in D1 cell. Similarly if A1
Hi All,
Below is my macro code to get the items from my pivots present in different
sheets.
Sub somename()
Dim pt As PivotTable, pt2 As PivotTable, pi As PivotItem, pi2 As PivotItem,
pf As PivotField, pf2 As PivotField, pf3 As PivotField
Dim pf4 As PivotField, pi3 As PivotItem, pi4 As PivotItem
On Tue, 6/20/17, 'Liberty Stringer' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same
workbook
To: excel-macros@googlegroups.com
Date: Tuesday, June 20, 2017
On Tue, 6/20/17, 'Kenyatta Freed' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same
workbook
To: excel-macros@googlegroups.com
Date: Tuesday, June 20, 201
On Tue, 6/20/17, Mustapha LMIDMANI wrote:
Subject: Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same
workbook
To: "excel-macros"
Date: Tuesday, June 20, 2017, 1:19 PM
I have fixed N° of
product and fixed N° of
I have fixed N° of product and fixed N° of customers.
It would be great if I can modify customer and product list in separated
sheet if I want to add or remove something :)
Many thanks Paul
Regards
*LMIDMANI Mustapha*
*Industrial engineer*
lmidmani.musta...@gmail.com
P Be green – leave it on t
If you can give me a larger sample of data, I can try to work on
something.Since it sounds like you have no background with VBA programming,
I'll try to develop an Excel-Function solution.
Paul-
“Do all the good you can,
By all the means you can,
In all th
adjective: dynamic1. (of a process or system) characterized by constant change,
activity, or progress.
That's why I defined the meaning in my question:
How "dynamic" is your data?Is the number of Products variable or fixed?is the
number of Customers variable or fixed?
Meaning, does the number of
Sorry Paul, I didn't get what you mean by "dynamic".
Regards
*LMIDMANI Mustapha*
*Industrial engineer*
lmidmani.musta...@gmail.com
P Be green – leave it on the screen
*NOTICE:* This privileged and confidential email is intended only for the
individual or entity to whom it is addressed. With regar
That didn't answer my questions. Paul-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
---
Hi dears,
Thanks for your feedback guys.
Paul: sheets are filled weekly (manually). and the dashboard have to
reflect data on sheets by selecting Customer and month
thanks in advance
Regards
*LMIDMANI Mustapha*
*Industrial engineer*
lmidmani.musta...@gmail.com
P Be green – leave it on the scre
There's not enough information for me to guess how you want the summary
populated.
How "dynamic" is your data?Is the number of Products variable or fixed?is the
number of Customers variable or fixed?
Paul-
“Do all the good you can,
By all the means you c
On Sun, 6/18/17, Rajan Verma wrote:
Subject: Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same
workbook
To: excel-macros@googlegroups.com
Date: Sunday, June 18, 2017, 7:09 PM
countif, sumif,
sumproduct can do this
On Sun
countif, sumif, sumproduct can do this
On Sun, 18 Jun 2017 at 9:23 PM, Mustapha LMIDMANI <
lmidmani.musta...@gmail.com> wrote:
>
> Hi Guys,
>
> I'd like to know if there is any possibility with functions to fill my
> Summary sheet from montly report sheet in the attached sample. or I need to
> cr
Hi Guys,
I'd like to know if there is any possibility with functions to fill my
Summary sheet from montly report sheet in the attached sample. or I need to
create a macro?
By selecting Customer and month (Blue cells) filling the indicator .
If I have to code a macro, can somone help me ?
Thanks
On Thu, 6/8/17, Mustapha LMIDMANI wrote:
Subject: Re: $$Excel-Macros$$ Need Help: Summary data from sheets in the same
workbook
To: "excel-macros"
Date: Thursday, June 8, 2017, 11:18 AM
Hi,
Can somone help on
my issue please .
Hi,
Can somone help on my issue please .
On 6 June 2017 at 10:50, Mustapha LMIDMANI
wrote:
> Hi Guys,
>
> I'd like to know if there is any possibility with functions to fill my
> Summary sheet from montly report sheet in the attached sample. or I need to
> create a macro?
>
> By selecting Cus
Hi Guys,
I'd like to know if there is any possibility with functions to fill my
Summary sheet from montly report sheet in the attached sample. or I need to
create a macro?
By selecting Customer and month (Blue cells) filling the indicator .
If I have to code a macro, can somone help me ?
Than
Thank you Paul, I've got a huge mental block on this type of expression. I
appreciate the help!
On Friday, June 2, 2017 at 11:56:24 AM UTC-4, Paul Schreiner wrote:
>
> Let's say that you have 100 rows of data.
>
> "bottom" ends up being 100.
> so your Rows statement results in:
> Rows(R:100).in
Let's say that you have 100 rows of data. "bottom" ends up being 100.so your
Rows statement results in:Rows(R:100).insert shift:=xldown
I think it needs to beRows(100:100).insert shift:=xldown
so you'd use:Rows(r & ":" & r).Insert Shift:=xlDown
Paul-
“Do all
Trying to insert a blank row between each line. The line starting with:
Rows is getting a type mismatch error.
-
Dim bottom As Integer
Dim r As Integer
bottom = Cells(Rows.Count, "A").End(xlUp).Row
For r = bottom To 2 S
PFA Solved question..
On Thu, Jun 1, 2017 at 7:50 PM, Secret Shot wrote:
> Dear Team,
>
> I have one very large excel table which i made from Raw data, accidentally
> raw data has been deleted and the only option i have is that table to
> convert back in raw data.
>
> Its about my job so pls hel
On Fri, 6/2/17, 'Yu Spain' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Need help in Macro to convert table into dump.
To: excel-macros@googlegroups.com
Date: Friday, June 2, 201
On Thu, 6/1/17, 'Martin George' via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Need help in Macro to convert table into dump.
To: excel-macros@googlegroups.com
Date: Thursday, June 1, 201
Thanks Paul, This is exactly what i was needed. you are a life saviour
On Thu, Jun 1, 2017 at 11:34 PM, Paul Schreiner
wrote:
> In THAT case:
>
> If you name a range "Result" and have it include the "summary" table
> without the column headings or phone numbers
> B4:G9 in your sample
>
> Then, n
In THAT case:
If you name a range "Result" and have it include the "summary" table without
the column headings or phone numbersB4:G9 in your sample
Then, name a range called "Data" that includes the original "Data" without the
column headingsL4:M1000 in your example.
Then you can use a macro like
Dear Paul,
I appreciate your quick response, However when i say raw data it means just
simple table in Excel which i have shown in attached excel sheet only in
column L and M.
So you can consider it as requirement or data rearrangement from table 1
(Column A to G) to table 2 (Column L to M).
I h
On Thu, 6/1/17, Paul Schreiner wrote:
Subject: Re: $$Excel-Macros$$ Need help in Macro to convert table into dump.
To: "excel-macros@googlegroups.com"
Date: Thursday, June 1, 2017, 4:47 PM
There
is no standard format for &qu
There is no standard format for "Raw Data".It depends on the original
Application used to CREATE the source of data.Some systems output ASCII (text)
files Some are tab delimited.Others are comma delimited (csv).
The mechanism you used to read in the "raw data" used known characteristics of
the d
Dear Team,
I have one very large excel table which i made from Raw data, accidentally
raw data has been deleted and the only option i have is that table to
convert back in raw data.
Its about my job so pls help, i have attached of the sample of what i am
talking about. if anyone can me in writing
Hi Paul,
The macro for this one is not working.
Can you please share your file with macro. So i can compare with my file.
I am getting error message the data cannot be pasted as shape and size are
not same.
Regards,
Kaushik
On Wednesday, May 24, 2017 at 4:29:56 PM UTC+5:30, Paul Schreiner wro
What isn't working?What does your code look like?
I put random numbers in 100,000 cells in Book1.xlsbThen, in Book2, I put
100,000 cells with links to the corresponding cell in Book1.
I then created a macro module with:Option ExplicitSub RemoveLinks()
Dim aLinks, inx
aLinks = ActiveWorkbo
Hi Paul,
The code is not working.
Can you please provide full code starting with Sub...till End sub
Regards,
kaushik Savla
On Wed, May 24, 2017 at 12:42 AM, Paul Schreiner
wrote:
> If you also want to get rid of the "internal" links and formulas, you can
> make use of the fact that, for a giv
On Tue, 5/23/17, Paul Schreiner wrote:
Subject: Re: $$Excel-Macros$$ Need help in Vba Macro
To: "excel-macros@googlegroups.com"
Date: Tuesday, May 23, 2017, 9:53 PM
That's
very CPU intensive because it copies all cells to th
Wow. This is what actually I require.
I will test in my file.
Thanks a lot.
On May 24, 2017 00:43, "Paul Schreiner" wrote:
> If you also want to get rid of the "internal" links and formulas, you can
> make use of the fact that, for a given cell, the VALUE of the cell is what
> is displayed, wh
If you also want to get rid of the "internal" links and formulas, you can make
use of the fact that, for a given cell, the VALUE of the cell is what is
displayed, while the FORMULA of the cell is just that, the formula.
For cells with a simple value, like "3", then the formula and value are nearl
This is think will definitely help.
Thanks.
On May 24, 2017 00:23, "Paul Schreiner" wrote:
> That's very CPU intensive because it copies all cells to the clipboard
> and pastes them from clipboard.
> which can be a HUGE number of cells for each sheet.
>
> If you simply want to break the externa
That's very CPU intensive because it copies all cells to the clipboardand
pastes them from clipboard.which can be a HUGE number of cells for each sheet.
If you simply want to break the external links, you can use something like:
alinks = ActiveWorkbook.LinkSources(xlExcelLinks)
If Not IsE
Hi Team,
I am trying to do below in an excel. You can assume there are 60 worksheets
minimum in a workbook.
1. In opened excel file. Which has links from several files
2. All cells of the workbook I am doing paste special values
3. Then to come at the first cell in all worksheets (i.e. Cell A1)
Any hope on this _
Regards,
Vikken
On Wed, Mar 29, 2017 at 3:18 PM, vikas khen wrote:
> Hi Team,
>
> Kindly find the attached sheet. In this sheet in need actual value in stud
> of 1. hence kindly assist me on this.
>
> Regards,
> VikKhen
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?
Hi Team,
Kindly find the attached sheet. In this sheet in need actual value in stud
of 1. hence kindly assist me on this.
Regards,
VikKhen
--
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
You can create a Worksheet_Change event.check to see if the cell changed
(Target) is the cell with your pull-down selection, then process accordingly:
Private Sub Worksheet_Change(ByVal Target As Range)
If (Target.Address = "$A$4") Then
Debug.Assert False
End If
End Sub
Paul--
Dear Experts,
Please help to resolve below requirement.
File attached for reference.
*Numbers .: 1,054,265*
*Result Shows .: *Ten Lakh Fifty Four Thousand Two Hundred Sixty Five
Rupees Only
*Required format .: *Ten Lakh Fifty Four Thousand Two Hundred *and *Sixty
Five Rupees Only
Than
Hi all,
I'm stuck trying to find the correct method to auto-populate a range of
cells based on a selection. See the image below. When a teacher selects
the subject from the list (cell A4), a list of standards (A5:A9)
automatically paste below. What's the best method to accomplish this?
Hi Team Any update regarding on the same??
Regards,
On Mon, Dec 19, 2016 at 9:51 AM, vikas khen wrote:
> Hi all,
>
> Good Morning!!!
>
> Team, need help for pooling data from Outlook2016 mails (Which is I kept
> in the one folder) to Excel Sheet in Desired format.
>
> my mail contains followin
Hi all,
Good Morning!!!
Team, need help for pooling data from Outlook2016 mails (Which is I kept in
the one folder) to Excel Sheet in Desired format.
my mail contains following data in table format wich I need to export in
excel sheet in the same manner. It would be very helpful if you could gui
Hi,
I need to calculate final billing product of several product with
respective MRP.
sample file is attached.
Regards,
Deepak
--
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.c
Want to excel formula on this
Regards,
Mohd Sadiq
On Nov 21, 2016 6:54 PM, "Paul Schreiner" wrote:
> OK, I'd need a bit more information.
> I can make LOTS of assumptions, but I'd rather not do this multiple times.
>
> So, for each row of data, you want to determine the FIRST column
> containi
OK, I'd need a bit more information.I can make LOTS of assumptions, but I'd
rather not do this multiple times.
So, for each row of data, you want to determine the FIRST column containing WO
and the LAST column containing WO.
Are you wanting to use VBA or Excel functions?
A simple function would
Team ,
Pls update on this
On Sat, Nov 19, 2016 at 2:00 AM, Mohd Sadiq wrote:
> Team , I have data where I want to first date of "WO" and last date of
> Week off in a week.
>
> attached is the excel sheet for your reference.
>
> Pls treat it on priority
>
>
>
> Regards
> Mohd Sadiq
> 979223
Team , I have data where I want to first date of "WO" and last date of Week
off in a week.
attached is the excel sheet for your reference.
Pls treat it on priority
Regards
Mohd Sadiq
979223
--
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)
Thanks for Help
On Tuesday, 11 October 2016 10:00:45 UTC+5:30, De Premor wrote:
>
> Try this one !
>
> [dp]
>
> On 10/10/2016 19:46, sonur...@gmail.com wrote:
>
> Hi
>
> I need help for separate data through VBA.
>
> My Data is below type..
> sku Size
> 10307963 XS,S,M,L
> 103
Use this Man
Sub SplitTest()
Dim VarArrayAs Variant
Dim LngRAs Long
Dim LngCAs Long
Dim LngIndexAs Long
Dim VaresultAs Variant
LngIndex = 1
VarArray = Intersect(Sheet2.Range("A1").CurrentRegion,
Sheet2.Range("A1").CurrentRegion.Offset(1))
Hi Try below VBA code
Option Base 1
Sub rr()
For Each r In Range("b2:b" & Range("b9").End(xlUp).Row)
x = Split(r, ",")
For t = LBound(x) To UBound(x)
Range("h9").End(xlUp).Offset(1).Value = Cells(r.Row, 1)
Range("i9").End(xlUp).Offset(1).Value = x(t)
Next
Next
End S
Try this one !
[dp]
On 10/10/2016 19:46, sonuraj1...@gmail.com wrote:
Hi
I need help for separate data through VBA.
My Data is below type..
sku Size
10307963XS,S,M,L
10307973XS,S,L
10307978XS,S,M,L
10307979XS,S,L
10307980XS,S,XL
10307981XS,S,M,L
10307984XS,M,
Hi
I need help for separate data through VBA.
My Data is below type..
sku Size
10307963 XS,S,M,L
10307973 XS,S,L
10307978 XS,S,M,L
10307979 XS,S,L
10307980 XS,S,XL
10307981 XS,S,M,L
10307984 XS,M,L
Need this type data in result.
skuSize
1030796
HI Manju,
See this help you
--
On Sat, Aug 27, 2016 at 11:33 AM, Manju Deva wrote:
> Hi
>
>
>
> I need your help to create a macro for the below mentioned scenario.
>
>
>
> *Scenario*
>
>
>
> We need two columns namely User, drop down
>
>
>
> *“IF user enter data in User column(cells) a automa
Hi
I need your help to create a macro for the below mentioned scenario.
*Scenario*
We need two columns namely User, drop down
*“IF user enter data in User column(cells) a automatic drop down needs to
create in a column B*
*Else*
*No drop down required”*
*And the macro should ru
Hello Team,
Can someone assist me with the excel formula based on the criteria from B44
to B50, PFA the excel file.
Thanks in advance.
--
Indrajit
talk2indra...@gmail.com
Disclaimer:
This electronic message and any files transmitted with it are confidential
and intended solely for the use of t
HI ,
not sure but have you tried using the value "true" in vlookup, might as
well work out for you. sorry in advance i am not a pro at it just amateur.
thanks & regars
On Mon, Jun 20, 2016 at 4:59 PM, Paul Schreiner
wrote:
> It works fine on my file.
> However, I noticed in YOUR file, the Calc
It works fine on my file.However, I noticed in YOUR file, the Calculation
option is set to "manual".
(A "Calculate" reminder appears in the Status Bar.You have to hit an F9 to
calculate.
which means, when you copy the formula down the column, it retains the original
value until you recalculate.
Hi Paul,
Thanks for your quick reply, However your suggested formula is not working
correctly it shows "No Record Found" for all the records. Hence request you
to kindly help me on this.
Regards,
On Sat, Jun 18, 2016 at 12:50 AM, Paul Schreiner
wrote:
> You're looking for a function like:
> =
You're looking for a function like:=IFERROR(VLOOKUP(F2,D:D,1,FALSE),"No Record
Found") Paul-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long
Hi Paul,
Please find the details in the attached sheet.
Regards,
Vik
On Fri, Jun 17, 2016 at 5:53 PM, Paul Schreiner
wrote:
> What array are you talking about?
> Your file says:
> "If E2 value is in Array then it should reflect in F
> otherwise count as a not found"
>
> So, since column E is
What array are you talking about?Your file says:"If E2 value is in Array then
it should reflect in F otherwise count as a not found"
So, since column E is labeled as "id", then I suspect you want to look in an
array of ID's.The only other ID heading is column "B" which is "Employee Id"But
those
Please Help me on this _
On Jun 17, 2016 14:43, "vikas khen" wrote:
> Hi Team,
>
> Need your help on finding the value in attached sheet.
>
> Request all of you to kindly help me on this
>
> please find attached sheet for the reference.
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And
Hi Team,
Need your help on finding the value in attached sheet.
Request all of you to kindly help me on this
please find attached sheet for the reference.
--
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 for
Hi,
I hope there is a VBA pro that can help me with a timer issue.
I am responsible for building and upgrading a spreadsheet that manages our
warehouse workflow. In every other column (as you can see in the attached
worksheet) underneath the routes, I have listed the order numbers that will
b
I am looping thru and getting a count of values in an array for a specific
user in a single row range. I switch to another range and add in the value
fro that rnage
Here is the code:
If Evaluate("ISREF('" & "Game" & i & "'!A1)") Then
Set ws = ThisWorkbook.Sheets("Game" & i)
Since I don't know anything about your workbook or the types of values, I'd
suggest something like what follows.I've run into issues where Excel doesn't
treat a "null" value and a "blank/empty" cell as the same.Plus, when using
something like: wshD.Cells(r, "C")the "default" property is "value",
Hello,
I have formulated a macro to search data, from a worksheet, using user
forms. User form has Date picker and couple of comboxes. Idea is to search
between two dates along with two criterias.
My problem is, macro doesnt function if I do not enter all the search
criterias. Ideally, it sh
Hello all!
Please I need macro help with the below in red:
What is the best way to achieve this without using the formula that I got
from running the macro and also making the code short? I have already
completed the Sum in column AH
1.
Column AI to the last row should hav
Good Evening Experts,
I am stuck in a very big problem,
In Attached file, I have some data in RAW data file and I want to
distribute that data in all the other sheets basis on Wave name date and
employee name.
Sheet would be different basis on WAVE mean. for example data for Wave 1
need to go
.Value
End With
Next rw
End Sub
*Pankaj Sharma *
*MIS Analyst*
*Greater Kailash-1, New Delhi*
*Email *
*p ankaj123...@gmail.com *
*Skype** pankaj.sharma_pj*
-- Forwarded message --
From: vikas khen
Date: Thu, Dec 24, 2015 at 7:
Dear Team,
Please find the attached excel sheet in which the raw data is sheet 1 and
the required output is in Sheet 2.
It would be very helpful if you help me on this.
Regards
--
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 Fa
>
> Here is attached two files , install the addin windatepicker.xlam first
>> and then run that Att file, Double click on date which u want to select.
>
>
Regards,
Mandeep baluja
--
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 offici
Hi All,
Expecting your valuable reply on this _
Regards,
V!kas
On Dec 3, 2015 12:32 AM, "vikas khen" wrote:
> Hello Everyone,
>
> Please find the above attached sheet in which i need your help on the
> below said points.
>
> 1) When i click on date the Date-picker should be popup and when i sel
Hello Everyone,
Please find the above attached sheet in which i need your help on the below
said points.
1) When i click on date the Date-picker should be popup and when i select
the date it should enter only in cell *E6.*
2) All column of Saturday and Sunday needs to be highlighted in color
alt
Requirement:
1. I have a Excel sheet contains XML file names on the column A.
2. Need to get the xml file name from the excel sheet column A cell and
find the *.xml file in folder "C:/"
3. and extract the specified node from the XML file into column C to G on
the corresponding row
I am very n
Thank you DP
Your explanation was extraordinary. In addition to solve my problem, you taught
me a lot! ;)
Thank you very much again
Regards
Isabel
On Monday, September 14, 2015 at 7:37:57 PM UTC-5, De Premor wrote:
>
> Hi Isabel,
>
> I'am glad that its work, ok here is the problem in out 2nd
Hi Isabel,
I'am glad that its work, ok here is the problem in out 2nd case
1st, we need to step back to learn about how the function work,
cpearson.com have a bunch article about this complete with explanation &
sample, you can follow this link
*http://www.cpearson.com/excel/optionalargumentst
Thank you DP!
Thank you very much for your help. It worked perfectly.
However, I tried to do the same in Calculation2 sheet, but inserting rows
instead of columns and it did not work the same logic. It gives me a syntax
error.
Could you help me fix this?
I used:
Dim v As Integer
v = Range("Mont
We can avoid using loop in this case, try to replace your looping code
with offset and resize, try this another solution
Dim u As Integer
u = Range("Months").Value - 1
If u > 1 Then
Range("ColumnLong").Resize(, u).Insert
Range("ColumnFormula").Copy
Range("ColumnLong").Offset(, -u).R
Hello Ashish,
Thank you for your response.
This is a simplified copy of my macro. The lines you can find there are
repeated
multiple times in my final workbook, in different spreadsheets because it
has a broader mathematical formulation.
Hope this helps,
Regards
On Saturday, September 12, 201
Can u pls share a sample file
On Sep 12, 2015 9:38 PM, "Isabel Cristina Ortiz" wrote:
> Thank you Basole for your message!
> I have been already using your recommendation on my code, but it still
> takes a lot of memory.
>
> Regards,
> Isabel
>
>
>
> On Saturday, September 12, 2015 at 9:20:05 AM
Thank you Basole for your message!
I have been already using your recommendation on my code, but it still
takes a lot of memory.
Regards,
Isabel
On Saturday, September 12, 2015 at 9:20:05 AM UTC-5, Basole wrote:
>
> Hi isabel, try using "Application.ScreenUpdating = False" To Turn Off at
> th
Hi isabel, try using "Application.ScreenUpdating = False" To Turn Off at
the start of code. and "Application.Calculation = xlCalculationManual" To
turn off the automatic calculation
at the beginning of the code
see example:
Dim u As Integer, v As Integer
u = Range("Months").Value - 1
Application.S
Hello,
I have been working on a workbook. It is a cash flow and macro helps me to
change the numbers of years (columns) because each project needs different
time periods.
What I do is that I have two columns named as "ColumnLong" and
"ColumnFormulas". The first one is empty and only serves as a
Hi Friends,
The scenario is :
We are getting a file daily containing cumulative numbers till date.
The task is:
to subtract numbers in today's file from yesterday's file to get daily
numbers.
The file format is simple : Category(String), total(Int).
This seems pretty simple but I am not able
you can,By all the means you can,In all the ways you
>>> can,In all the places you can,At all the times you can,To all the people
>>> you can,As long as ever you can.” - John Wesley*
>>> -
>>>
>>>
; -
>>
>> --
>> *From:* Nasir Shaikh
>> *To:* excel-macros@googlegroups.com
>> *Sent:* Wednesday, August 5, 2015 7:34 AM
>>
>> *Subject:* Re: $$Excel-Macros$$ Need help to split numbers a
-
> *From:* Nasir Shaikh
> *To:* excel-macros@googlegroups.com
> *Sent:* Wednesday, August 5, 2015 7:34 AM
>
> *Subject:* Re: $$Excel-Macros$$ Need help to split numbers available in
> the last
>
>
> KEY=55a65c4efb80535a8efd001eee190a4795a02acc&a
-
From: Nasir Shaikh
To: excel-macros@googlegroups.com
Sent: Wednesday, August 5, 2015 7:34 AM
Subject: Re: $$Excel-Macros$$ Need help to split numbers available in the last
KEY=55a65c4efb80535a8efd001eee190a4795a02acc&CLIENT=f090d7af-c960-0296-
” - John Wesley
-
From: Paul Schreiner
To: "excel-macros@googlegroups.com"
Sent: Wednesday, August 5, 2015 7:24 AM
Subject: Re: $$Excel-Macros$$ Need help to split numbers available in the last
For MOST of the data, you could use an excel function like:
=TRIM(RIGHT(TRIM(A3),
ll the ways you
> can,In all the places you can,At all the times you can,To all the people
> you can,As long as ever you can.” - John Wesley*
> -
>
> --
> *From:* Paul Schreiner
> *To:* "excel-macros@google
1 - 100 of 992 matches
Mail list logo