Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pulling data from another sheet
Hi All, What I am trying to do, I think should be simple, but I cannot figure out a good way to do it. I have file 1 which is set up like so: Col A Col B 5000 product 1 5001 product 2 5002 product 3 Basically, any time someone enters a product in column B, column A gives the next highest integer. If there is no data in Column B, then column A for that row contains a 0. I have a second file which has the same set up, but with different products, and the numbers start with 6000. I want to set up a new file that will pull in the number from column a, unless it is a 0. then move to the second file, until it hits a zero there, then stop. In other words, the new file would look like: 5000 5001 5002 5003 <--- since this is the last number before 0, the next number 6000 would pull from file 2, and stop when it hit zero in that file. 6001 6002 Any ideas on how I could set that up in the new file, so that if someone enters a new product, my file would update? -- HouseofRahl ------------------------------------------------------------------------ HouseofRahl's Profile: http://www.excelforum.com/member.php...o&userid=25161 View this thread: http://www.excelforum.com/showthread...hreadid=563858 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pull data from another sheet based on certain criteria | Excel Discussion (Misc queries) | |||
Combining data from cells from several excel sheets to a new sheet | Excel Discussion (Misc queries) | |||
ranking query | Excel Discussion (Misc queries) | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
Automatic cell increment with data from sheet 1 to sheet 2 | Excel Worksheet Functions |