Q
Quirrell
I am a new user to excel formula creation and I need to import a named
range from a closed sheet based on the date of the current sheet. the
general criteria is:-
1 The imported data must be the one with the nearest date to the
current sheet, in this case the previous weeks sheet
2 the imported data must be converted from the formula that creates the
data (IE sum x:x) to the results of the formula only
3 I need a confirmation dialog containing the name of the file from
which the data is being extracted incl. the name range and accept yes
or no options
Another alternative would be a dialog box giving me the option of which
file to import from but locking the range to import
basic mechanics go like this -
1 Find the nearest sheet previous to this one (based on date)
2 Copy the results of the range "Total"
3 Insert the results into the range "Previous"
4 Lock range
Any help much appreciated
range from a closed sheet based on the date of the current sheet. the
general criteria is:-
1 The imported data must be the one with the nearest date to the
current sheet, in this case the previous weeks sheet
2 the imported data must be converted from the formula that creates the
data (IE sum x:x) to the results of the formula only
3 I need a confirmation dialog containing the name of the file from
which the data is being extracted incl. the name range and accept yes
or no options
Another alternative would be a dialog box giving me the option of which
file to import from but locking the range to import
basic mechanics go like this -
1 Find the nearest sheet previous to this one (based on date)
2 Copy the results of the range "Total"
3 Insert the results into the range "Previous"
4 Lock range
Any help much appreciated