Excel: Transfer Data Based On Condition

December 29, 2011 at 06:55:01
Specs: Windows XP
I am looking for a formula such that when I update a detail in one sheet, the update info gets automatically transferred to another summary sheet. The two arguments are that before the cell in the 2nd sheet gets automatically update it has to check whether the item code and the date match to that in the 1st sheet. I tried to paste my sheet here but the format looked too confusing. Is there someplace I could upload or mail my file?


See More: Excel: Transfer Data Based On Condition

Report •

January 8, 2012 at 20:36:23
Hi SamPatel,

I can probably help you with this. It sounds like you need a string of IF statements. If you can describe how the cells are arranged, I can help you with the formula. Is it set up similar to this?

Sheet1 A1 = item code
Sheet1 B1 = date
Sheet2 A1 = detail

If you have an ftp site or something, I will download your file and help. Just send me a private message with the location and information I need to download the file. If you don't have an ftp site, you might be able to use http://www.fileswap.com.

Report •

January 9, 2012 at 08:13:15
2 posting tips:

First, when posting in a Help forum such as this, please try to use a Subject Line that tells us something about your question. If everyone used a generic Subject Line such as "I Need Help" we wouldn't be able to tell one question from another and the Archives would essentially be useless.

I have edited the subject line of your post to show you what I mean. Scan the list of questions in this forum to see the types of Subject Lines that others have used.

Second, if you click on the blue line at the bottom of this post, you can read the instructions on how to post data in this forum so that the format is retained. It may take some trial and error via the Preview Follow Up button, as explained in the instructions, but it can be done.


Office Forum Moderator

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

Related Solutions

Ask Question