Forum Discussion
Formula for Extracting Data
Formula for Extracting Data I have had a bit of trouble developing a formula to bring/copy data (of the last entry in a column) to another location. Very dependent on the last date of entering data...
- As you see the last row of data is synced with the 9/07/2022 date. This data changes daily. This last row of dated data is to be transcribed to a daily summary sheet given to doctors. The summary sheet represents up-to-date date of a patient. The problem is transcribing last minute data from each column to the summary sheet automatically. Note that the other raw data columns are transcribed to the summary sheet in a different manner
So far none of the suggestions worked particularly on a larger scale
- If you're able to upload a sample workbook, it will help you get a quicker solution. There's plenty of people willing to help but some don't have enough time to do the legwork of building a sample.
