@ram2010
Meron akong four sheet na merong data na manually input , then meron akong isang isang sheet na nagcoconsolidate ng data nung apat na sheet using index match , and meron akong another sheet na nagcoconsolidate ng mga pending works using dynamic list na naka link din sa ibang excel , after ko na ginawa yung sheet na yun, lagi ng naghahang yung excel ko lalo na pag nagsasave.
Forum Topic
excel macro programming
-
centurysordie Send Message View User Items on July 09, 2015 08:59 AM - USER IS ONLINE
and meron akong another sheet na nagcoconsolidate ng mga pending works using dynamic list na naka link din sa ibang excel
This one is probably the main cause of the problem.
One solution is to remove the link and just copy the data of other excel file into your workbook.
Kapagka na copy na, pwede na siguro mag create ng link within your excel file. -
@ram2010
Sir do you mean , mas maganda if nasa isang workbook lang lahat ng excel files ko ? tama ba ? kailangan ko i consolidate lahat into 1 excel file and mag add na lang ako ng mga sheets ? -
@ram2010
Saka ask ko na din , if maglalagay bako ng ssd sa pc ko masosolved yung problem? -
centurysordie Send Message View User Items on July 09, 2015 11:18 AM
@ram2010
Sir do you mean , mas maganda if nasa isang workbook lang lahat ng excel files ko ? tama ba ? kailangan ko i consolidate lahat into 1 excel file and mag add na lang ako ng mga sheets ?
Depende rin ito kung ilang sheets ang e add mo. But you need to experiment. If possible avoid the links -
centurysordie Send Message View User Items on July 09, 2015 11:19 AM
@ram2010
Saka ask ko na din , if maglalagay bako ng ssd sa pc ko masosolved yung problem?
I am not sure, but I think this has to do with excel and your workbook, perhaps it is performing some calculations before saving.
Have a look here on excel specs and limits, baka may na exceed ka na, na limits dito sa workbook mo.
Excel-specifications-and-limits.
<click here for link> -
@ram2010
Thanks for the help sir , try ko magsimula sa umpisa ulit para ma minimize yung links pero i think hindi ko siya maavoid , thanks ng marami sa tulong. -
Guys tanong ko lang gano katagal nyo inaral yung basic ng VBA ?
-
centurysordie Send Message View User Items on July 10, 2015 09:15 AM - USER IS ONLINE
Guys tanong ko lang gano katagal nyo inaral yung basic ng VBA ?
Dati yong bihira pa ang internet, matagal din siguro mga 2 weeks. At kailangan ang maraming exercises.
Ngayon sandali na lang, marami ka nang makikitang examples na similar sa gusto mo.
But it all started in using excel. -
Dati yong bihira pa ang internet, matagal din siguro mga 2 weeks. At kailangan ang maraming exercises.
Ngayon sandali na lang, marami ka nang makikitang examples na similar sa gusto mo.
But it all started in using excel.
Thanks for the info , may onting knowledge naman ako sa excel , try ko lang i explore tong vba mukhang kakailanganin ko kasi :) -
Question sirs baka may makatulong. May access database ako, pano gawing source yun ng Excel? Bale gagawa ako ng user form na may filter ng dates. Tapos based dun sa dates entered, yun lang yung maeexport from Access/ Thanks!
-
sir ram, thank ulit sa mga tulong mo! sa uulitin :)
-
migsvill Send Message View User Items on July 22, 2015 12:31 PM
Question sirs baka may makatulong. May access database ako, pano gawing source yun ng Excel? Bale gagawa ako ng user form na may filter ng dates. Tapos based dun sa dates entered, yun lang yung maeexport from Access/ Thanks!
Export data to excel from access.
<click here for link> -
Visit <click here for link>
-
Mga Bossing ask lang po sana Paano gawin sa excel to?
Macro code or simple formula will do.
Help please. Ito po need ko mapalabas
if nag input po ako sa isang cell A1 or textbox ng amount na
1200 lalabas po sana sa cell B1 or isang textbox is 7.5.
Need po help... Thanks po sa makakatulong.
1-1,000.00 5.00
1,000.01- 1,500.00 7.50
1,500.01 - 2,000.00 10.00
2,000.01 - 2,500.00 12.50
2,500.01 - 3,000.00 15.00
3,000.01 - 3,500.00 17.50
3,500.01 - 4,000.00 20.00
4,000.01 - 4,500.00 22.50
4,500.01 - 5,000.00 25.00
5,000.01 - 5,500.00 27.50
-- edited by Zendrix on Aug 14 2015, 01:53 PM -
@Zendrix
Like this one po?
Vlookup reference on the right side :D
-- edited by channelsurfer on Aug 14 2015, 02:34 PM -
@channelsurfer
Thanks sir... hehehehe di ko rin tinigilan kanina yan. nakuha ko rin using lookup formula lang.. almost same din tayo sa vlookup mo. thanks bro. -
Hi Gurus,
Any idea how do i arrange this base on their value/coordinate..
the input is.
x y description
---------------------
2 10 Hello
1 10 Hi
3 10 Ok
output should be.
---------------------
Hi Hello Ok
Thanks for those will reply -
---y
----|
----|
10 -|----Hi----Hello---Ok
----|
-5 -|
----|
----------------------------- x
----0----1------2------3----
The plot should be like that. In that case it is already arranged.
-- edited by ram2010 on Sep 16 2015, 05:20 PM -
what function should i use?
-
@dotdll is that really X, Y coordinate or Row and Column placement?
Kung Row and Column placement yan then you can use this code.
Dim xCoor, yCoor As Integer
Dim strInput As String
xCoor = \'Set values here from form object\'
yCoor = \'Set values here from form object\'
strInput = \'Set values here from form object\'
Sheet1.Cells(xCoor,yCoor).Value = strInput
-- edited by botsblitz32 on Sep 17 2015, 10:27 PM -
dotdll Send Message View User Items on September 17, 2015 09:19 AM
what function should i use?
Tried sample plot with linear formula.
-
help naman po tinry ko po iformula kaso di kaya eh. kailangan ko po kasi ng VBA code para dito.
Column B(Date) Column C(Activity) Column D(Start Time) Column E(End Time)
10/07/2015 Reconciliation 13:00:52 13:05:12
10/07/2015 Onboarding 13:05:12
bali pag yung \"Column C\"(ex. C8) eh nilagyan ng data, Column B(Date) and D(Start Time) eh kailangan magkaroon ng time stamp \"NOW()\". and then pag nag add ng data sa baba ng C8 which is \"C9\" dapat maupdate yung Column B(Date) and D(Start Time) na magkaroon ng time stamp pati yung column E (\"E8\") (End Time) eh dapat din magkaroon ng time stamp so on and so forth po.
Your help will be gladly appreciated, please help I need this badly. -
up
-
up
-
up
-
up
-
Here is a custom function, insert a module and paste it.
Public Function add_date_and_time(ByRef cellref As Range)
If cellref.Value <> \"\" Then
add_date_and_time = Now()
Else
add_date_and_time = \"\"
End If
End Function
Sample guide
1. In column B at row 2 type
= add_date_and_time(c2)
2. In column D, row 2 type
= add_date_and_time(c2)
3. In column E, row 2 type
= add_date_and_time(c3)
4. Format column B for date
5. Format column D and E for time
6. You can now fill up activity under column C starting at row 2.
7. Don\'t forget to copy the formula at columns B, D and E when
you write more activity in column C.
-- edited by ram2010 on Oct 09 2015, 08:05 PM -
@ botsblitz32 and ram2010
Bali ganito po ang scenario ito sample: bali yung x and y columns are their coordinates.
Ito po ang input:
Ito po bali ang ouput dapat, without the coordinates.
Thanks and more power sa lahat
-- edited by dotdll on Nov 18 2015, 09:58 AM -
need help with a simple formula in excel
let's say, cell A1 and B1.
if A1 is blank or with any other text, B1 can be blank.
however, if A1 = "closed", B1 should have a text.
an error message will prompt that B1 should not be blank and user won't be able to continue.
i have already tried it in Data validation, with no success.
btw, A1 has data validation list.
thanks in advance.