Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Copy and shift data automaticaly
Hi,
I'm wonder if there is a way to use native (prebuild) function to achieve the following: - In sheet 2 I have a list of products in column A and price of product in column B - In sheet 1 I want to select product with it's price Currently working fine with vlookup function. What I would like to add, is functionality that some products are related to each other means if I will select Product i.e. potato on sheet 1 from the list in sheet 2, I will create a special column C in sheet 2 with entry i.e. water which will determine my trigger that will add this product (water) automatically above my selected product (potato) and my product will be shifted down or up one row in sheet 1 Any idea? regards Karol |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Turn vertical data to horizontal data automaticaly | Excel Worksheet Functions | |||
Moving Data Automaticaly | New Users to Excel | |||
How do I copy all cell data between sheets automaticaly? | Excel Discussion (Misc queries) | |||
How do I get excel to copy one cell to another page automaticaly | Excel Discussion (Misc queries) | |||
How can we back up a permanant copy of an excel file automaticaly | Excel Discussion (Misc queries) |