I want to link cells to another sheet based on value
on sheet1 thers a coumn of celss with values "numbers"
if the cells caintain the word "FAILED" I want it to take corresponding cells in that row "D and E" and copy their value to cells A abd B in sheet 2... any way to do this?
To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.
To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"
Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi
Assuming your column of numbers is column A then in A2 on Sheet2
Formula:
Please Login or Register to view this content.
..and similarly in B2
Formula:Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
thx man that's what I needed
is ther any way to make it keep the info condenced? so that it doesn't have gaps?
Hi,
If I understand your updated request correctly, rather than using a formula it sounds like you should be using Data Advanced Filter and extracting the sheet1 values that meet the criteria to sheet 2.
ok here is my file..
X and y Coordinates are in cells D and E on Raid Info sheet
Cell F has the values that rangfe from FAILED, and NUMBERS
on Map Data Sheett I have 3 sets of coumns
all of them have the formula u gave me with changes to meet my needs, although in Columns E and F I want it not to include the data points that have FAILED even though excel recognizes it as beign > 24738
I then want the newly extracted data to go into the map that I have next to it.. I can do the map
Hi,
Add a few spare rows on your Map Data sheet and create three criteria ranges using the column label 'Max for each one and the column labels x & y in each of columns A & B, C & D and E & F. on say row 5.
e.g. In A1 Max and in A2 "Failed"
Then use the Raid Info columns D, E & F as your Advanced data filter input range, and A1:A2 as the criteria table and A5:B5 as one of the extract ranges. Repeat for the criteria and output ranges for Low Resources and Good Raids.
what do u mean..can u show me it in a file..cuz I don't understand what u mean..sry :/
Hi,
See attached.
I've built the data filter stuff into a macro (just press the 'Filter data' button), but you should take half an hour or so to understand how you manually perform a data filter since this is an exceedingly common requirement.
Richard, is there any way to keep my filter drop-downs on the Raid info sheet?
because now when i run ur macro it removes them
Hi,
Just add the instruction
as the last line in the FilterData procedure
Please Login or Register to view this content.
but then it only keeps the filter drop downs on the 3 columsn max x y..waht bout teh rest of that row..and thx for the help man
could i jsut difine a new "Name" for all the cells?
imma try that
yep that worked..made a new name and changed teh auto fil;ter part to reference the new name..thx man..u helped teach me somethign
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks