Posts by woodstock1984

forum.ozgrid.com/index.php?attachment/71980/I have a spreadsheet that I need to show certain rows of data automatically from the master sheet on to 5 different tabs if column A has a number 1-5

So on the master data tab all the information is entered, I need
all row data that has a '1' in column A to be copied on to tab TW
all row data that has a '2' in column A to be copied on to tab JoS
all row data that has a '3' in column A to be copied on to tab JoM
all row data that has a '4' in column A to be copied on to tab JaS
all row data that has a '5' in column A to be copied on to tab KL

I hope this makes sense?!

Re: Show a particular letter/value if a specific cell is included with one of the lis

Thank you, you are a star!

Hi

I have been struggling with this for a while and you haven't let me down before!!
I have 5 lists, each with unique values. What I need is if a given cell starts with one of these unique values, indicate which list it comes from?!

I have attached a file for you to look at.

on tab 'All' call 'A3' I need a TW to show in that cell this is because cell 'E3' text 'A CARBON' begins with 'A C' which is included in TW list on tab 'Lists'

Thank you for your help

Re: VBA copy certain cells in a range that have specific criteria

This is brilliant thank you, but how do I repeat the formula or extend the list down on the CHQ column?

thank you once again

Re: VBA copy certain cells in a range that have specific criteria

As requested, thank you[ATTACH=CONFIG]71906[/ATTACH]

Re: VBA copy certain cells in a range that have specific criteria

can you not open the attachments by double clicking them?

^Hi

^{I'm struggling with my formula functions on Excel. Here is what I need:}

^{On a summery tab (REC), I need to show only data from source tab (CHQS) with certain data in column A (x)}

^{I only need to show column D and E data from the CHQS tab with an x in the A column and have it show on to the REC tab in cell G and H 16 and running down. If there is no 'x' in column A on the CHQS tab I don't want it to show on the REC tab?!
I have attached the CHQS tab and what I want the REC tab to look like?}
[ATTACH=CONFIG]71904[/ATTACH][ATTACH=CONFIG]71905[/ATTACH]

^{Thank you in advance}