Hi excel expert
Attached is the sample file.
Basically I have a number in column A, just wondering is that any faster to allocate the number into individual cell as shown in the attached file.
Regards
Hi excel expert
Attached is the sample file.
Basically I have a number in column A, just wondering is that any faster to allocate the number into individual cell as shown in the attached file.
Regards
Re: Count Days Between Two Dates But Exclude Certain Dates
RichardSchollar
This is what I looking for. Thanks
PCI
Noted your point
Dear Excel Expert
I have tried networkdays. But it does not serve what I want.
I would like to know is any any UDF in excel would calculate the number of days between two dates without excluding weekend and at the same time, it is also taking into the consideration of a lists of dates to be excluded.
Regards
Re: Unprotect Column
Good day thomach
Thank for the help. Is that any way that I could direct to worksheet B of defined column to unprotect, e.g when I input "B" in cell A3 in worksheet A, then column B in worksheet B would be unprotected.
Thanks
Dear Excel Expert
I have a workbook which consists of two worksheets, namely A and B. B is the protected worksheets. Just wondering is that possible for me to input a value, e.g A in cell A1 in worksheet A to unprotect column A in worksheet B.
Regards
Re: Not Showing Full Data In A Field
GeorgS
Thank for your opinion. Managed to convince our in-house consultant to convert the data into separate fields. Your idea is great. :>
Dear Access Expert
Can I know how can I open another access database from the existing access database ? Can this be done via code instead of closing the existing one then proceed to open the second database.
Re: Formula Link To Access
Hi WillR
The code behind is shown at the below thread.
Re: Formula Link To Access
Hi AL
I am agreed with you. The formula cannot handle two cells references. I did try your option 2. It works.
Perhap, we need some expert here to offer their assistance to re-design the formula.
Thank for your help.
Re: Formula Link To Access
Hi AL
I getting #VALUE! when I used A1&B1 . Have studied the links that you provided. Still could not find out any hints.
Re: Formula Link To Access
Hi AL
Assume A1 = DD and B1 = DE, if I put the formula as =A1&B1, then it would become DDDE.
Therefore, I not quite understand why the below formula is workable if A1 = DDDE
=DBVLookUp("tblAccountMapping","AccountNumber",A1,"AccountDescription")
If I changed the format by assuming A1 = DD and B1 = DE, and I put the formula as below, then the formula is not workable.
=DBVLookUp("tblAccountMapping","AccountNumber",A1&B1,"AccountDescription")
Perhap the above explaination is clear enough.
Dear Excel/Access expert
Not quite sure whether I post the question to the right forum, as it involved Excel as well as Access. Sorry for the inconvenience caused.
I have a database and use the below formula to extract figures from Access.
=DBVLookUp("tblAccountMapping","AccountNumber",A1,"AccountDescription")
Can I know why the formula is not working properly when I changed the formula to:
=DBVLookUp("tblAccountMapping","AccountNumber",A1&B1,"AccountDescription")
Basically, the lookup parameters of A1 and A1&B1 are the same.
Re: Not Showing Full Data In A Field
Hi
We do have the in-house IT consultant that helping us to use SQL to extract the information from Oracle and then download into Access.
If there is no solution, I think I would download it into excel and then perform some adjustment, then upload the data into access.
Dear Access Expert
Please refer to the attached file, field 3 is the data downloaded from oracle, however it shown only RAM ENTERPRISE. By right, it should be the data shown as below. Therefore, would like to know is that any to solve this data structure problem.
RAM ENTERPRISE
SYA/2116
PV : PTG/1200/07/09/M112
Dear expert
I have a workbook which consists of difference worksheets that downloaded from the system, e.g Jac01, JKen01 and so on. the worksheets' name might varies and from month to month basis. Therefore, just wondering is that a fast way to save the individual sheet as a separate workbooks. The rational of saving the worksheets into individual workbook is mainly for the individual division manager to study their respective product sales.
Dear excel experts
Would like to know is that possible to use sumproduct function in excel to extract some data from access database.
Dear Excel Experts
Would like to know is that any faster way to select those cells (non-continous) that highlighted with yellow or read colour. Thanks
Re: Move Data To Row
Yes agreed with you. It has a abnormal pattern. But this is how it looks like when I downloaded the data from system. Just wondering can I use the non-blank field (column1 of the table) as a base to decide what should be transposed.
Dear Excel Expert
I have attached a sample file and would like to have the expected format as shown in the attached. Would greatly appreciate if someone could show me the faster way of reformating the data instead of doing it manually. Thanks
Hi
Would like to know is that a way to assign a primary key to the raw data in access when I imported the data from excel to access. Thanks