Latest Discussions
CHANGE IMAGE WHEN I SELECT ANOTHER NAME ON LIST BOX
Hi, there a way to change the image on userform when i select another name on listbox? I have a shape that change on the worksheet when i select a name on listbox, but on Userform only change when i initialize. The images are in another tab. Here the code on the project: Private Sub UserForm_Initialize() Dim cObj As ChartObject, iPath Application.ScreenUpdating = False With ActiveSheet.Shapes("Imagem 1") Set cObj = ActiveSheet.ChartObjects.Add(.Left, .Top, .Width, .Height) .Copy: cObj.Select: cObj.Chart.Paste iPath = Environ("Temp") & "\" & Format(Now, "hhmmss") & ".jpg" cObj.Chart.Export iPath End With Image1.Picture = LoadPicture(iPath) cObj.Delete End Sub Excel 365, Windows,System 64, NotebookWLLIANNov 10, 2024Copper Contributor56Views0likes4CommentsTransfer Quicken Data into Weekly Report
1/2/2024 1893 Res PAYPAL TRANSFER 240206 Tithe 650.15 1/3/2024 1893 Res PAYPAL TRANSFER 240213 Tithe 96.62 1/4/2024 3022 Youth DEPOSIT MADE IN A BRANCH/STORE Donation 25 1/4/2024 2104 Main DEPOSIT MADE IN A BRANCH/STORE Tithe 0 1/8/2024 2104 Main DEPOSIT MADE IN A BRANCH/STORE Tithe 690 After converting CSV into Excel format and filtering the above, the data represents what must be placed into the appropriate account (column), totaled, and then totaled into weekly segments. We need a formula for a year's worth of data to accomplish this task. There are two other columns not included: 9542 BkSt, and Bldg Fund Week Ending 2104 Main 1893 Res 3022 Youth Total 1/1/24 - 1/6/24 1/7/24 - 1/13/24 1/14/24 - 1/20/24 1/21/24 - 1/27/24 1/28/24 - 2/3/24 2/4/24 - 2/10/24 2/11/24 - 2/17/24 2/18/24 - 2/24/24 2/25/24 - 3/2/24 3/3/24 - 3/9/24 3/10/24 - 3/16/24 3/17/24 - 3/23/24 3/24/24 - 3/30/24 3/31/24 - 4/6/24 4/7/24 - 4/13/24 4/14/24 - 4/20/24 4/21/24 - 4/27/24 4/28/24 - 5/4/24 5/5/24 - 5/11/24InThoughtNov 10, 2024Occasional Reader1View0likes0CommentsCreating Automated Amendment/Edited Date
Hi There All Just wanted to see if it would be possible to create an automated amendment date on multiple sheets. There are multiple people that edit these shared documents and I would like to see when it was last edited by someone. If this is possible could you please help me out with a solution!GriffinmonNov 10, 2024Copper Contributor27Views0likes4CommentsSearch for multiple keywords in Excel?
Hello, I have a column with many rows containing different texts. I would like to be able to search all the rows in that column for any one of a number of different keywords. For example: I wish to find the rows that contain any of the following keywords: alfa beta gamma But it might not be an exact match. One row might have the following text: find-alfa-value In this case, I want the formula to find this row, as the row contains the keyword "alfa". Thanks!SolvedadminragnarNov 10, 2024Copper Contributor41Views0likes5Comments- ahmedelmessery9Nov 10, 2024Copper Contributor3.3KViews0likes4Comments
Trying to sort by dates entered in 2 different columns
So I have data in 8 different columns. 4 of those columns will have dates in them and as you can see from the image, the dates won't exactly match most of the time. So, I'm trying to get ALL of the data (dates and amounts) to be sorted in chronological order in columns I/J. Also, not all the columns will have data in it all the time, data starts on row 6 and can go up to row 600. Can this be done using a formula? Not sure if there's a macro out there that will do thisDaButcherNov 10, 2024Occasional Reader20Views0likes3CommentsDate Formatting Won't Change
I have an excel column that includes dates currently formatted as MM/DD/YYYY. I want it formatted as YYYY/MM/DD. When I go to format cells and change the date format, nothing changes. If I try to change the cells to any other type of cell - general, text, number, time, whatever - nothing changes. Please help.SolvedSteve GouldNov 10, 2024Copper Contributor1.1MViews1like82CommentsPosting a date based on an event
Hello Forum, Does any one know of a way thru a formula to post a date into a cell based on an event happening on other sheet. I have a sheet that makes a random selection of people from my roster whereby I copy the selection and paste the values into cells on the same sheet in a different column. The thing is however, I have another Sheet in the same workbook that I need to have the selection date, the paste event date, based on the selection of the individual(s), placed/posted/dropped into the appropriate column/cell as applicable. Can anyone help me out with this? CarlCarl_61Nov 10, 2024Iron Contributor78Views0likes3CommentsExcel Workbook Link Source from 1 workbook tab to another
Hi, I've seen some similar posts but not sure if what I am looking for is correct. But here goes. Because it involves work, I'll say Workbook A and B. The idea is taking Tab 1 of Workbook A and linking it into Tab 3 in Workbook B and then have it automatically refresh when we update Workbook A Tab 1. Now I understand that this has to be a workbook link source. I did try and highlight all of Tab 1 Workbook A and then Pasted it into the Tab 3 of Workbook B and I was able to do Paste > Link Source and click on automatic refresh.But all I got was #Connect in all the cells of that tab. So I'm not sure if I was on the right track and I simply need whoever created Workbook A's permission to do this or I need to do something else.heathernashifNov 10, 2024Copper Contributor56Views0likes1Comment