Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Mutilpe sheet , multiple formula help please.
I have 1 of 3 worksheets that I would like to have the cells transfer to
specific cells in the other 2 worksheets in very different manners. The worksheets are much larger then these, but this is the general idea. Each worksheet has multiple named sections. Which cells that have information and which will be blank will change every week in worksheet 1. Worksheet 1 AB 1 2 3 4 a xyz b rst c d AC 1 2 3 4 f g h rst i xyz Worksheet 2 AD 1 2 3 4 a AB b c d AC AE 1 2 3 4 f g AB h AC i Worksheet 3 AF 1 2 3 4 a xyz b rst c d AG 1 2 3 4 f rst g xyz h i Part 1: I only enter information in Sheet 1. I would like Sheet 2 to scan Sheet 1 and whenever a cell has it a certain word "xyz I need it to transfer the section name to the relative position Sheet 2 , Section AD. If it should have a different word "rst" it would transfer the section name to Sheet 2, Section AE. An error message if that cell already has information in it would be a nice bonus. Part 2: Worksheet 3 is just a list of all filled cells in each section of worksheet 1 with no relation to the grid. This is an "exact word" transfer between sections. Section AB to Section AF and Section AC to Section AG, but just in a list form top to bottom, right to left. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Linking References from Multiple Sheets to One Summary Sheet | Setting up and Configuration of Excel | |||
Copy formula...sheet 2 sheet | New Users to Excel | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) |