User Profile
Winterkid
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
need help on making a VBA/Macro script for searching and compiling data.
Hi All, thank you for taking your time to see this message. I hope it make sense. i need help in create a VBA/Macro for searching data and compiling data. i have 2 excel, Excel Test is where all the monthly report and sample consolidation report is From Excel Test SheetName PL_CompanyA, BS_CompanyA, PL_CompanyB, BS_CompanyB, PL_CompanyC, BS_Company C. Each Sheet contain table as below not limited to the table A. For PLSheet it contain such information for each month 2023, every month when the report generated, the New month will be added. For example, Feb 2023 is the latest month. For this Excel,in PL_Company A, i will need to search for the latest month follow by Sales (Column A / Row 3) , then i will need to get the amount from (Column C / Row 3). Next i will need to search for Cost of sales (Column A / Row 6), then i will need to get the amount 6.00 from (Column C / Row 6). There will be alot of search in Column A for getting the different amount in each month and i will need to do for the same for PL_Company B and PL_Company C Sheets. Some have additional information to search from Column A. i believe i can modify once it. For BS sheet will contain such information. I believe i can do it once i know how to search and get the data from PL sheet. 2nd Excelsample consolidation report 2023_PL sheet,it contain table like this. From the data gotten from Excel Test PL sheet, i need to put them into here. I will need to search for Company A, follow by the month latest month. For example from the Excel Test the latest month is Feb, so i need to search for 2/28/2023. then from Sales that isthe amount 6.00 from (Column C / Row 6) in in Excel Test PL Sheet, I will need to put 6.00 into this 2023_PL sheet Column C Row 4. and this goes on for the rest. In my testing excel, i have done up to this code, which i am planning to get into the consolidation report excel. Sub Get_Data_From_File() Dim FileToOpen As Variant Dim OpenBook As Workbook Application.ScreenUpdating = False FileToOpen = Application.GetOpenFilename(Title:="Browse for excel file", FileFilter:="Excel Files(*.xlsx*),*xlsx*", MultiSelect:=False) If FileToOpen <> False Then Set OpenBook = Application.Workbooks.Open(FileToOpen, ReadOnly:=True) OpenBook.Sheets(1).Range("A5:D55").Copy ThisWorkbook.Worksheets("Sheet1").Range("A5").PasteSpecial xlPasteValues OpenBook.Close False End If Application.ScreenUpdating = True End Sub Thank you And many thank for taking your time to read and understand. please do reach out to me if you need to explaining.blocking calendar timeslot base on booking define time slot?
Hi, can i ask is there such way whereby on the booking services. i have pre-define on each days 1 hr time slot for 1 hr services. i would like this pre-defined timeslot to block on my outlook calendar, so that when my other colleague tried to arrange meeting they can not book that timeslot. Thank you for reading.Question/Solution on Archive backup for Sharepoint Files/Folder that is last modified * 1 year ago
HI All, can i check whether is there a solution whereby we can only archive backup sharepoint online files/folder that was not touch like 1 year ago?? understand there we are to backup sharepoint online as microsoft only provide the recovery for DR. but my director does not have the intention of increasing the sharepoint online space. as of now we are at 1TB out of 2.5TB. and he would like to only archive and remove any files/folders that is not touch for 1 year. thank you!Sharepoint Online Calculated column
Hi All, I am currently trying to use calculated columns whereby to do calucaltion. I want the calculated Column TotalAmountSGD, to calculated IF the Currency is SGD then Calculate the Cost of the, Else Currency is Not SGD then Calculate ConvertedSGDRate. can i know what is the correct formula should i put Currency Cost ConvertedSGDRate TotalAmountSGD(Calculated Column) SGD 100 100 SGD 200 200 YEN 18000 176.4 176.4 USD 50 71.78 71.78 YEN 8000 79.01 79.01 SGD 50 50 MYR 100 25 25 USD 150 1545.71 1545.71
