I have an excel file where when I try to pull data from a cell from one sheet to another, I get a major stall. It only happens from one particular sheet to two particular sheets in that order….no other sheets have this delay. Any idea? The same exact workbo...
Rick_Lehnen This is the idea: data is a dynamic range =LET(c,WRAPROWS(TAKE(data,,1),4),e,WRAPROWS(TAKE(data,,1),4),VSTACK(TAKE(c,,1),TAKE(e,,1))) Here is what the formula is doing: If you're getting an error in your workbook, you'll have to provide some detai...
1. When I run the macro the table column descriptions I have in A3:AA3 get erased. I would like them to stay. 2. The source has a lot of formulas in the cells, I would like to ignore rows that may have formulas but don't display any info (example: I have a bunch of c...
. We've got lots of great SQL Server experts to answer whatever question you can come up with. All Forums Development Tools Other Development Tools Pulling data from SQL into a VBA variable
occasionally based in Ireland. MS-Off Ver O365 (PC) V 2406 Posts 44,662 Re: Pulling data across sheets in workbook Try: =FILTER(Squad!$D$4:$D$42,Squad!$B$4:$B$42='Squad Depth'!E13) same copy/paste to the other cells. At each position, the results automatically spill down. ...
Hi,I have an excel workbook where I keep track of production, each day we make one of several products, and the calculations, instructions, and notes of a...
Thanks for your reply, sorry didn't really make myself very clear - I think that I made it more complicated than it needed to be. What I need to know if it's possible with one formula to autofill all of the various cells in the summary sheet (copy attached) with the correspo...
Re: Transferring a thread from google sheet to excel and is not pulling the data Basically I have a list of data in Sheet 3 Row A cell 2-unlimited that has blank cells in between the data. I want to pull that data into Sheet 1 Cell C 30 and...
Thanks for the help. It works perfect as set up. I'm having problems trying to use the same formula but pulling the data from other sheets. Eventually, the data set that the state information is being pulled from will exist in another sheet. Hopefully I can figure it ...
Pulling a vale based on two cells containing the same value. This is my first time posting a question. I searched multiple forums and I have not been able to properly enter a formula that works. Columns A, B, and C contain the data I am trying to match ...