B
BobT
I have an excel file with at least two worksheets.
Worksheet-2 is linked to Worksheet-1 in order to capture data I nee
for specific locations. Worksheet-2 was built by highlighting info
wanted from Worksheet-1, doing a COPY, then a PASTE SPECIAL ont
sheet-2. Before hitting OK, under Paste Special I was then able t
select an option to link this data from sheet-1 to sheet-2.
Next, I went to a column (G) sheet-2 that lists a number of location
(shops) and performed the excel AUTOFILTER function in order to sho
only inventory for a particular location.
It accomplishes some what what we are looking for but there are tw
questions remaining:
1. It seems if we want the list on sheet-2 to get updated we must go t
the Autofilter tab on (sheet-2 column-g) and reselect the filte
desired for example (shop#1) everytime.
It works, it refreshes with any updates or changes from sheet-1 bu
it's not automatic you have to remember to reselect the AutoFileter ta
on that column to update sheet-2.
Anyway to automate this? Does anyone have any ideas ?
2. My second question is this. After the PASTE Special operation blan
fields in sheet-2 show with zero's instead of being blank like o
sheet-1. A typical cell formula or reference on sheet-2 might loo
something like this: --> =Inventory!B1 or =Inventory!B2 etc.
I looked under FORMAT CELLS and did not see anything so as to not sho
zero's in sheet-2's cells but instead leave blank. Leave them blan
but still referenced/linked to sheet-1. IFBLANK maybe, that could wor
but would be some work for all the cells, I did'nt know if there was
formatting change etc that I could make. P.S - The format of th
various cells in Sheet-1 (the master table) is fine, they are blank i
there is no value in them.
Anyone know any answer to this?
BTW: Earlier I did post a thread with these two simular questions i
the 'Excel Miscellaneous Forum' as well. I have not gotten an answer o
the latest two questions above as yet, I wondered anyone in this grou
'Excel Worksheet Functions' might be able to help me out.
Thanks to all in advance ! :
Worksheet-2 is linked to Worksheet-1 in order to capture data I nee
for specific locations. Worksheet-2 was built by highlighting info
wanted from Worksheet-1, doing a COPY, then a PASTE SPECIAL ont
sheet-2. Before hitting OK, under Paste Special I was then able t
select an option to link this data from sheet-1 to sheet-2.
Next, I went to a column (G) sheet-2 that lists a number of location
(shops) and performed the excel AUTOFILTER function in order to sho
only inventory for a particular location.
It accomplishes some what what we are looking for but there are tw
questions remaining:
1. It seems if we want the list on sheet-2 to get updated we must go t
the Autofilter tab on (sheet-2 column-g) and reselect the filte
desired for example (shop#1) everytime.
It works, it refreshes with any updates or changes from sheet-1 bu
it's not automatic you have to remember to reselect the AutoFileter ta
on that column to update sheet-2.
Anyway to automate this? Does anyone have any ideas ?
2. My second question is this. After the PASTE Special operation blan
fields in sheet-2 show with zero's instead of being blank like o
sheet-1. A typical cell formula or reference on sheet-2 might loo
something like this: --> =Inventory!B1 or =Inventory!B2 etc.
I looked under FORMAT CELLS and did not see anything so as to not sho
zero's in sheet-2's cells but instead leave blank. Leave them blan
but still referenced/linked to sheet-1. IFBLANK maybe, that could wor
but would be some work for all the cells, I did'nt know if there was
formatting change etc that I could make. P.S - The format of th
various cells in Sheet-1 (the master table) is fine, they are blank i
there is no value in them.
Anyone know any answer to this?
BTW: Earlier I did post a thread with these two simular questions i
the 'Excel Miscellaneous Forum' as well. I have not gotten an answer o
the latest two questions above as yet, I wondered anyone in this grou
'Excel Worksheet Functions' might be able to help me out.
Thanks to all in advance ! :
