View Single Post
 
Old 06-18-2012, 08:30 AM
airartist74 airartist74 is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Jun 2012
Posts: 1
airartist74 is on a distinguished road
Default possible formula instead of marco or VB?

I have 2 spreadsheets and want to compare values to a predetermined number and then copy certain cells into another worksheet. I do not know which formula to use to get this accomplished the easiest way.
Example:
I have 41 groups that are broken down into 23 cells per group. Group A has 23 rows of info, group B has 23 rows of info and so on. I want to match the input of a cell that will be A, B C etc to one of the groups and then check to see if each cell in that group is full. If there is a blank, I need to copy extra info from the input row to the 2nd spread sheet in that group. Does this make sense?
Can anyone help?
Devin
Reply With Quote