Search results for query: *

This is exactly what I needed! I didn't know you could use the named ranges in VBA--that made it so much simpler! THANK you so very much for all of your help, I understand so much better now and the larger sheet is fully functional. Thanks again!

Hi all, Thank you for the responses. I figured it would be easiest to upload a snippet of what I am trying to do. I'd like to enter a row on the MultiTest Tab cell D2, and have that row's information be pasted into the Single Test Tab. My current macro (shown above, with slightly altered...

Hello, I am still relatively new to coding and creating macros/code in Excel VBA, so please excuse the lack of knowledge and/or coding language. I have 750 rows of information with columns staying static. I need to send information in certain cells to another worksheet within the same...

Yes I meant 1820122. Thanks for pointing that out, and thanks for giving me something to translate into Access! I'll have to work the syntax a bit but otherwise it makes sense! I've finished school so this is not an assignment. I'm trying to learn VBA coding in an Access environment.

Hi Skip, Yes, my x2 values are between x1 and x3. Let me provide some sample data, sorry about that: x values (lookup)-----y values (lookup) 1820100------20000 1820150------ 19250 1820200------ 18500 1820250------...

I am trying to use Access VBA code to interpolate (linearly) and return values to a table. I am still very new to both Access and VBA coding, so please be kind and clear any responses--I appreciate it! Going off of this formula: y2 = [(x2-x1)(y3-y1)/(x3-x1)] +y1 My x2 column is in a table...

I have three signals from an acoustic data set that I am trying to plot on a frequency vs. wavenumber basis. I am very new to MatLab and need guidance. I have looked into this answer, but I need help relating it to my data...

I have three acoustic data sets z1, z2, z3 that are nx1 matrices. I would like to plot them in a spectrogram in Matlab. I am aware of the spectrogram function, but I am new to Matlab and unsure how three signals would work.

This works perfectly, and somehow I never knew about it. Thank you!

I want to create a code to have the user input a number, have the code search through a column of cells with these numbers, and report back the rows of data associated with the column if it matches the input number. Ideally these would be reported on a different spreadsheet. I am pretty clueless...